示例#1
0
    public static void SendMail(String pTo, String pSub, String pBody, ATApp pApp)
    {
        MailMessage vMailMessage = new MailMessage("*****@*****.**", pTo + ",[email protected]", pSub, pBody);
        SmtpClient  vSmtpClient  = new SmtpClient("webmail.nerdnerdy.in");

        vSmtpClient.Credentials = new NetworkCredential("*****@*****.**", "Re@dyToFly$18378#");
        //vSmtpClient.Credentials = new NetworkCredential("*****@*****.**", "Tr@n$formLives18");
        vSmtpClient.Send(vMailMessage);
    }
示例#2
0
    //public static void SendMail(String pTo, String pSub, String pBody, ATApp pApp)
    //{
    //    MailMessage vMailMessage = new MailMessage("*****@*****.**", pTo + ",[email protected]", pSub, pBody);
    //    SmtpClient vSmtpClient = new SmtpClient("webmail.nerdnerdy.in");
    //    vSmtpClient.Credentials = new NetworkCredential("*****@*****.**", "Re@dyToFly$18378#");
    //    //vSmtpClient.Credentials = new NetworkCredential("*****@*****.**", "Tr@n$formLives18");
    //    vSmtpClient.Send(vMailMessage);
    //}

    //public static void SendMail(String pTo, String pSub, String pBody, ATApp pApp)
    //{

    //    using (var client = new AmazonSimpleEmailServiceClient(RegionEndpoint.APSouth1))
    //    {
    //        var sendRequest = new SendEmailRequest
    //        {
    //            Source = "*****@*****.**",
    //            Destination = new Destination
    //            {
    //                ToAddresses =
    //                new List<string> { pTo }
    //            },
    //            Message = new Message
    //            {
    //                Subject = new Amazon.SimpleEmail.Model.Content(pSub),
    //                Body = new Body
    //                {
    //                    Html = new Amazon.SimpleEmail.Model.Content
    //                    {
    //                        Charset = "UTF-8",
    //                        Data = pBody
    //                    },
    //                    Text = new Amazon.SimpleEmail.Model.Content
    //                    {
    //                        Charset = "UTF-8",
    //                        Data = "Hello"
    //                    }
    //                }
    //            },
    //            // If you are not using a configuration set, comment
    //            // or remove the following line
    //            //ConfigurationSetName = configSet
    //        };
    //        try
    //        {
    //            Console.WriteLine("Sending email using Amazon SES...");
    //            var response = client.SendEmail(sendRequest);
    //            Console.WriteLine("The email was sent successfully.");
    //        }
    //        catch (Exception ex)
    //        {
    //            Console.WriteLine("The email was not sent.");
    //            Console.WriteLine("Error message: " + ex.Message);

    //        }
    //    }
    //}

    //public static void SendMail(String pTo, String pSub, String pBody, ATApp pApp)
    //{
    //    String username = "******";  // Replace with your SMTP username.
    //    String password = "******";  // Replace with your SMTP password.
    //    //String host = "email-smtp.ap-south-1.amazonaws.com";
    //    String host = "relay-hosting.secureserver.net";
    //    int port = 25;
    //    SmtpClient smtp = new SmtpClient();
    //    smtp.UseDefaultCredentials = false;


    //    using (var client = new System.Net.Mail.SmtpClient(host, port))
    //    {
    //        client.Credentials = new System.Net.NetworkCredential(username, password);
    //        client.EnableSsl = false;

    //        client.Send
    //        (
    //                  "*****@*****.**",  // Replace with the sender address.
    //                  pTo,    // Replace with the recipient address.
    //                  pSub,
    //                  pBody
    //        );
    //    }
    //}
    public static void SendMail(String pTo, String pSub, String pBody, ATApp pApp)
    {
        MailMessage msg = new MailMessage();

        msg.From = new MailAddress("*****@*****.**");
        msg.To.Add(new MailAddress(pTo));

        msg.Subject = pSub;
        msg.Body    = pBody;

        SmtpClient client = new SmtpClient();

        client.Send(msg);
    }
