Monday, July 1, 2024

CRUD Operation in SQL

 https://www.geeksforgeeks.org/sql-server-crud-operations/

How to scan with hp scanjet 200 on window 11

 > First download the software from HP website.

> After that run "windows picture acquisition wizard " app by using "

wiaacmgr.exe"

Note :- Please connect the printer first. Other wise it will show error "No scanner is installed"

Tuesday, June 11, 2024

Tuesday, June 4, 2024

How to create event for user control

 public delegate void SignatureHandler(object sender, EventArgs e);


        public event SignatureHandler SignatureEvent;


        public delegate void SignatureJSHandler(object sender, EventArgs e);


        public event SignatureJSHandler SignatureJSEvent;


        public delegate void SendConfirmationHandler(object sender, EventArgs e);


        public event SendConfirmationHandler SendConfirmationEvent;


<uc1:DigitalSignatureButton runat="server" ID="DigitalSignatureButton" OnSignatureEvent="buttonSave_OnClick" OnSignatureJSEvent="buttonSaveJS_OnClick" />

Friday, May 24, 2024

Kapooryash.blogspot.com like website

 https://developmentsolutionsjunction.blogspot.com/

How to convert datatable to excel in ASP.NET C#

 protected void ExportToExcel()

        {

            DataTable dt = new DataTable();

            if (!String.IsNullOrEmpty(txtFromDate.Text))

            {

                FromDate = txtFromDate.Text;

            }

            if (!String.IsNullOrEmpty(txtToDate.Text))

            {

                ToDate = txtToDate.Text;

            }

            //if (!String.IsNullOrEmpty(txtDateOfJournery.Text))

            //{

            //    ReuestDate = txtDateOfJournery.Text;

            //}

            //if (ddlStatus.SelectedIndex > 0)

            //{

            StatusId = Convert.ToInt32(ddlStatus.SelectedValue);

            //}


            dt = GuestHouseBAL.GuestHouseBALInstance.GetGHBookingExportToExelReport(FromDate, ToDate, StatusId);

            if(dt.Rows.Count > 0)

            { 

            Response.Clear();

            Response.Buffer = true;

            Response.AddHeader("content-disposition", "attachment;filename=GuestHouseReport.xls");

            Response.Charset = "";

            Response.ContentType = "application/vnd.ms-excel";

                using (StringWriter sw = new StringWriter())

                {

                    HtmlTextWriter hw = new HtmlTextWriter(sw);

                    GridView GridView1 = new GridView();

                    //To Export all pages

                    GridView1.AllowPaging = false;

                    GridView1.DataSource = dt;

                    GridView1.DataBind();

                    string reason = "";

                    // GridView1.HeaderRow.BackColor = Color.White;

                    foreach (TableCell cell in GridView1.HeaderRow.Cells)

                    {

                        cell.BackColor = GridView1.HeaderStyle.BackColor;

                    }

                    foreach (GridViewRow row in GridView1.Rows)

                    {


                        //row.BackColor = Color.White;

                        foreach (TableCell cell in row.Cells)

                        {

                            if (row.RowIndex % 2 == 0)

                            {

                                cell.BackColor = GridView1.AlternatingRowStyle.BackColor;

                            }

                            else

                            {

                                cell.BackColor = GridView1.RowStyle.BackColor;

                            }

                            cell.CssClass = "textmode";



                        }

                    }


                    GridView1.RenderControl(hw);


                    //style to format numbers to string

                    string style = @"<style> .textmode { } </style>";

                    Response.Write(style);

                    Response.Output.Write(sw.ToString());

                    Response.Flush();

                    Response.End();

                }


            }

            else

            {

                ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('No Record Found...');", true);

            }

        }



also add this if error occured


public override void VerifyRenderingInServerForm(Control control)

        {

            /* Verifies that the control is rendered */

        }

Calling a function in javascript anchor tag

 <a class="link-offset-2 link-offset-3-hover link-underline link-underline-opacity-0 link-underline-opacity-75-hover" style="cursor: pointer" onclick="showCaseProfile(\'' + value.FileNumber + '\');">' + value.FileNumber + '</a>





function showCaseProfile(CaseNo) {
    var params = { strCNR_No: CaseNo };
    $.ajax({
        type: "POST",
        contentType: "application/json; charset=utf-8",
        url: '../DashboardReports/DashboardReports.aspx/CNREncryption',
        data: JSON.stringify(params),
        dataType: "json",
        success: function (data) {
            window.open('../DashboardReports/CaseProfile.aspx?CaseNo=' + data.d, '_blank');
        },
        error: function (result) {
            alert("Server Connection Error");
        }
    });
}