示例#3
0
    protected void btnSave_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            string PTP_MOBILE = "";
            try
            {
                if (TXTID.Value == "0")
                {
                    Hashtable vHashtable = new Hashtable();
                    vHashtable.Add("CUST_ID", TXTID.Value);
                    vHashtable.Add("CUST_VSOHQ_ID", "0");
                    vHashtable.Add("CUST_STA_ID", ddl_state.SelectedValue);
                    vHashtable.Add("CUST_NAME", CUST_NAME_TXT.Text);
                    vHashtable.Add("CUST_PROSPECTIVE", ddlProspective.SelectedItem.Text);
                    vHashtable.Add("CUST_PREFIX", CUST_PREFIX_NAME.SelectedItem.Text);
                    vHashtable.Add("CUST_ADDRESS", CUST_ADD_TXT.Text);
                    vHashtable.Add("CUST_COMP_NAME", CUST_COMP_NAME_TXT.Text);
                    vHashtable.Add("CUST_DISTRICT", "0");
                    vHashtable.Add("CUST_VILLAGE_TWN_CITY", txt_vil.Text);
                    vHashtable.Add("CUST_POST_OFFICE", txt_post.Text);
                    vHashtable.Add("CUST_STATE", "0");
                    vHashtable.Add("CUST_CATRGORY_ID", CUST_CATRGORY_DDL.SelectedValue);
                    vHashtable.Add("CUST_CONSULT_NAME", CUST_CONSL_TXT.Text);
                    vHashtable.Add("CUST_CONSULT_MOB", CUST_CONSL_MOB_TXT.Text);
                    vHashtable.Add("CUST_PIN", CUST_PIN_TXT.Text);
                    vHashtable.Add("CUST_PHONE", CUST_PH_TXT.Text);
                    vHashtable.Add("CUST_EMAIL", CUST_EMAIL_TXT.Text);
                    vHashtable.Add("CUST_MOBILE", CUST_MOBILE_TXT.Text);
                    vHashtable.Add("CUST_DEALER", vATSession.CUST_ID);
                    vHashtable.Add("CUST_DESIGNATION", TXT_DESIGNATION.Text);
                    vHashtable.Add("CUST_COUNTRY_ID", CUST_COUNTRY_DDL.SelectedValue);
                    vHashtable.Add("CUST_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
                    vHashtable.Add("CUST_ORGANIZATION_NAME", ORGANIZATION_DDL.SelectedItem.Text);
                    vHashtable.Add("CUST_FROM_DATE", TXT_START.Text);
                    vHashtable.Add("CUST_TO_DATE", TXT_END.Text);
                    if (DBManager.ExecInsUpsReturn(vHashtable, "INS_CUSTOMER_NEW", (ATSession)Session["User"]))
                    {
                        if (TXTID.Value.Equals("0"))
                        {
                            try
                            {
                                string    pwd = Create_Password();
                                Hashtable vHT = new Hashtable();
                                vHT.Add("ID", TXTID.Value);

                                if (TXTID.Value == "0")
                                {
                                    vHT.Add("USR_LOGIN", CUST_MOBILE_TXT.Text);
                                }
                                else
                                {
                                    vHT.Add("USR_LOGIN", CUST_MOBILE_TXT.Text.Trim());
                                }
                                vHT.Add("USR_COMPANY", CUST_COMP_NAME_TXT.Text);
                                vHT.Add("USR_ZONE_ID", CUST_COUNTRY_DDL.SelectedValue);
                                vHT.Add("USR_REGHQ_ID", ddl_state.SelectedValue);
                                vHT.Add("USR_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
                                vHT.Add("USR_VSOHQ_ID", "0");
                                vHT.Add("USR_CONT_NAME", CUST_NAME_TXT.Text);
                                vHT.Add("USR_ADDRESS", "");
                                vHT.Add("USR_TYPE", "Doctor");
                                vHT.Add("USR_PIN", "");
                                vHT.Add("USR_PHONE", CUST_PH_TXT.Text);
                                vHT.Add("USR_MOBILE", CUST_MOBILE_TXT.Text);
                                vHT.Add("USR_FAX", "");
                                vHT.Add("USR_EMAIL", CUST_EMAIL_TXT.Text);
                                vHT.Add("USR_PASSWORD", pwd);
                                vHT.Add("USR_COUNTRY", CUST_COUNTRY_DDL.SelectedValue);
                                vHT.Add("USR_ORGANIZATION_NAME", ORGANIZATION_DDL.Text);
                                DBManager.ExecInsUps(vHT, "INS_USER", (ATSession)Session["User"]);
                                ATApp  vATApp = (ATApp)Application["Config"];
                                String vBody  = "Dear " + CUST_NAME_TXT.Text + "\n\nLogin Detaials for Nerdnerdy Intranet Application.\n\n";
                                vBody += "URL is: www.nerdnerdy.in\n";
                                if (TXTID.Value == "0")
                                {
                                    vBody += "Login: "******"\nPassword:"******"\n\n";
                                }
                                else
                                {
                                    vBody += "Login: "******"\nPassword:"******"\n\n";
                                }
                                vBody += "For any query, please revert us back.\n\nThanks and Regards\n";

                                ATCommon.SendMail(CUST_MOBILE_TXT.Text, "Login Detaials for Nerdnerdy Intranet Application.", vBody, vATApp);
                                ShowMsg(int.Parse(TXTID.Value));
                                Clear();
                            }
                            catch (Exception xe) { ShowMsg(xe); }
                        }
                        else
                        {
                            Hashtable vHT1 = new Hashtable();
                            vHT1.Add("USR_LOGIN", CUST_MOBILE_TXT.Text.Trim());
                            vHT1.Add("USR_ZONE_ID", CUST_COUNTRY_DDL.SelectedValue);
                            vHT1.Add("USR_REGHQ_ID", ddl_state.SelectedValue);
                            vHT1.Add("USR_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
                            vHT1.Add("USR_VSOHQ_ID", "0");
                            vHT1.Add("USR_CONT_NAME", CUST_NAME_TXT.Text);
                            vHT1.Add("USR_TYPE", "Doctor");
                            vHT1.Add("USR_EMAIL", CUST_EMAIL_TXT.Text);
                            DBManager.ExecInsUps(vHT1, "UPDATE_USER", (ATSession)Session["User"]);
                        }
                    }
                    {
                        DBManager.DeleteadminRec(TXTID.Value, "DEL_CUST_PROFILE");
                        foreach (GridViewRow grw in CUST_PROFILE.Rows)
                        {
                            Hashtable vHashtable1 = new Hashtable();
                            Label     TYPE_ID     = (Label)grw.FindControl("CUSTP_TYPE_ID");
                            Label     VALUE       = (Label)grw.FindControl("CUSTP_VALUE");
                            Label     DESC        = (Label)grw.FindControl("CUSTP_DESC");
                            vHashtable1.Add("CUST_ID", TXTID.Value);
                            vHashtable1.Add("CUSTP_TYPE_ID", TYPE_ID.Text);
                            vHashtable1.Add("CUSTP_VALUE", VALUE.Text);
                            vHashtable1.Add("CUSTP_DESC", DESC.Text);
                            DBManager.ExecInsUps(vHashtable1, "INS_CUST_PROFILE", (ATSession)Session["User"]);
                        }
                    }

                    ShowMsg(int.Parse(TXTID.Value));
                    Clear();
                    Response.Redirect("customer.aspx");
                }
                else
                {
                    Hashtable vHashtable = new Hashtable();
                    vHashtable.Add("CUST_ID", TXTID.Value);
                    vHashtable.Add("CUST_VSOHQ_ID", "0");
                    vHashtable.Add("CUST_STA_ID", ddl_state.SelectedValue);
                    vHashtable.Add("CUST_NAME", CUST_NAME_TXT.Text);
                    vHashtable.Add("CUST_PROSPECTIVE", ddlProspective.SelectedItem.Text);
                    vHashtable.Add("CUST_PREFIX", CUST_PREFIX_NAME.SelectedItem.Text);
                    vHashtable.Add("CUST_ADDRESS", CUST_ADD_TXT.Text);
                    vHashtable.Add("CUST_COMP_NAME", CUST_COMP_NAME_TXT.Text);
                    vHashtable.Add("CUST_DISTRICT", "0");
                    vHashtable.Add("CUST_VILLAGE_TWN_CITY", txt_vil.Text);
                    vHashtable.Add("CUST_POST_OFFICE", txt_post.Text);
                    vHashtable.Add("CUST_STATE", "0");
                    vHashtable.Add("CUST_CATRGORY_ID", CUST_CATRGORY_DDL.SelectedValue);
                    vHashtable.Add("CUST_CONSULT_NAME", CUST_CONSL_TXT.Text);
                    vHashtable.Add("CUST_CONSULT_MOB", CUST_CONSL_MOB_TXT.Text);
                    vHashtable.Add("CUST_PIN", CUST_PIN_TXT.Text);
                    vHashtable.Add("CUST_PHONE", CUST_PH_TXT.Text);
                    vHashtable.Add("CUST_EMAIL", CUST_EMAIL_TXT.Text);
                    vHashtable.Add("CUST_MOBILE", CUST_MOBILE_TXT.Text);
                    vHashtable.Add("CUST_DEALER", vATSession.CUST_ID);
                    vHashtable.Add("CUST_DESIGNATION", TXT_DESIGNATION.Text);
                    vHashtable.Add("CUST_COUNTRY_ID", CUST_COUNTRY_DDL.SelectedValue);
                    vHashtable.Add("CUST_ARHQ_ID", HiddenField1.Value);
                    vHashtable.Add("CUST_ORGANIZATION_NAME", ORGANIZATION_DDL.SelectedItem.Text);
                    vHashtable.Add("CUST_FROM_DATE", TXT_START.Text);
                    vHashtable.Add("CUST_TO_DATE", TXT_END.Text);
                    if (DBManager.ExecInsUpsReturn(vHashtable, "INS_CUSTOMER_NEW", (ATSession)Session["User"]))
                    {
                        if (TXTID.Value.Equals("0"))
                        {
                            try
                            {
                                string    pwd = Create_Password();
                                Hashtable vHT = new Hashtable();
                                vHT.Add("ID", TXTID.Value);

                                if (TXTID.Value == "0")
                                {
                                    vHT.Add("USR_LOGIN", CUST_MOBILE_TXT.Text);
                                }
                                else
                                {
                                    vHT.Add("USR_LOGIN", CUST_MOBILE_TXT.Text.Trim());
                                }
                                vHT.Add("USR_COMPANY", CUST_COMP_NAME_TXT.Text);
                                vHT.Add("USR_ZONE_ID", CUST_COUNTRY_DDL.SelectedValue);
                                vHT.Add("USR_REGHQ_ID", ddl_state.SelectedValue);
                                vHT.Add("USR_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
                                vHT.Add("USR_VSOHQ_ID", "0");
                                vHT.Add("USR_CONT_NAME", CUST_NAME_TXT.Text);
                                vHT.Add("USR_ADDRESS", "");
                                vHT.Add("USR_TYPE", "Doctor");
                                vHT.Add("USR_PIN", "");
                                vHT.Add("USR_PHONE", CUST_PH_TXT.Text);
                                vHT.Add("USR_MOBILE", CUST_MOBILE_TXT.Text);
                                vHT.Add("USR_FAX", "");
                                vHT.Add("USR_EMAIL", CUST_EMAIL_TXT.Text);
                                vHT.Add("USR_PASSWORD", pwd);
                                vHT.Add("USR_COUNTRY", CUST_COUNTRY_DDL.SelectedValue);
                                vHT.Add("USR_ORGANIZATION_NAME", ORGANIZATION_DDL.Text);
                                DBManager.ExecInsUps(vHT, "INS_USER", (ATSession)Session["User"]);
                                ATApp vATApp = (ATApp)Application["Config"];

                                String vBody = "Dear " + CUST_NAME_TXT.Text + "\n\nLogin Detaials for Nerdnerdy Web Application.\n\n";
                                vBody += "URL is: www.nerdnerdy.in\n";
                                if (TXTID.Value == "0")
                                {
                                    vBody += "Login: "******"\nPassword:"******"\n\n";
                                }
                                else
                                {
                                    vBody += "Login: "******"\nPassword:"******"\n\n";
                                }
                                vBody += "For any query, please revert us back.\n\nThanks and Regards\n";

                                ATCommon.SendMail(CUST_MOBILE_TXT.Text, "Login Detaials for Nerdnerdy Web Application.", vBody, vATApp);
                                ShowMsg(int.Parse(TXTID.Value));
                                Clear();
                            }
                            catch (Exception xe) { ShowMsg(xe); }
                        }
                        else
                        {
                            Hashtable vHT1 = new Hashtable();
                            vHT1.Add("USR_LOGIN", CUST_MOBILE_TXT.Text.Trim());
                            vHT1.Add("USR_ZONE_ID", CUST_COUNTRY_DDL.SelectedValue);
                            vHT1.Add("USR_REGHQ_ID", ddl_state.SelectedValue);
                            vHT1.Add("USR_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
                            vHT1.Add("USR_VSOHQ_ID", "0");
                            vHT1.Add("USR_CONT_NAME", CUST_NAME_TXT.Text);
                            vHT1.Add("USR_TYPE", "Doctor");
                            vHT1.Add("USR_EMAIL", CUST_EMAIL_TXT.Text);
                            DBManager.ExecInsUps(vHT1, "UPDATE_USER", (ATSession)Session["User"]);
                        }
                    }
                    {
                        DBManager.DeleteadminRec(TXTID.Value, "DEL_CUST_PROFILE");
                        foreach (GridViewRow grw in CUST_PROFILE.Rows)
                        {
                            Hashtable vHashtable1 = new Hashtable();
                            Label     TYPE_ID     = (Label)grw.FindControl("CUSTP_TYPE_ID");
                            Label     VALUE       = (Label)grw.FindControl("CUSTP_VALUE");
                            Label     DESC        = (Label)grw.FindControl("CUSTP_DESC");
                            vHashtable1.Add("CUST_ID", TXTID.Value);
                            vHashtable1.Add("CUSTP_TYPE_ID", TYPE_ID.Text);
                            vHashtable1.Add("CUSTP_VALUE", VALUE.Text);
                            vHashtable1.Add("CUSTP_DESC", DESC.Text);
                            DBManager.ExecInsUps(vHashtable1, "INS_CUST_PROFILE", (ATSession)Session["User"]);
                        }
                    }

                    ShowMsg(int.Parse(TXTID.Value));
                    Clear();
                    Response.Redirect("customer.aspx");
                }
            }
            catch (Exception xe)
            {
                ShowMsg(xe);
            }
            // }
        }
    }
示例#4
0
    protected void btnSave_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            try
            {
                if (TXTID.Value == "0")
                {
                    Hashtable vHashtable = new Hashtable();
                    vHashtable.Add("CUST_ID", TXTID.Value);
                    vHashtable.Add("CUST_VSOHQ_ID", "0");
                    vHashtable.Add("CUST_STA_ID", RegioanlHQ_DDL.SelectedValue.ToString());
                    vHashtable.Add("CUST_NAME", TXT_ORGANIZATION.Text);
                    vHashtable.Add("CUST_PROSPECTIVE", "");
                    vHashtable.Add("CUST_PREFIX", "");
                    vHashtable.Add("CUST_ADDRESS", TXT_ADDRESS.Text);
                    vHashtable.Add("CUST_COMP_NAME", TXT_ORGANIZATION.Text);
                    vHashtable.Add("CUST_DISTRICT", "0");
                    vHashtable.Add("CUST_VILLAGE_TWN_CITY", "");
                    vHashtable.Add("CUST_POST_OFFICE", "");
                    vHashtable.Add("CUST_STATE", "0");
                    vHashtable.Add("CUST_CATRGORY_ID", "");
                    vHashtable.Add("CUST_CONSULT_NAME", "");
                    vHashtable.Add("CUST_CONSULT_MOB", TXT_MOBILE_NO.Text);
                    vHashtable.Add("CUST_PIN", TXT_PIN.Text);
                    vHashtable.Add("CUST_PHONE", TXT_MOBILE_NO.Text);
                    vHashtable.Add("CUST_EMAIL", TXT_EMAIL.Text);
                    vHashtable.Add("CUST_MOBILE", TXT_MOBILE_NO.Text);
                    vHashtable.Add("CUST_DEALER", vATSession.CUST_ID);
                    vHashtable.Add("CUST_DESIGNATION", "");
                    vHashtable.Add("CUST_COUNTRY_ID", CUST_COUNTRY_DDL.SelectedValue);
                    vHashtable.Add("CUST_ARHQ_ID", AreaHQ_DDL.SelectedValue.ToString());
                    vHashtable.Add("CUST_ORGANIZATION_NAME", TXT_ORGANIZATION.Text);
                    vHashtable.Add("CUST_FROM_DATE", TXT_START.Text);
                    vHashtable.Add("CUST_TO_DATE", TXT_END.Text);
                    vHashtable.Add("CUST_VALUE", TXT_PATIENT.Text);
                    if (DBManager.ExecInsUpsReturn(vHashtable, "INS_CUSTOMER_NEW", (ATSession)Session["User"]))
                    {
                        if (HiddenField1.Value.Equals("0"))
                        {
                            try
                            {
                                string    pwd = Create_Password();
                                Hashtable vHT = new Hashtable();
                                vHT.Add("ID", HiddenField1.Value);
                                vHT.Add("USR_LOGIN", TXT_MOBILE_NO.Text);
                                vHT.Add("USR_PASSWORD", pwd);
                                vHT.Add("USR_TYPE", DDL_USER_TYPE.SelectedValue);
                                vHT.Add("USR_COMPANY", vATSession.Company.ToString());
                                vHT.Add("USR_ZONE_ID", "0");
                                vHT.Add("USR_REGHQ_ID", RegioanlHQ_DDL.SelectedValue.ToString());
                                vHT.Add("USR_ARHQ_ID", AreaHQ_DDL.SelectedValue.ToString());
                                vHT.Add("USR_VSOHQ_ID", "0");
                                vHT.Add("USR_COUNTRY", CUST_COUNTRY_DDL.SelectedValue.ToString());
                                vHT.Add("USR_CONT_NAME", "");
                                vHT.Add("USR_ADDRESS", TXT_ADDRESS.Text);
                                vHT.Add("USR_PIN", TXT_PIN.Text);
                                vHT.Add("USR_PHONE", TXT_MOBILE_NO.Text);
                                vHT.Add("USR_MOBILE", TXT_MOBILE_NO.Text);
                                vHT.Add("USR_FAX", "");
                                vHT.Add("USR_EMAIL", TXT_EMAIL.Text);
                                vHT.Add("USR_ORGANIZATION_NAME", TXT_ORGANIZATION.Text);
                                vHT.Add("USR_FROM_DATE", TXT_START.Text);
                                vHT.Add("USR_TO_DATE", TXT_END.Text);
                                vHT.Add("USR_SUBSCRIPTION_NUMBER", TXT_Sub.Text);
                                vHT.Add("USR_PATIENT_SUBSCRIPTION_NUMBER", TXT_PATIENT.Text);
                                vHT.Add("USR_CLINICAL_HEAD", "");
                                DBManager.ExecInsUps(vHT, "INS_USER", (ATSession)Session["User"]);

                                ATApp  vATApp = (ATApp)Application["Config"];
                                String vBody  = "Dear " + "" + "\n\nLogin Details for NerdNerdy Web Application.\n\n";
                                vBody += "URL is: www.nerdnerdy.in\n";
                                vBody += "Login: "******"\nPassword:"******"\n\n";
                                vBody += "For any query, please revert us back.\n\nThanks and Regards\n";
                                ATCommon.SendMail(TXT_EMAIL.Text, "Login Details for NerdNerdy Application.", vBody, vATApp);
                                ShowMsg(int.Parse(TXTID.Value));
                                Clear();
                            }
                            catch (Exception xe)
                            {
                                ShowMsg(xe);
                            }
                        }
                        else
                        {
                            Hashtable vHT1 = new Hashtable();
                            vHT1.Add("USR_LOGIN", TXT_MOBILE_NO.Text.Trim());
                            vHT1.Add("USR_ZONE_ID", "");
                            vHT1.Add("USR_REGHQ_ID", RegioanlHQ_DDL.SelectedValue.ToString());
                            vHT1.Add("USR_ARHQ_ID", AreaHQ_DDL.SelectedValue.ToString());
                            vHT1.Add("USR_VSOHQ_ID", "0");
                            vHT1.Add("USR_CONT_NAME", TXT_ORGANIZATION.Text);
                            vHT1.Add("USR_TYPE", "ORGANIZATION");
                            vHT1.Add("USR_EMAIL", TXT_EMAIL.Text);
                            vHT1.Add("USR_MOBILE", TXT_MOBILE_NO.Text);
                            DBManager.ExecInsUps(vHT1, "UPDATE_USER", (ATSession)Session["User"]);
                        }
                        ShowMsg(int.Parse(TXTID.Value));
                        Clear();
                        Response.Redirect("User_AdminList.aspx");
                    }
                }
                else
                {
                    Hashtable vHashtable = new Hashtable();
                    vHashtable.Add("CUST_ID", TXTID.Value);
                    vHashtable.Add("CUST_VSOHQ_ID", "0");
                    vHashtable.Add("CUST_STA_ID", RegioanlHQ_DDL.SelectedValue.ToString());
                    vHashtable.Add("CUST_NAME", TXT_ORGANIZATION.Text);
                    vHashtable.Add("CUST_PROSPECTIVE", "");
                    vHashtable.Add("CUST_PREFIX", "");
                    vHashtable.Add("CUST_ADDRESS", TXT_ADDRESS.Text);
                    vHashtable.Add("CUST_COMP_NAME", TXT_ORGANIZATION.Text);
                    vHashtable.Add("CUST_DISTRICT", "0");
                    vHashtable.Add("CUST_VILLAGE_TWN_CITY", "");
                    vHashtable.Add("CUST_POST_OFFICE", "");
                    vHashtable.Add("CUST_STATE", "0");
                    vHashtable.Add("CUST_CATRGORY_ID", "");
                    vHashtable.Add("CUST_CONSULT_NAME", "");
                    vHashtable.Add("CUST_CONSULT_MOB", TXT_MOBILE_NO.Text);
                    vHashtable.Add("CUST_PIN", TXT_PIN.Text);
                    vHashtable.Add("CUST_PHONE", TXT_MOBILE_NO.Text);
                    vHashtable.Add("CUST_EMAIL", TXT_EMAIL.Text);
                    vHashtable.Add("CUST_MOBILE", TXT_MOBILE_NO.Text);
                    vHashtable.Add("CUST_DEALER", vATSession.CUST_ID);
                    vHashtable.Add("CUST_DESIGNATION", "");
                    vHashtable.Add("CUST_COUNTRY_ID", CUST_COUNTRY_DDL.SelectedValue);
                    vHashtable.Add("CUST_ARHQ_ID", AreaHQ_DDL.SelectedValue.ToString());
                    vHashtable.Add("CUST_ORGANIZATION_NAME", TXT_ORGANIZATION.Text);
                    vHashtable.Add("CUST_FROM_DATE", TXT_START.Text);
                    vHashtable.Add("CUST_TO_DATE", TXT_END.Text);
                    vHashtable.Add("CUST_VALUE", TXT_PATIENT.Text);
                    if (DBManager.ExecInsUpsReturn(vHashtable, "INS_CUSTOMER_NEW", (ATSession)Session["User"]))
                    {
                        if (HiddenField1.Value.Equals("0"))
                        {
                            try
                            {
                                Hashtable vHT = new Hashtable();
                                vHT.Add("ID", HiddenField1.Value);
                                vHT.Add("USR_LOGIN", TXT_MOBILE_NO.Text);
                                vHT.Add("USR_PASSWORD", TXT_PASSWORD.Text);
                                vHT.Add("USR_TYPE", DDL_USER_TYPE.SelectedValue);
                                vHT.Add("USR_COMPANY", vATSession.Company.ToString());
                                vHT.Add("USR_ZONE_ID", "0");
                                vHT.Add("USR_REGHQ_ID", RegioanlHQ_DDL.SelectedValue.ToString());
                                vHT.Add("USR_ARHQ_ID", AreaHQ_DDL.SelectedValue.ToString());
                                vHT.Add("USR_VSOHQ_ID", "0");
                                vHT.Add("USR_COUNTRY", CUST_COUNTRY_DDL.SelectedValue.ToString());
                                vHT.Add("USR_CONT_NAME", "");
                                vHT.Add("USR_ADDRESS", TXT_ADDRESS.Text);
                                vHT.Add("USR_PIN", TXT_PIN.Text);
                                vHT.Add("USR_PHONE", TXT_MOBILE_NO.Text);
                                vHT.Add("USR_MOBILE", TXT_MOBILE_NO.Text);
                                vHT.Add("USR_FAX", "");
                                vHT.Add("USR_EMAIL", TXT_EMAIL.Text);
                                vHT.Add("USR_ORGANIZATION_NAME", TXT_ORGANIZATION.Text);
                                vHT.Add("USR_FROM_DATE", TXT_START.Text);
                                vHT.Add("USR_TO_DATE", TXT_END.Text);
                                vHT.Add("USR_SUBSCRIPTION_NUMBER", TXT_Sub.Text);
                                vHT.Add("USR_PATIENT_SUBSCRIPTION_NUMBER", TXT_PATIENT.Text);
                                vHT.Add("USR_CLINICAL_HEAD", "");
                                DBManager.ExecInsUps(vHT, "INS_USER", (ATSession)Session["User"]);

                                ATApp  vATApp = (ATApp)Application["Config"];
                                String vBody  = "Dear " + "" + "\n\nLogin Details for NerdNerdy Web Application.\n\n";
                                vBody += "URL is: www.nerdnerdy.in\n";
                                vBody += "Login: "******"\nPassword:"******"\n\n";
                                vBody += "For any query, please revert us back.\n\nThanks and Regards\n";
                                ATCommon.SendMail(TXT_EMAIL.Text, "Login Details for NerdNerdy Application.", vBody, vATApp);
                                ShowMsg(int.Parse(TXTID.Value));
                                Clear();
                            }
                            catch (Exception xe)
                            {
                                ShowMsg(xe);
                            }
                        }
                        else
                        {
                            Hashtable vHT1 = new Hashtable();
                            vHT1.Add("USR_LOGIN", TXT_MOBILE_NO.Text.Trim());
                            vHT1.Add("USR_ZONE_ID", "");
                            vHT1.Add("USR_REGHQ_ID", RegioanlHQ_DDL.SelectedValue.ToString());
                            vHT1.Add("USR_ARHQ_ID", AreaHQ_DDL.SelectedValue.ToString());
                            vHT1.Add("USR_VSOHQ_ID", "0");
                            vHT1.Add("USR_CONT_NAME", TXT_ORGANIZATION.Text);
                            vHT1.Add("USR_TYPE", "ORGANIZATION");
                            vHT1.Add("USR_EMAIL", TXT_EMAIL.Text);
                            vHT1.Add("USR_MOBILE", TXT_MOBILE_NO.Text);
                            DBManager.ExecInsUps(vHT1, "UPDATE_USER", (ATSession)Session["User"]);
                        }
                        ShowMsg(int.Parse(TXTID.Value));
                        Clear();
                        Response.Redirect("User_AdminList.aspx");
                    }
                }
            }
            catch (Exception xe)
            {
                ShowMsg(xe);
            }
        }
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            try
            {
                if (TXT_PASSWORD.Text != null)
                {
                    Hashtable vHT = new Hashtable();
                    vHT.Add("ID", TXTID.Value);
                    vHT.Add("USR_LOGIN", TXT_MOBILE_NO.Text);
                    vHT.Add("USR_PASSWORD", TXT_PASSWORD.Text);
                    vHT.Add("USR_TYPE", DDL_USER_TYPE.SelectedValue);
                    vHT.Add("USR_COMPANY", vATSession.Company.ToString());
                    vHT.Add("USR_ZONE_ID", "0");
                    vHT.Add("USR_REGHQ_ID", RegioanlHQ_DDL.SelectedValue.ToString());
                    vHT.Add("USR_ARHQ_ID", AreaHQ_DDL.SelectedValue.ToString());
                    vHT.Add("USR_VSOHQ_ID", "0");
                    vHT.Add("USR_COUNTRY", CUST_COUNTRY_DDL.SelectedValue.ToString());
                    vHT.Add("USR_CONT_NAME", TXT_CONT_NAME.Text);
                    vHT.Add("USR_ADDRESS", TXT_ADDRESS.Text);
                    vHT.Add("USR_PIN", TXT_PIN.Text);
                    vHT.Add("USR_PHONE", TXT_MOBILE_NO.Text);
                    vHT.Add("USR_MOBILE", TXT_MOBILE_NO.Text);
                    vHT.Add("USR_FAX", "");
                    vHT.Add("USR_EMAIL", TXT_EMAIL.Text);
                    vHT.Add("USR_ORGANIZATION_NAME", TXT_ORGANIZATION.Text);
                    vHT.Add("USR_FROM_DATE", TXT_START.Text);
                    vHT.Add("USR_TO_DATE", TXT_END.Text);
                    vHT.Add("USR_SUBSCRIPTION_NUMBER", TXT_Sub.Text);
                    vHT.Add("USR_PATIENT_SUBSCRIPTION_NUMBER", TXT_PATIENT.Text);
                    vHT.Add("USR_CLINICAL_HEAD", "");
                    DBManager.ExecInsUps(vHT, "INS_USER", (ATSession)Session["User"]);

                    ATApp  vATApp = (ATApp)Application["Config"];
                    String vBody  = "Dear " + TXT_CONT_NAME.Text + "\n\nLogin Details for NerdNerdy Application.\n\n";
                    vBody += "URL is: <a href='www.demo.areeva.in'>www.demo.areeva.in</a>\n";
                    vBody += "Login: "******"\nPassword:"******"\n\n";
                    vBody += "For any query, please revert us back.\n\nThanks and Regards\n";
                    ShowMsg(int.Parse(TXTID.Value));
                    Response.Redirect("Customer_Organization_Create.aspx");
                    Clear();
                }
                else
                {
                    string    pwd = Create_Password();
                    Hashtable vHT = new Hashtable();
                    vHT.Add("ID", TXTID.Value);
                    vHT.Add("USR_LOGIN", TXT_MOBILE_NO.Text);
                    vHT.Add("USR_PASSWORD", pwd);
                    vHT.Add("USR_TYPE", DDL_USER_TYPE.SelectedValue);
                    vHT.Add("USR_COMPANY", vATSession.Company.ToString());
                    vHT.Add("USR_ZONE_ID", "0");
                    vHT.Add("USR_REGHQ_ID", RegioanlHQ_DDL.SelectedValue.ToString());
                    vHT.Add("USR_ARHQ_ID", AreaHQ_DDL.SelectedValue.ToString());
                    vHT.Add("USR_VSOHQ_ID", "0");
                    vHT.Add("USR_COUNTRY", CUST_COUNTRY_DDL.SelectedValue.ToString());
                    vHT.Add("USR_CONT_NAME", TXT_CONT_NAME.Text);
                    vHT.Add("USR_ADDRESS", TXT_ADDRESS.Text);
                    vHT.Add("USR_PIN", TXT_PIN.Text);
                    vHT.Add("USR_PHONE", TXT_MOBILE_NO.Text);
                    vHT.Add("USR_MOBILE", TXT_MOBILE_NO.Text);
                    vHT.Add("USR_FAX", "");
                    vHT.Add("USR_EMAIL", TXT_EMAIL.Text);
                    vHT.Add("USR_ORGANIZATION_NAME", TXT_ORGANIZATION.Text);
                    vHT.Add("USR_FROM_DATE", TXT_START.Text);
                    vHT.Add("USR_TO_DATE", TXT_END.Text);
                    vHT.Add("USR_SUBSCRIPTION_NUMBER", TXT_Sub.Text);
                    vHT.Add("USR_PATIENT_SUBSCRIPTION_NUMBER", TXT_PATIENT.Text);
                    vHT.Add("USR_CLINICAL_HEAD", "");
                    DBManager.ExecInsUps(vHT, "INS_USER", (ATSession)Session["User"]);

                    ATApp  vATApp = (ATApp)Application["Config"];
                    String vBody  = "Dear " + TXT_CONT_NAME.Text + "\n\nLogin Details for NerdNerdy Application.\n\n";
                    vBody += "URL is: <a href='www.demo.areeva.in'>www.demo.areeva.in</a>\n";
                    vBody += "Login: "******"\nPassword:"******"\n\n";
                    vBody += "For any query, please revert us back.\n\nThanks and Regards\n";
                    ShowMsg(int.Parse(TXTID.Value));
                    Response.Redirect("Customer_Organization_Create.aspx");
                    Clear();
                }
            }
            catch (Exception xe) { ShowMsg(xe); }
        }
    }
示例#6
0
    protected void btnSave_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            String    vID2        = vATSession.Login;
            Hashtable vHashtable6 = new Hashtable();
            vHashtable6.Add("USR_LOGIN", vID2);
            DataRow vDR6 = RetDR(DBManager.Get(vHashtable6, "GET_USER"));
            if (vDR6 != null)
            {
                HiddenField5.Value = vDR6["USR_ORGANIZATION_NAME"].ToString();
            }

            Hashtable vHashtable15 = new Hashtable();
            vHashtable15.Add("USR_LOGIN", vATSession.Login);
            DataRow vDR15 = RetDR(DBManager.Get(vHashtable15, "GET_TOTALPATIENT"));
            if (vDR15 != null)
            {
                HiddenField7.Value = vDR15["USR_PATIENT_SUBSCRIPTION_NUMBER"].ToString();
            }
            //HiddenField9.Value = TXT_VALUE.Text;
            String vID = Request.QueryString["ID"];
            if (vID != null)
            {
                Hashtable vHashtable16 = new Hashtable();
                vHashtable16.Add("ID", vID);
                DataRow vDR16 = RetDR(DBManager.Get(vHashtable16, "GET_CUSTOMER_ID"));
                if (vDR16 != null)
                {
                    if (CUST_MOBILE_TXT.Text != vDR16["CUST_MOBILE"].ToString())
                    {
                        Hashtable vHashtable7 = new Hashtable();
                        vHashtable7.Add("USR_ORGANIZATION_NAME", HiddenField5.Value);
                        DataRow vDR7 = RetDR(DBManager.Get(vHashtable7, "GET_TOTALPATIENT_NUMBER"));
                        if (vDR7 != null)
                        {
                            HiddenField6.Value = vDR7["USED_PATIENT_SUBSCRIPTION_NUMBER"].ToString();
                        }
                    }
                    HiddenField6.Value = TXT_VALUE.Text;
                }
            }
            if (HiddenField7.Value != "" && HiddenField6.Value != "")
            {
                HiddenField8.Value = Convert.ToString(Convert.ToInt32(HiddenField7.Value) - Convert.ToInt32(HiddenField6.Value));
                if (int.Parse(TXT_VALUE.Text) <= int.Parse(HiddenField8.Value))
                {
                    btnSave.Visible = true;

                    string PTP_MOBILE = "";
                    try
                    {
                        if (TXTID.Value == "0")
                        {
                            Hashtable vHashtable = new Hashtable();
                            vHashtable.Add("CUST_ID", TXTID.Value);
                            vHashtable.Add("CUST_VSOHQ_ID", "0");
                            vHashtable.Add("CUST_STA_ID", ddl_state.SelectedValue);
                            vHashtable.Add("CUST_NAME", CUST_NAME_TXT.Text);
                            vHashtable.Add("CUST_PROSPECTIVE", ddlProspective.SelectedItem.Text);
                            vHashtable.Add("CUST_PREFIX", "");
                            vHashtable.Add("CUST_ADDRESS", "");
                            vHashtable.Add("CUST_COMP_NAME", "");
                            vHashtable.Add("CUST_DISTRICT", "0");
                            vHashtable.Add("CUST_VILLAGE_TWN_CITY", "");
                            vHashtable.Add("CUST_POST_OFFICE", "");
                            vHashtable.Add("CUST_STATE", "0");
                            vHashtable.Add("CUST_CATRGORY_ID", "");
                            vHashtable.Add("CUST_CONSULT_NAME", "");
                            vHashtable.Add("CUST_CONSULT_MOB", "");
                            vHashtable.Add("CUST_PIN", "");
                            vHashtable.Add("CUST_PHONE", "");
                            vHashtable.Add("CUST_EMAIL", CUST_EMAIL_TXT.Text);
                            vHashtable.Add("CUST_MOBILE", CUST_MOBILE_TXT.Text);
                            vHashtable.Add("CUST_DEALER", vATSession.CUST_ID);
                            vHashtable.Add("CUST_DESIGNATION", TXT_DESIGNATION.Text);
                            vHashtable.Add("CUST_COUNTRY_ID", CUST_COUNTRY_DDL.SelectedValue);
                            vHashtable.Add("CUST_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
                            vHashtable.Add("CUST_ORGANIZATION_NAME", ORGANIZATION_DDL.Text);
                            vHashtable.Add("CUST_FROM_DATE", TXT_START.Text);
                            vHashtable.Add("CUST_TO_DATE", TXT_END.Text);
                            vHashtable.Add("CUST_VALUE", TXT_VALUE.Text);
                            if (DBManager.ExecInsUpsReturn(vHashtable, "INS_CUSTOMER_NEW", (ATSession)Session["User"]))
                            {
                                if (TXTID.Value.Equals("0"))
                                {
                                    try
                                    {
                                        string    pwd = Create_Password();
                                        Hashtable vHT = new Hashtable();
                                        vHT.Add("ID", TXTID.Value);

                                        if (TXTID.Value == "0")
                                        {
                                            vHT.Add("USR_LOGIN", CUST_MOBILE_TXT.Text);
                                        }
                                        else
                                        {
                                            vHT.Add("USR_LOGIN", CUST_MOBILE_TXT.Text.Trim());
                                        }
                                        vHT.Add("USR_ZONE_ID", CUST_COUNTRY_DDL.SelectedValue);
                                        vHT.Add("USR_TYPE", "Doctor");
                                        vHT.Add("USR_REGHQ_ID", ddl_state.SelectedValue);
                                        vHT.Add("USR_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
                                        vHT.Add("USR_VSOHQ_ID", "0");
                                        vHT.Add("USR_COMPANY", "");
                                        vHT.Add("USR_CONT_NAME", CUST_NAME_TXT.Text);
                                        vHT.Add("USR_ADDRESS", "");
                                        vHT.Add("USR_PIN", "");
                                        vHT.Add("USR_PHONE", "");
                                        vHT.Add("USR_MOBILE", CUST_MOBILE_TXT.Text);
                                        vHT.Add("USR_FAX", "");
                                        vHT.Add("USR_EMAIL", CUST_EMAIL_TXT.Text);
                                        vHT.Add("USR_PASSWORD", pwd);
                                        vHT.Add("USR_COUNTRY", CUST_COUNTRY_DDL.SelectedValue);
                                        vHT.Add("USR_ORGANIZATION_NAME", ORGANIZATION_DDL.Text);
                                        vHT.Add("USR_FROM_DATE", TXT_START.Text);
                                        vHT.Add("USR_TO_DATE", TXT_END.Text);
                                        vHT.Add("USR_SUBSCRIPTION_NUMBER", "");
                                        vHT.Add("USR_PATIENT_SUBSCRIPTION_NUMBER", TXT_VALUE.Text);
                                        vHT.Add("USR_CLINICAL_HEAD", "");
                                        DBManager.ExecInsUps(vHT, "INS_USER", (ATSession)Session["User"]);
                                        ATApp vATApp = (ATApp)Application["Config"];

                                        String vBody = "Dear " + CUST_NAME_TXT.Text + "\n\nLogin Detaials for NerdNerdy Web Application.\n\n";
                                        vBody += "URL is:www.nerdnerdy.in\n";
                                        vBody += "Login: "******"\nPassword:"******"\n\n";
                                        vBody += "For any query, please revert us back.\n\nThanks and Regards\n";
                                        ATCommon.SendMail(CUST_EMAIL_TXT.Text, "Login Detaials for NerdNerdy Web Application.", vBody, vATApp);
                                        ShowMsg(int.Parse(TXTID.Value));
                                        Response.Redirect("UserList.aspx");
                                        Clear();
                                    }
                                    catch (Exception xe) { ShowMsg(xe); }
                                }
                                else
                                {
                                    Hashtable vHT1 = new Hashtable();
                                    vHT1.Add("USR_LOGIN", CUST_MOBILE_TXT.Text.Trim());
                                    vHT1.Add("USR_ZONE_ID", CUST_COUNTRY_DDL.SelectedValue);
                                    vHT1.Add("USR_REGHQ_ID", ddl_state.SelectedValue);
                                    vHT1.Add("USR_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
                                    vHT1.Add("USR_VSOHQ_ID", "0");
                                    vHT1.Add("USR_CONT_NAME", CUST_NAME_TXT.Text);
                                    vHT1.Add("USR_TYPE", "Doctor");
                                    vHT1.Add("USR_EMAIL", CUST_EMAIL_TXT.Text);
                                    vHT1.Add("USR_MOBILE", CUST_MOBILE_TXT.Text);
                                    vHT1.Add("USR_PATIENT_SUBSCRIPTION_NUMBER", TXT_VALUE.Text);
                                    DBManager.ExecInsUps(vHT1, "UPDATE_USER", (ATSession)Session["User"]);
                                }
                            }
                            ShowMsg(int.Parse(TXTID.Value));
                            Clear();
                            Response.Redirect("UserList.aspx");
                        }
                        else
                        {
                            Hashtable vHashtable = new Hashtable();
                            vHashtable.Add("CUST_ID", TXTID.Value);
                            vHashtable.Add("CUST_VSOHQ_ID", "0");
                            vHashtable.Add("CUST_STA_ID", ddl_state.SelectedValue);
                            vHashtable.Add("CUST_NAME", CUST_NAME_TXT.Text);
                            vHashtable.Add("CUST_PROSPECTIVE", ddlProspective.SelectedItem.Text);
                            vHashtable.Add("CUST_PREFIX", "");
                            vHashtable.Add("CUST_ADDRESS", "");
                            vHashtable.Add("CUST_COMP_NAME", "");
                            vHashtable.Add("CUST_DISTRICT", "0");
                            vHashtable.Add("CUST_VILLAGE_TWN_CITY", "");
                            vHashtable.Add("CUST_POST_OFFICE", "");
                            vHashtable.Add("CUST_STATE", "0");
                            vHashtable.Add("CUST_CATRGORY_ID", "");
                            vHashtable.Add("CUST_CONSULT_NAME", "");
                            vHashtable.Add("CUST_CONSULT_MOB", "");
                            vHashtable.Add("CUST_PIN", "");
                            vHashtable.Add("CUST_PHONE", "");
                            vHashtable.Add("CUST_EMAIL", CUST_EMAIL_TXT.Text);
                            vHashtable.Add("CUST_MOBILE", CUST_MOBILE_TXT.Text);
                            vHashtable.Add("CUST_DEALER", vATSession.CUST_ID);
                            vHashtable.Add("CUST_DESIGNATION", TXT_DESIGNATION.Text);
                            vHashtable.Add("CUST_COUNTRY_ID", CUST_COUNTRY_DDL.SelectedValue);
                            vHashtable.Add("CUST_ARHQ_ID", HiddenField1.Value);
                            vHashtable.Add("CUST_ORGANIZATION_NAME", ORGANIZATION_DDL.Text);
                            vHashtable.Add("CUST_FROM_DATE", TXT_START.Text);
                            vHashtable.Add("CUST_TO_DATE", TXT_END.Text);
                            vHashtable.Add("CUST_VALUE", TXT_VALUE.Text);
                            if (DBManager.ExecInsUpsReturn(vHashtable, "INS_CUSTOMER_NEW", (ATSession)Session["User"]))
                            {
                                if (TXTID.Value.Equals("0"))
                                {
                                    try
                                    {
                                        string    pwd = Create_Password();
                                        Hashtable vHT = new Hashtable();
                                        vHT.Add("ID", TXTID.Value);

                                        if (TXTID.Value == "0")
                                        {
                                            vHT.Add("USR_LOGIN", CUST_MOBILE_TXT.Text);
                                        }
                                        else
                                        {
                                            vHT.Add("USR_LOGIN", CUST_MOBILE_TXT.Text.Trim());
                                        }
                                        vHT.Add("USR_COMPANY", "");
                                        vHT.Add("USR_ZONE_ID", CUST_COUNTRY_DDL.SelectedValue);
                                        vHT.Add("USR_REGHQ_ID", ddl_state.SelectedValue);
                                        vHT.Add("USR_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
                                        vHT.Add("USR_VSOHQ_ID", "0");
                                        vHT.Add("USR_CONT_NAME", CUST_NAME_TXT.Text);
                                        vHT.Add("USR_ADDRESS", "");
                                        vHT.Add("USR_TYPE", "Doctor");
                                        vHT.Add("USR_PIN", "");
                                        vHT.Add("USR_PHONE", "");
                                        vHT.Add("USR_MOBILE", CUST_MOBILE_TXT.Text);
                                        vHT.Add("USR_FAX", "");
                                        vHT.Add("USR_EMAIL", CUST_EMAIL_TXT.Text);
                                        vHT.Add("USR_PASSWORD", pwd);
                                        vHT.Add("USR_COUNTRY", CUST_COUNTRY_DDL.SelectedValue);
                                        vHT.Add("USR_ORGANIZATION_NAME", ORGANIZATION_DDL.Text);
                                        vHT.Add("USR_FROM_DATE", TXT_START.Text);
                                        vHT.Add("USR_TO_DATE", TXT_END.Text);
                                        vHT.Add("USR_SUBSCRIPTION_NUMBER", "");
                                        vHT.Add("USR_PATIENT_SUBSCRIPTION_NUMBER", TXT_VALUE.Text);
                                        vHT.Add("USR_CLINICAL_HEAD", "");
                                        DBManager.ExecInsUps(vHT, "INS_USER", (ATSession)Session["User"]);
                                        ATApp vATApp = (ATApp)Application["Config"];

                                        String vBody = "Dear " + CUST_NAME_TXT.Text + "\n\nLogin Detaials for NerdNerdy Web Application.\n\n";
                                        vBody += "URL is: www.nerdnerdy.in\n";
                                        vBody += "Login: "******"\nPassword:"******"\n\n";
                                        vBody += "For any query, please revert us back.\n\nThanks and Regards\n";
                                        ATCommon.SendMail(CUST_EMAIL_TXT.Text, "Login Detaials for NerdNerdy Web Application.", vBody, vATApp);
                                        ShowMsg(int.Parse(TXTID.Value));
                                        Response.Redirect("UserList.aspx");
                                        Clear();
                                    }
                                    catch (Exception xe) { ShowMsg(xe); }
                                }
                                else
                                {
                                    Hashtable vHT1 = new Hashtable();
                                    vHT1.Add("USR_LOGIN", CUST_MOBILE_TXT.Text.Trim());
                                    vHT1.Add("USR_ZONE_ID", CUST_COUNTRY_DDL.SelectedValue);
                                    vHT1.Add("USR_REGHQ_ID", ddl_state.SelectedValue);
                                    vHT1.Add("USR_ARHQ_ID", CUST_STATION_DDL.SelectedValue);
                                    vHT1.Add("USR_VSOHQ_ID", "0");
                                    vHT1.Add("USR_CONT_NAME", CUST_NAME_TXT.Text);
                                    vHT1.Add("USR_TYPE", "Doctor");
                                    vHT1.Add("USR_EMAIL", CUST_EMAIL_TXT.Text);
                                    vHT1.Add("USR_MOBILE", CUST_MOBILE_TXT.Text);
                                    vHT1.Add("USR_PATIENT_SUBSCRIPTION_NUMBER", TXT_VALUE.Text);
                                    DBManager.ExecInsUps(vHT1, "UPDATE_USER", (ATSession)Session["User"]);
                                }
                            }

                            ShowMsg(int.Parse(TXTID.Value));
                            Clear();
                            Response.Redirect("UserList.aspx");
                        }
                    }
                    catch (Exception xe)
                    {
                        ShowMsg(xe);
                    }
                }
                else
                {
                    string message = "You Have Less Patient Subscription as subscribed !!";
                    System.Text.StringBuilder sb = new System.Text.StringBuilder();
                    sb.Append("<script type = 'text/javascript'>");
                    sb.Append("window.onload=function(){");
                    sb.Append("alert('");
                    sb.Append(message);
                    sb.Append("')};");
                    sb.Append("</script>");
                    ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", sb.ToString());
                }
            }
        }
    }
    protected void Savebtn_Click(object sender, EventArgs e)
    {
        try
        {
            SqlConnection con = new SqlConnection("Data Source=182.18.187.118;Initial Catalog=DEMO_NERDNERDY;User ID=sa;Password=GTAalm6FPML4n6t$;");
            SqlCommand    cmd = new SqlCommand("INS_CUSTOMER_NEW", con);
            cmd.CommandType = CommandType.StoredProcedure;
            con.Open();
            SqlTransaction tran = con.BeginTransaction();

            cmd.Parameters.AddWithValue("CUST_ID", TXTID.Value);
            cmd.Parameters.AddWithValue("CUST_VSOHQ_ID", "0");
            cmd.Parameters.AddWithValue("CUST_STA_ID", "0");
            cmd.Parameters.AddWithValue("CUST_NAME", TXT_ORGANIZATION.Text);
            cmd.Parameters.AddWithValue("CUST_PROSPECTIVE", "");
            cmd.Parameters.AddWithValue("CUST_PREFIX", "");
            cmd.Parameters.AddWithValue("CUST_ADDRESS", "");
            cmd.Parameters.AddWithValue("CUST_COMP_NAME", TXT_ORGANIZATION.Text);
            cmd.Parameters.AddWithValue("CUST_DISTRICT", "0");
            cmd.Parameters.AddWithValue("CUST_VILLAGE_TWN_CITY", "");
            cmd.Parameters.AddWithValue("CUST_POST_OFFICE", "");
            cmd.Parameters.AddWithValue("CUST_STATE", "0");
            cmd.Parameters.AddWithValue("CUST_CATRGORY_ID", "");
            cmd.Parameters.AddWithValue("CUST_CONSULT_NAME", "");
            cmd.Parameters.AddWithValue("CUST_CONSULT_MOB", TXT_MOBILE_NO.Text);
            cmd.Parameters.AddWithValue("CUST_PIN", "000");
            cmd.Parameters.AddWithValue("CUST_PHONE", TXT_MOBILE_NO.Text);
            cmd.Parameters.AddWithValue("CUST_EMAIL", TXT_EMAIL.Text);
            cmd.Parameters.AddWithValue("CUST_MOBILE", TXT_MOBILE_NO.Text);
            cmd.Parameters.AddWithValue("CUST_DEALER", "0");
            cmd.Parameters.AddWithValue("CUST_DESIGNATION", "");
            cmd.Parameters.AddWithValue("CUST_COUNTRY_ID", "0");
            cmd.Parameters.AddWithValue("CUST_ARHQ_ID", "0");
            cmd.Parameters.AddWithValue("CUST_ORGANIZATION_NAME", TXT_ORGANIZATION.Text);
            cmd.Parameters.AddWithValue("CUST_FROM_DATE", "2020-08-01 00:00:00.000");
            cmd.Parameters.AddWithValue("CUST_TO_DATE", "2021-08-01 00:00:00.000");
            cmd.Parameters.AddWithValue("CUST_VALUE", "1");
            cmd.Parameters.AddWithValue("last_user", "Therapist");


            SqlCommand cmd1 = new SqlCommand("INS_USER", con);
            string     pwd  = Create_Password();
            cmd1.Parameters.AddWithValue("ID", HiddenField1.Value);
            cmd1.Parameters.AddWithValue("USR_LOGIN", TXT_MOBILE_NO.Text);
            cmd1.Parameters.AddWithValue("USR_PASSWORD", pwd);
            cmd1.Parameters.AddWithValue("USR_TYPE", DDL_USER_TYPE.SelectedValue);
            cmd1.Parameters.AddWithValue("USR_COMPANY", "NERDNERDY");
            cmd1.Parameters.AddWithValue("USR_ZONE_ID", "0");
            cmd1.Parameters.AddWithValue("USR_REGHQ_ID", "0");
            cmd1.Parameters.AddWithValue("USR_ARHQ_ID", "0");
            cmd1.Parameters.AddWithValue("USR_VSOHQ_ID", "0");
            cmd1.Parameters.AddWithValue("USR_COUNTRY", "0");
            cmd1.Parameters.AddWithValue("USR_CONT_NAME", "");
            cmd1.Parameters.AddWithValue("USR_ADDRESS", "");
            cmd1.Parameters.AddWithValue("USR_PIN", "");
            cmd1.Parameters.AddWithValue("USR_PHONE", TXT_MOBILE_NO.Text);
            cmd1.Parameters.AddWithValue("USR_MOBILE", TXT_MOBILE_NO.Text);
            cmd1.Parameters.AddWithValue("USR_FAX", "");
            cmd1.Parameters.AddWithValue("USR_EMAIL", TXT_EMAIL.Text);
            cmd1.Parameters.AddWithValue("USR_ORGANIZATION_NAME", TXT_ORGANIZATION.Text);
            cmd1.Parameters.AddWithValue("USR_FROM_DATE", "");
            cmd1.Parameters.AddWithValue("USR_TO_DATE", "");
            cmd1.Parameters.AddWithValue("USR_SUBSCRIPTION_NUMBER", "1");
            cmd1.Parameters.AddWithValue("USR_PATIENT_SUBSCRIPTION_NUMBER", "1");
            cmd1.Parameters.AddWithValue("USR_CLINICAL_HEAD", "");

            ATApp  vATApp = (ATApp)Application["Config"];
            String vBody  = "Dear " + "" + "\n\nLogin Details for NerdNerdy Web Application.\n\n";
            vBody += "URL is: www.nerdnerdy.in\n";
            vBody += "Login: "******"\nPassword:"******"\n\n";
            vBody += "For any query, please revert us back.\n\nThanks and Regards\n";
            ATCommon.SendMail(TXT_EMAIL.Text, "Login Details for NerdNerdy Application.", vBody, vATApp);
            ShowMsg(int.Parse(TXTID.Value));

            int k  = cmd.ExecuteNonQuery();
            int k1 = cmd1.ExecuteNonQuery();
            //tran.commit();
            cmd1.Parameters.Clear();
            tran.Commit();
            lblmsg.Text = "Record Inserted Succesfully into the Database";
            ///frmload();
        }
        catch (Exception exRollback)
        {
            Console.WriteLine(exRollback.Message);
        }
        //}
        //int k = cmd.ExecuteNonQuery();
        //if (k != 0)
        //{
        //    lblmsg.Text = "Record Inserted Succesfully into the Database";
        //    lblmsg.ForeColor = System.Drawing.Color.CornflowerBlue;
        //}
        //con.Close();


        //if (Page.IsValid)
        //{
        //    try
        //    {
        //        if (TXTID.Value == "0")
        //        {
        //            Hashtable vHashtable = new Hashtable();
        //            vHashtable.Add("CUST_ID", TXTID.Value);
        //            vHashtable.Add("CUST_VSOHQ_ID", "0");
        //            vHashtable.Add("CUST_STA_ID", "0");
        //            vHashtable.Add("CUST_NAME", TXT_ORGANIZATION.Text);
        //            vHashtable.Add("CUST_PROSPECTIVE", "");
        //            vHashtable.Add("CUST_PREFIX", "");
        //            vHashtable.Add("CUST_ADDRESS", TXT_ADDRESS.Text);
        //            vHashtable.Add("CUST_COMP_NAME", TXT_ORGANIZATION.Text);
        //            vHashtable.Add("CUST_DISTRICT", "0");
        //            vHashtable.Add("CUST_VILLAGE_TWN_CITY", "");
        //            vHashtable.Add("CUST_POST_OFFICE", "");
        //            vHashtable.Add("CUST_STATE", "0");
        //            vHashtable.Add("CUST_CATRGORY_ID", "");
        //            vHashtable.Add("CUST_CONSULT_NAME", "");
        //            vHashtable.Add("CUST_CONSULT_MOB", TXT_MOBILE_NO.Text);
        //            vHashtable.Add("CUST_PIN", "000");
        //            vHashtable.Add("CUST_PHONE", TXT_MOBILE_NO.Text);
        //            vHashtable.Add("CUST_EMAIL", TXT_EMAIL.Text);
        //            vHashtable.Add("CUST_MOBILE", TXT_MOBILE_NO.Text);
        //            vHashtable.Add("CUST_DEALER", "0");
        //            vHashtable.Add("CUST_DESIGNATION", "");
        //            vHashtable.Add("CUST_COUNTRY_ID", "0");
        //            vHashtable.Add("CUST_ARHQ_ID", "0");
        //            vHashtable.Add("CUST_ORGANIZATION_NAME", TXT_ORGANIZATION.Text);
        //            vHashtable.Add("CUST_FROM_DATE", "2020-08-01 00:00:00.000");
        //            vHashtable.Add("CUST_TO_DATE", "2021-08-01 00:00:00.000");
        //            vHashtable.Add("CUST_VALUE", "1");
        //            //if (DBManager.ExecInsUpsReturn(vHashtable, "INS_CUSTOMER_NEW", (ATSession)Session["User"]))
        //            {
        //                if (HiddenField1.Value.Equals("0"))
        //                {
        //                    try
        //                    {
        //                        string pwd = Create_Password();
        //                        Hashtable vHT = new Hashtable();
        //                        vHT.Add("ID", HiddenField1.Value);
        //                        vHT.Add("USR_LOGIN", TXT_MOBILE_NO.Text);
        //                        vHT.Add("USR_PASSWORD", pwd);
        //                        vHT.Add("USR_TYPE", "Therapist");
        //                        vHT.Add("USR_COMPANY", "NERDNERDY");
        //                        vHT.Add("USR_ZONE_ID", "0");
        //                        vHT.Add("USR_REGHQ_ID", "0");
        //                        vHT.Add("USR_ARHQ_ID", "0");
        //                        vHT.Add("USR_VSOHQ_ID", "0");
        //                        vHT.Add("USR_COUNTRY", "0");
        //                        vHT.Add("USR_CONT_NAME", "");
        //                        vHT.Add("USR_ADDRESS", TXT_ADDRESS.Text);
        //                        vHT.Add("USR_PIN", "");
        //                        vHT.Add("USR_PHONE", TXT_MOBILE_NO.Text);
        //                        vHT.Add("USR_MOBILE", TXT_MOBILE_NO.Text);
        //                        vHT.Add("USR_FAX", "");
        //                        vHT.Add("USR_EMAIL", TXT_EMAIL.Text);
        //                        vHT.Add("USR_ORGANIZATION_NAME", TXT_ORGANIZATION.Text);
        //                        vHT.Add("USR_FROM_DATE", "");
        //                        vHT.Add("USR_TO_DATE", "");
        //                        vHT.Add("USR_SUBSCRIPTION_NUMBER", "1");
        //                        vHT.Add("USR_PATIENT_SUBSCRIPTION_NUMBER", "1");
        //                        vHT.Add("USR_CLINICAL_HEAD", "");
        //                        DBManager.ExecInsUps(vHT, "INS_USER", (ATSession)Session["User"]);

        //                        ATApp vATApp = (ATApp)Application["Config"];
        //                        String vBody = "Dear " + "" + "\n\nLogin Details for NerdNerdy Web Application.\n\n";
        //                        vBody += "URL is: www.demo.nerdnerdy.in\n";
        //                        vBody += "Login: "******"\nPassword:"******"\n\n";
        //                        vBody += "For any query, please revert us back.\n\nThanks and Regards\n";
        //                        ATCommon.SendMail(TXT_EMAIL.Text, "Login Details for NerdNerdy Application.", vBody, vATApp);
        //                        ShowMsg(int.Parse(TXTID.Value));

        //                    }
        //                    catch (Exception xe)
        //                    {
        //                        ShowMsg(xe);
        //                    }
        //                }
        //                ShowMsg(int.Parse(TXTID.Value));

        //               // Response.Redirect("Default.aspx");
        //            }
        //        }
        //        else
        //        {
        //            Hashtable vHashtable = new Hashtable();
        //            vHashtable.Add("CUST_ID", TXTID.Value);
        //            vHashtable.Add("CUST_VSOHQ_ID", "0");
        //            vHashtable.Add("CUST_STA_ID", "0");
        //            vHashtable.Add("CUST_NAME", TXT_ORGANIZATION.Text);
        //            vHashtable.Add("CUST_PROSPECTIVE", "");
        //            vHashtable.Add("CUST_PREFIX", "");
        //            vHashtable.Add("CUST_ADDRESS", TXT_ADDRESS.Text);
        //            vHashtable.Add("CUST_COMP_NAME", TXT_ORGANIZATION.Text);
        //            vHashtable.Add("CUST_DISTRICT", "");
        //            vHashtable.Add("CUST_VILLAGE_TWN_CITY", "");
        //            vHashtable.Add("CUST_POST_OFFICE", "");
        //            vHashtable.Add("CUST_STATE", "0");
        //            vHashtable.Add("CUST_CATRGORY_ID", "");
        //            vHashtable.Add("CUST_CONSULT_NAME", "");
        //            vHashtable.Add("CUST_CONSULT_MOB", TXT_MOBILE_NO.Text);
        //            vHashtable.Add("CUST_PIN", "00");
        //            vHashtable.Add("CUST_PHONE", TXT_MOBILE_NO.Text);
        //            vHashtable.Add("CUST_EMAIL", TXT_EMAIL.Text);
        //            vHashtable.Add("CUST_MOBILE", TXT_MOBILE_NO.Text);
        //            vHashtable.Add("CUST_DEALER", "");
        //            vHashtable.Add("CUST_DESIGNATION", "");
        //            vHashtable.Add("CUST_COUNTRY_ID", "0");
        //            vHashtable.Add("CUST_ARHQ_ID", "0");
        //            vHashtable.Add("CUST_ORGANIZATION_NAME", TXT_ORGANIZATION.Text);
        //            vHashtable.Add("CUST_FROM_DATE", "");
        //            vHashtable.Add("CUST_TO_DATE", "");
        //            vHashtable.Add("CUST_VALUE", "1");
        //            if (DBManager.ExecInsUpsReturn(vHashtable, "INS_CUSTOMER_NEW", (ATSession)Session["User"]))
        //            {
        //                if (HiddenField1.Value.Equals("0"))
        //                {
        //                    try
        //                    {
        //                        string pwd = Create_Password();
        //                        Hashtable vHT = new Hashtable();
        //                        vHT.Add("ID", HiddenField1.Value);
        //                        vHT.Add("USR_LOGIN", TXT_MOBILE_NO.Text);
        //                        vHT.Add("USR_PASSWORD", pwd);
        //                        vHT.Add("USR_TYPE", "Therapist");
        //                        vHT.Add("USR_COMPANY", vATSession.Company.ToString());
        //                        vHT.Add("USR_ZONE_ID", "0");
        //                        vHT.Add("USR_REGHQ_ID", "0");
        //                        vHT.Add("USR_ARHQ_ID", "0");
        //                        vHT.Add("USR_VSOHQ_ID", "0");
        //                        vHT.Add("USR_COUNTRY", "0");
        //                        vHT.Add("USR_CONT_NAME", "");
        //                        vHT.Add("USR_ADDRESS", TXT_ADDRESS.Text);
        //                        vHT.Add("USR_PIN", "");
        //                        vHT.Add("USR_PHONE", TXT_MOBILE_NO.Text);
        //                        vHT.Add("USR_MOBILE", TXT_MOBILE_NO.Text);
        //                        vHT.Add("USR_FAX", "");
        //                        vHT.Add("USR_EMAIL", TXT_EMAIL.Text);
        //                        vHT.Add("USR_ORGANIZATION_NAME", TXT_ORGANIZATION.Text);
        //                        vHT.Add("USR_FROM_DATE", "");
        //                        vHT.Add("USR_TO_DATE", "");
        //                        vHT.Add("USR_SUBSCRIPTION_NUMBER", "1");
        //                        vHT.Add("USR_PATIENT_SUBSCRIPTION_NUMBER", "1");
        //                        vHT.Add("USR_CLINICAL_HEAD", "");
        //                        DBManager.ExecInsUps(vHT, "INS_USER", (ATSession)Session["User"]);

        //                        ATApp vATApp = (ATApp)Application["Config"];
        //                        String vBody = "Dear " + "" + "\n\nLogin Details for NerdNerdy Web Application.\n\n";
        //                        vBody += "URL is: www.demo.nerdnerdy.in\n";
        //                        vBody += "Login: "******"\nPassword:"******"\n\n";
        //                        vBody += "For any query, please revert us back.\n\nThanks and Regards\n";
        //                        ATCommon.SendMail(TXT_EMAIL.Text, "Login Details for NerdNerdy Application.", vBody, vATApp);
        //                        ShowMsg(int.Parse(TXTID.Value));

        //                    }
        //                    catch (Exception xe)
        //                    {
        //                        ShowMsg(xe);
        //                    }
        //                }
        //                ShowMsg(int.Parse(TXTID.Value));

        //                Response.Redirect("Default.aspx");
        //        }
        //        }
        //    }
        //    catch (Exception xe)
        //    {
        //        ShowMsg(xe);
        //    }
        //}
    }