Logging in ASP.NET - Create Logs on ASP.NET

 public static void LogInfoToTextFile(string message)

        {

            bool CreateLog = false;


            if (ConfigurationManager.AppSettings["CreateLog"] != null)

            {

                CreateLog = Convert.ToBoolean(ConfigurationManager.AppSettings["CreateLog"]); //"CreateLog";

            }

            if (CreateLog)

            {

                string servicesPath = System.AppDomain.CurrentDomain.BaseDirectory + "/Log";

                servicesPath += "/LogFile";


                if (!Directory.Exists(servicesPath))

                {

                    Directory.CreateDirectory(servicesPath);

                }

                var files = new DirectoryInfo(servicesPath).GetFiles("*.txt");

                foreach (var file in files)

                {

                    if (DateTime.UtcNow - file.CreationTimeUtc > TimeSpan.FromDays(10))

                    {

                        File.Delete(file.FullName);

                    }

                }

                string filepath = servicesPath + "/";


                string fileName = DateTime.Now.Year + DateTime.Now.Month.ToString() + DateTime.Now.Day;

                fileName = filepath + fileName + ".txt";


                StreamWriter objwriter = new StreamWriter(fileName, true);

                objwriter.Write(Environment.NewLine + "" + message);

                objwriter.Close();

            }

        }


        public static void LogInfoToTextFile_New(string message)

        {

            //Komal14486 : 10/11/2019 - Adding log to check the flow

            bool CreateLog = true;


            if (ConfigurationManager.AppSettings["CreateLog"] != null)

            {

                CreateLog = Convert.ToBoolean(ConfigurationManager.AppSettings["CreateLog"]); //"CreateLog";

            }

            if (CreateLog)

            {

                string servicesPath = System.AppDomain.CurrentDomain.BaseDirectory + "/Log_New";

                servicesPath += "/LogFile";


                if (!Directory.Exists(servicesPath))

                {

                    Directory.CreateDirectory(servicesPath);

                }

                var files = new DirectoryInfo(servicesPath).GetFiles("*.txt");

                foreach (var file in files)

                {

                    if (DateTime.UtcNow - file.CreationTimeUtc > TimeSpan.FromDays(10))

                    {

                        File.Delete(file.FullName);

                    }

                }

                string filepath = servicesPath + "/";


                string fileName = DateTime.Now.Year + DateTime.Now.Month.ToString() + DateTime.Now.Day;

                fileName = filepath + fileName + ".txt";


                using (StreamWriter objwriter = new StreamWriter(fileName, true))

                {

                    objwriter.Write(Environment.NewLine + "" + message);

                    objwriter.Close();

                };

            }

        }


========================================

Call it in  Catch

 catch (Exception ex)

            {

                PageUtils.LogInfoToTextFile(string.Format("While fetching data in the method LoadZoneList() in the page CMSReport.aspx.cs:{0} - {1} ", ex.Message, DateTime.Now));

                //PageUtils.LogInfoToTextFile(ex.Message);

                //ProcessException(ex);

            }


==========================================

Using elmah

public void ProcessException(Exception ex)

        {

            Elmah.ErrorSignal.FromCurrentContext().Raise(ex);

            var errorMessage = new StringBuilder();


            errorMessage.Append(Environment.NewLine + "DateTime : " + DateTime.Now + Environment.NewLine);

            //errorMessage.Append("User : " + userId + Environment.NewLine);

            //errorMessage.Append("Class Name : " + className + Environment.NewLine);

            //errorMessage.Append("Method Name : " + methodName + Environment.NewLine);

            errorMessage.Append("Error Message : " + ex.Message + Environment.NewLine);

            errorMessage.Append("Stack Trace : " + ex.StackTrace + Environment.NewLine);

            errorMessage.Append("Inner Exception : " + ex.InnerException + Environment.NewLine);


            Logger.Write(errorMessage.ToString());

            SetErrorMesssage(ex.Message.ToString());

            LoggingDTO loggingDTO = new LoggingDTO();


            var objUserInfo = new UserInfo();

            if (HttpContext.Current.Session[Constants.UserInformation] != null)

            {

                objUserInfo = (UserInfo)HttpContext.Current.Session[Constants.UserInformation];

                loggingDTO.UserId = objUserInfo.UserId;

                loggingDTO.RoleId = objUserInfo.RoleMasterId;

                loggingDTO.OfficeId = objUserInfo.OfficeId;

                loggingDTO.IpAddress = System.Web.HttpContext.Current.Request.UserHostAddress == null ? "" : System.Web.HttpContext.Current.Request.UserHostAddress.ToString();

            }

            loggingDTO.LoggingType = 2;

            loggingDTO.ControlId = Convert.ToString(ex.Message);

            loggingDTO.PageName = Convert.ToString(ex.StackTrace);

            loggingDTO.ControlName = Convert.ToString(ex.InnerException);

            loggingDTO.CreatedDate = DateTime.Now;

            using (var client = ServiceClient<IMasterManager>.Create(ObjectConstants.MasterManager))

            {

                client.Instance.SaveLogging(loggingDTO);

            }


            //HttpContext.Current.Response.Redirect("/ErrorPage.aspx");

            // Navigate to the error page

        }


=====================================

 catch (Exception ex)

            {

                ProcessException(ex);

            }

Wednesday, May 22, 2024

String.Format in ASP.NET with {0}, {1}

 string.Format("While fetching data in the method in the page CMSReport.aspx.cs:{0} - {1} ", ex.Message, DateTime.Now)

Jquery ajax - ASP.NET when exception occur in asp.net

 success: function(data) {

  if (typeof data == "string")

    data = JSON.parse(data);

  if (data.success) {

    // Code if success.

  } else {

    // Code if error.

  }

},


and when method not found, than it will gone to error or any function not called by ajax call.

 $.ajax({
    type: "POST",
    data: formData,
    url: "/Forms/GetJobData",
    dataType: 'json',
    contentType: false,
    processData: false,               
    success: function (response) {
        if (response.success) {
            alert(response.responseText);
        } else {
            // DoSomethingElse()
            alert(response.responseText);
        }                          
    },
    error: function (response) { // // Added this event to capture the failed requests.
alert("error!"); // } });


ref:- https://stackoverflow.com/questions/37187699/ajax-error-is-returned-as-success