protected void QuoteDetails()
    {
        string conf;

        FetchEmails();
        qry = "SELECT * FROM tblConfirmation WHERE ReqId='" + reqid + "'";
        SqlDataReader dr = ClassHome.getRecords(qry);

        if (dr.Read())
        {
            conf        = dr.GetValue(1).ToString();
            Label1.Text = conf;
            if (Label1.Text == "Yes")
            {
                Label2.Visible      = false;
                Label3.Visible      = false;
                Label1.Visible      = true;
                sendEMail.Visible   = false;
                btnEndchat1.Visible = false;
                Label1.Text         = "The quote you send was accepted by the customer and sent you following details for appointment";
                Panel2.Visible      = true;
            }
            else
            {
                FetchQuote();
                Label2.Visible   = true;
                Label3.Visible   = true;
                Panel1.Visible   = true;
                Label1.Visible   = true;
                Label1.ForeColor = System.Drawing.Color.Red;
                Label1.Text      = "Unfortunately!! Your quote was not accepted by the customer.";
            }
        }
    }
Ejemplo n.º 2
0
    protected void FetchAndTransferChat()
    {
        qry = "SELECT * FROM tblChat WHERE ReqId=" + Request.QueryString["id"];
        SqlDataReader dr = ClassHome.getRecords(qry);

        if (dr.Read())
        {
            reqid         = dr.GetValue(1).ToString();
            sender        = dr.GetValue(2).ToString();
            chatMsg       = dr.GetValue(3).ToString();
            customeremail = dr.GetValue(4).ToString();
            provideremail = dr.GetValue(5).ToString();
        }
        else
        {
        }

        qry = "INSERT INTO tblEndedChats (EReqId,ESender,EChatMsg,ECustomerEmail,EProviderEmail) VALUES ('" + reqid + "', '" + sender + "', '" + chatMsg + "', '" + customeremail + "','" + provideremail + "')";
        int i = ClassHome.setRecords(qry);

        qry = "DELETE FROM tblChat WHERE ReqId='" + reqid + "'";
        int p = ClassHome.setRecords(qry);

        qry = "DELETE FROM tblCustomerRequest WHERE ReqId = '" + reqid + "'";
        int r = ClassHome.setRecords(qry);
    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        qry = "SELECT * FROM tblServiceProvider WHERE SPID='" + GridView1.SelectedRow.Cells[1].Text + "'";
        SqlDataReader dr = ClassHome.getRecords(qry);

        if (dr.Read())
        {
            txtStore.Text    = dr.GetValue(1).ToString();
            txtName.Text     = dr.GetValue(2).ToString();
            txtPhone.Text    = dr.GetValue(3).ToString();
            txtUserName.Text = dr.GetValue(4).ToString();
            txtPassword.Text = dr.GetValue(5).ToString();
            txtAddress.Text  = dr.GetValue(6).ToString();
            txtEmail.Text    = dr.GetValue(7).ToString();
            ddlProviderType.SelectedValue = dr.GetValue(8).ToString();
            txtLic.Text       = dr.GetValue(9).ToString();
            txtDriverLic.Text = dr.GetValue(10).ToString();
            txtReference.Text = dr.GetValue(11).ToString();


            btnSubmit.Text    = "Update";
            btnDelete.Visible = true;

            pnlView.Visible  = false;
            pnlTable.Visible = true;
        }
        dr.Close();
    }
    protected void btnRating_Click(object sender, EventArgs e)
    {
        FetchDetails();
        SqlConnection con = new SqlConnection(@"Data Source = (LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\HomeSol.mdf;Integrated Security=True");

        qry = "INSERT INTO tblrating (rating, review, StoreName, CustomerName) VALUES (@ratingvalue, @review,@provideremail,@custemail )";
        SqlCommand     cmd = new SqlCommand(qry);
        SqlDataAdapter sda = new SqlDataAdapter();

        cmd.CommandType = CommandType.Text;
        cmd.Parameters.AddWithValue("@ratingvalue", Rating1.CurrentRating.ToString());
        cmd.Parameters.AddWithValue("@review", txtreview.Text);
        cmd.Parameters.AddWithValue("@provideremail", provideremail);
        cmd.Parameters.AddWithValue("@custemail", customeremail);
        cmd.Connection = con;
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
        qry = "INSERT INTO tblCustomerCompletion (ProviderStore,CustomerName,ProviderPhone,CustomerQuery,QuoteAmount) VALUES ('" + providerstore + "','" + customername + "','" + providerphone + "','" + customerquery + "','" + quote + "')";
        int    i    = ClassHome.setRecords(qry);
        Label  lbl6 = DataList1.Items[0].FindControl("lblId") as Label;
        string id   = lbl6.Text;

        qry = "DELETE FROM tblComplete WHERE Id=" + id;
        int p = ClassHome.setRecords(qry);

        Response.Redirect("Dashboard.aspx");
    }
    protected void btnDelete_Click(object sender, EventArgs e)
    {
        qry = "DELETE FROM tblCustomer WHERE CustomerId='" + GridView1.SelectedRow.Cells[1].Text + "'";
        int i = ClassHome.setRecords(qry);

        AllClear();
        lblMsg.Text = "Record DELETED successfully.";
    }
    protected void FillGrid()
    {
        qry = "SELECT CustomerId AS [ID], CustomerName AS [Customer Name], CustomerUName AS [User Name], CustomerPass AS [Password], CustomerEmail AS [Email ID], CustomerPhone AS [Phone Number], CustomerAddress AS [Address] FROM tblCustomer";
        SqlDataReader dr = ClassHome.getRecords(qry);

        GridView1.DataSource = dr;
        GridView1.DataBind();
    }
    protected void FillGrid()
    {
        qry = "SELECT RejSPID AS [ID],RejSPStoreName AS [Store Name] , RejSPName AS [Provider Name], RejSPPhone AS [Phone], RejSPAddress AS [Address], RejSPEmail AS [Email], SPType AS [Category], RejSPLic AS [Licence Number] FROM viewRejectedSP";
        SqlDataReader dr = ClassHome.getRecords(qry);

        GridView1.DataSource = dr;
        GridView1.DataBind();
    }
    protected void FillGrid()
    {
        qry = "SELECT EmpID AS [ID], EmpName AS [Emp Name], EmpPhone AS [Emp Phone], EmpUserName AS [Emp UserName], EmpPassword AS [Emp Password], EmpAddress AS [Emp Address], EmpEmail AS [Emp Email], EmpType AS [Emp Type] FROM viewEmployee";
        SqlDataReader dr = ClassHome.getRecords(qry);

        GridView1.DataSource = dr;
        GridView1.DataBind();
    }
    /*public void FillGrid()
     * {
     * Label lbl = DataList1.Items[0].FindControl("lblReqId") as Label;
     * string lblreqid = lbl.Text;
     * SqlConnection con = new SqlConnection(@"Data Source = (LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\HomeSol.mdf;Integrated Security=True");
     * qry = "SELECT * FROM tblChat WHERE ReqId=" + lblreqid;
     * SqlDataReader dr = ClassHome.getRecords(qry);
     * GridView1.DataSource = dr;
     * GridView1.DataBind();
     * }
     */
    protected void sendEMail_Click(object sender, EventArgs e)
    {
        Label  lbl      = DataList1.Items[0].FindControl("lblReqId") as Label;
        string lblreqid = lbl.Text;

        qry = "INSERT INTO tblChat (ReqId,Sender,ChatMsg,CustomerEmail,ProviderEmail) VALUES ('" + lblreqid + "','" + providername + "','" + txtContent.Text + "','" + customeremail + "', '" + provideremail + "')";
        int i = ClassHome.setRecords(qry);
    }
    protected void FillGrid()
    {
        qry = "SELECT SPID AS [ID],SPStoreName AS [Store Name] , SPName AS [Provider Name], SPPhone AS [Phone], SPUserName AS [UserName], SPPassword AS [Password], SPAddress AS [Address], SPEmail AS [Email], SPType AS [Category], SPLic AS [Licence Number], SPDriverLic AS [Driver's Lic], SPReferences AS [References] FROM viewServiceProvider";
        SqlDataReader dr = ClassHome.getRecords(qry);

        GridView1.DataSource = dr;
        GridView1.DataBind();
    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        qry = "SELECT CustomerId AS [ID], CustomerName AS [Customer Name], CustomerUName AS [User Name], CustomerPass AS [Password], CustomerEmail AS [Email ID], CustomerPhone AS [Phone Number], CustomerAddress AS [Address] FROM tblCustomer WHERE CustomerPhone LIKE '" + txtSearchCompany.Text + "%'";
        SqlDataReader dr = ClassHome.getRecords(qry);

        GridView1.DataSource = dr;
        GridView1.DataBind();
    }
    protected void btnLogin_Click(object sender, EventArgs e)
    {
        qry = "INSERT INTO tblPreServiceProvider (PreSPStoreName ,PreSPName,PreSPPhone,PreSPAddress,PreSPEmail,SPTypeId, PreSPLic, PreDriverLic, PreReferences) VALUES ('" + txtStore.Text + "', '" + txtName.Text + "','" + txtPhone.Text + "','" + txtAddress.Text + "','" + txtEmail.Text + "','" + ddlProviderType.SelectedValue + "','" + txtLic.Text + "','" + txtDriverLic.Text + "','" + txtReferences.Text + "')";
        int i = ClassHome.setRecords(qry);

        AllClear();
        lblMsg.ForeColor = System.Drawing.Color.White;
        Response.Redirect("AfterSubmit.aspx");
    }
    protected void btnLogin_Click(object sender, EventArgs e)
    {
        string password = txtPassword.Text;
        string enc      = encryption(password);

        qry = "INSERT INTO tblCustomer (CustomerName ,CustomerUName,CustomerPass,CustomerEmail,CustomerPhone,CustomerAddress) VALUES ('" + txtName.Text + "', '" + txtUserName.Text + "','" + enc + "','" + txtEmail.Text + "','" + txtPhone.Text + "','" + txtAddress.Text + "')";
        int i = ClassHome.setRecords(qry);

        Response.Redirect("CustomerLogin.aspx");
    }
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         FillGrid();
         qry = "SELECT DISTINCT([SPType]) FROM[tblServiceProviderType]";
         SqlDataReader dr = ClassHome.getRecords(qry);
         ddlSearchCategory.DataSource = dr;
         ddlSearchCategory.DataBind();
         ddlSearchCategory.Items.Insert(0, "-- select --");
     }
 }
Ejemplo n.º 15
0
    /* public void FillGrid()
     * {
     * SqlConnection con = new SqlConnection(@"Data Source = (LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\HomeSol.mdf;Integrated Security=True");
     * qry = "SELECT * FROM tblChat WHERE ReqId=" + Request.QueryString["id"];
     * SqlDataReader dr = ClassHome.getRecords(qry);
     * GridView1.DataSource = dr;
     * GridView1.DataBind();
     * }*/
    public void FetchEmails()
    {
        qry = "SELECT * FROM tblChat WHERE ReqId=" + Request.QueryString["id"];
        SqlDataReader dr = ClassHome.getRecords(qry);

        if (dr.Read())
        {
            reqid         = dr.GetValue(1).ToString();
            customeremail = dr.GetValue(4).ToString();
            provideremail = dr.GetValue(5).ToString();
            Label1.Text   = customeremail;
            Label2.Text   = provideremail;
        }
    }
    protected void FetchQuote()
    {
        FetchEmails();
        qry = "SELECT * FROM tblQuote WHERE ReqId=" + reqid;
        SqlDataReader dr = ClassHome.getRecords(qry);

        if (dr.Read())
        {
            quoteid         = dr.GetValue(0).ToString();
            quote           = dr.GetValue(1).ToString();
            Label2.Text     = quote;
            lblQuoteId.Text = quoteid;
        }
    }
    protected void btnAbort_Click(object sender, EventArgs e)
    {
        FetchEmails();
        qry = "INSERT INTO tblEndedChats (EReqId,ESender,EChatMsg,ECustomerEmail,EProviderEmail) VALUES ('" + reqid + "', '" + sender1 + "', '" + chatMsg + "', '" + customeremail + "','" + provideremail + "')";
        int i = ClassHome.setRecords(qry);

        qry = "DELETE FROM tblChat WHERE ReqId='" + reqid + "'";
        int p = ClassHome.setRecords(qry);

        qry = "DELETE FROM tblCustomerRequest WHERE ReqId = '" + reqid + "'";
        int r = ClassHome.setRecords(qry);

        Response.Redirect("ServiceProviderDash.aspx");
    }
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         if (Session["utype"].ToString() == "Reception")
         {
             Response.Redirect("EmployeeDash.aspx");
         }
         qry = "SELECT DISTINCT([SPType]) FROM[tblServiceProviderType]";
         SqlDataReader dr = ClassHome.getRecords(qry);
         ddlSearchCategory.DataSource = dr;
         ddlSearchCategory.DataBind();
         ddlSearchCategory.Items.Insert(0, "-- select --");
     }
 }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        if (btnSubmit.Text == "Submit")
        {
            qry = "INSERT INTO tblEmployee (EmpName,EmpPhone,EmpUserName,EmpPassword,EmpAddress,EmpEmail,EmpTypeID) VALUES ('" + txtName.Text + "','" + txtPhone.Text + "','" + txtUserName.Text + "','" + txtPassword.Text + "','" + txtAddress.Text + "','" + txtEmail.Text + "','" + ddlEmpType.SelectedValue + "')";
        }
        else
        {
            qry = "UPDATE tblEmployee SET EmpName='" + txtName.Text + "', EmpPhone='" + txtPhone.Text + "', EmpUserName='******', EmpPassword='******', EmpAddress='" + txtAddress.Text + "',  EmpEmail='" + txtEmail.Text + "', EmpTypeID='" + ddlEmpType.SelectedValue + "' WHERE EmpID='" + GridView1.SelectedRow.Cells[1].Text + "'";
        }
        int i = ClassHome.setRecords(qry);

        AllClear();
        lblMsg.Text = "Record submitted successfully.";
    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        if (ddlSearchCategory.SelectedIndex == 0)
        {
            qry = "SELECT RejSPID AS [ID], RejSPStoreName AS [Store Name] , RejSPName AS [Provider Name], RejSPPhone AS [Phone], RejSPAddress AS [Address], RejSPEmail AS [Email], SPType AS [Category], RejSPLic AS [Licence Number] FROM viewRejectedSP WHERE RejSPStoreName LIKE '" + txtSearchCompany.Text + "%'";
        }
        else
        {
            qry = "SELECT RejSPID AS [ID], RejSPStoreName AS [Store Name] , RejSPName AS [Provider Name], RejSPPhone AS [Phone], RejSPAddress AS [Address], RejSPEmail AS [Email], SPType AS [Category], RejSPLic AS [Licence Number] FROM viewRejectedSP WHERE RejSPStoreName LIKE '" + txtSearchCompany.Text + "%' AND SPType='" + ddlSearchCategory.SelectedValue + "'";
        }
        SqlDataReader dr = ClassHome.getRecords(qry);

        GridView1.DataSource = dr;
        GridView1.DataBind();
    }
Ejemplo n.º 21
0
    protected void btnNo_Click(object sender, EventArgs e)
    {
        FetchEmails();
        string flag = "No";

        qry = "DELETE FROM tblConfirmation WHERE ReqId='" + reqid + "'";
        int i = ClassHome.setRecords(qry);

        qry = "INSERT INTO tblConfirmation (Confirmation,ReqId) VALUES ('" + flag + "','" + reqid + "')";
        int p = ClassHome.setRecords(qry);

        Panel1.Visible   = true;
        Panel3.Visible   = false;
        lblQuote.Visible = false;
    }
    public void InsertDetails()
    {
        Label  lbl        = DataList1.Items[0].FindControl("lblEmail") as Label;
        string lbltext    = lbl.Text;
        Label  lbl1       = DataList1.Items[0].FindControl("lblName") as Label;
        string lblname    = lbl1.Text;
        Label  lbl2       = DataList1.Items[0].FindControl("lblStoreName") as Label;
        string lblstore   = lbl2.Text;
        Label  lbl3       = DataList1.Items[0].FindControl("lblPhone") as Label;
        string lblphone   = lbl3.Text;
        Label  lbl4       = DataList1.Items[0].FindControl("lblAddress") as Label;
        string lbladdress = lbl4.Text;

        qry = "INSERT INTO tblCustomerRequest (CustName, CustPhone, CustEmail, CustAddress, RequestDetails, ProviderName, ProviderEmail, ProviderStoreName, ProviderAddress, ProviderPhone) VALUES ('" + custname + "','" + custphone + "','" + custemail + "','" + custaddress + "','" + txtContent.Text + "','" + lblname + "','" + lbltext + "','" + lblstore + "','" + lbladdress + "','" + lblphone + "')";
        int i = ClassHome.setRecords(qry);
    }
Ejemplo n.º 23
0
    protected void btnYes_Click(object sender, EventArgs e)
    {
        FetchEmails();
        string flag = "Yes";

        qry = "DELETE FROM tblConfirmation WHERE ReqId='" + reqid + "'";
        int i = ClassHome.setRecords(qry);

        qry = "INSERT INTO tblConfirmation (Confirmation,ReqId) VALUES ('" + flag + "','" + reqid + "')";
        int p = ClassHome.setRecords(qry);

        Panel1.Visible   = true;
        Panel3.Visible   = false;
        lblQuote.Visible = false;
        Label3.Text      = "Accept the quote and send an appointment details:";
    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        string password = txtPassword.Text;
        string enc      = encryption(password);

        if (btnSubmit.Text == "Submit")
        {
            qry = "INSERT INTO tblServiceProvider (SPStoreName ,SPName,SPPhone,SPUserName,SPPassword,SPAddress,SPEmail,SPTypeId, SPLic) VALUES ('" + txtStore.Text + "', '" + txtName.Text + "','" + txtPhone.Text + "','" + txtUserName.Text + "','" + enc + "','" + txtAddress.Text + "','" + txtEmail.Text + "','" + ddlProviderType.SelectedValue + "','" + txtLic.Text + "')";
        }
        else
        {
            qry = "UPDATE tblServiceProvider SET SPStoreName='" + txtStore.Text + "', SPName='" + txtName.Text + "', SPPhone='" + txtPhone.Text + "', SPUserName='******', SPPassword='******', SPAddress='" + txtAddress.Text + "', SPEmail='" + txtEmail.Text + "', SPTypeId='" + ddlProviderType.SelectedValue + "', SPLic = '" + txtLic.Text + "' WHERE SPID='" + GridView1.SelectedRow.Cells[1].Text + "'";
        }
        int i = ClassHome.setRecords(qry);

        AllClear();
        lblMsg.Text = "Record submitted successfully.";
    }
    protected void btnLogin_Click(object sender, EventArgs e)
    {
        Session["uname"] = txtName.Text;

        query = "SELECT * FROM viewEmployee WHERE EmpUserName='******' AND EmpPassword='******'";
        SqlDataReader dr = ClassHome.getRecords(query);

        if (dr.Read())
        {
            Session["utype"] = dr.GetValue(8).ToString();
            Response.Redirect("EmployeeDash.aspx");
        }
        else
        {
            lblMsg.Text = "Invalid UserName or Password";
        }
        dr.Close();
    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        string password = txtPassword.Text;
        string enc      = encryption(password);

        if (btnSubmit.Text == "Submit")
        {
            qry = "INSERT INTO tblCustomer (CustomerName ,CustomerUName, CustomerPass, CustomerEmail ,CustomerPhone, CustomerAddress) VALUES ('" + txtName.Text + "','" + txtUserName.Text + "','" + enc + "','" + txtEmail.Text + "','" + txtPhone.Text + "', '" + txtAddress.Text + "')";
        }
        else
        {
            qry = "UPDATE tblCustomer SET CustomerName='" + txtName.Text + "', CustomerPhone='" + txtPhone.Text + "', CustomerUName='" + txtUserName.Text + "', CustomerPass='******', CustomerAddress='" + txtAddress.Text + "', CustomerEmail='" + txtEmail.Text + "' WHERE CustomerId='" + GridView1.SelectedRow.Cells[1].Text + "'";
        }
        int i = ClassHome.setRecords(qry);

        AllClear();
        lblMsg.Text = "Record submitted successfully.";
    }
    protected void sendEMail_Click1(object sender, EventArgs e)
    {
        Label             lbl        = DataList1.Items[0].FindControl("lblEmail") as Label;
        string            lbltext    = lbl.Text;
        Label             lbl1       = DataList1.Items[0].FindControl("lblName") as Label;
        string            lblname    = lbl1.Text;
        Label             lbl2       = DataList1.Items[0].FindControl("lblStoreName") as Label;
        string            lblstore   = lbl2.Text;
        Label             lbl3       = DataList1.Items[0].FindControl("lblPhone") as Label;
        string            lblphone   = lbl3.Text;
        Label             lbl4       = DataList1.Items[0].FindControl("lblAddress") as Label;
        string            lbladdress = lbl4.Text;
        NetworkCredential loginInfo  = new NetworkCredential("*****@*****.**", "homesolutions");
        MailMessage       msg        = new MailMessage();
        string            text       = "Hello!! " + lblname + " You got one new request from customer:\n" + txtContent.Text +
                                       @"<html> <body> <br><hr/> Thanks and Regards <br> <b>Home Solutions and Co. </b></body> </html> ";

        msg.From = new MailAddress("*****@*****.**");
        msg.To.Add(new MailAddress(lbltext)); //the email id where you need to send email.
        msg.Subject    = "Update on your application in Home Solutions";
        msg.Body       = text;
        msg.IsBodyHtml = true;
        SmtpClient client = new SmtpClient("smtp.gmail.com", 587);

        client.EnableSsl             = true;
        client.UseDefaultCredentials = false;
        client.Credentials           = loginInfo;
        client.Send(msg);
        InsertDetails();
        string reqid, msg1;

        qry = "SELECT * FROM tblCustomerRequest WHERE CustPhone = '" + custphone + "'";
        SqlDataReader dr = ClassHome.getRecords(qry);

        if (dr.Read())
        {
            reqid = dr.GetValue(0).ToString();
            msg1  = dr.GetValue(5).ToString();
            qry   = "INSERT INTO tblChat (ReqId,Sender,ChatMsg,CustomerEmail,ProviderEmail) VALUES ('" + reqid + "','" + custname + "','" + msg1 + "','" + custemail + "', '" + lbltext + "')";
            int p = ClassHome.setRecords(qry);
        }
        Response.Redirect("Dashboard.aspx");
    }
    public void FetchEmails()
    {
        Label lbl1 = DataList1.Items[0].FindControl("lblRequest") as Label;

        chatMsg = lbl1.Text;
        Label  lbl      = DataList1.Items[0].FindControl("lblReqId") as Label;
        string lblreqid = lbl.Text;

        qry = "SELECT * FROM tblChat WHERE ReqId=" + lblreqid;
        SqlDataReader dr = ClassHome.getRecords(qry);

        if (dr.Read())
        {
            reqid         = dr.GetValue(1).ToString();
            sender1       = dr.GetValue(2).ToString();
            customeremail = dr.GetValue(4).ToString();
            provideremail = dr.GetValue(5).ToString();
        }
    }
Ejemplo n.º 29
0
    protected void GridView1_SelectedIndexChanged1(object sender, EventArgs e)
    {
        qry = "SELECT * FROM viewPreServiceProvider WHERE PreSPID='" + GridView1.SelectedRow.Cells[1].Text + "'";
        SqlDataReader dr = ClassHome.getRecords(qry);

        if (dr.Read())
        {
            lblStoreName.Text  = dr.GetValue(1).ToString();
            lblName.Text       = dr.GetValue(2).ToString();
            lblPhone.Text      = dr.GetValue(3).ToString();
            lblEmail.Text      = dr.GetValue(5).ToString();
            lblAddress.Text    = dr.GetValue(4).ToString();
            lblLic.Text        = dr.GetValue(7).ToString();
            lblType.Text       = dr.GetValue(10).ToString();
            lblTypeID.Text     = dr.GetValue(6).ToString();
            lblDriverLic.Text  = dr.GetValue(8).ToString();
            lblReferences.Text = dr.GetValue(9).ToString();
        }
        dr.Close();
    }
Ejemplo n.º 30
0
    protected void btnApprove1_Click(object sender, EventArgs e)
    {
        string password = txtPassword.Text;
        string enc      = encryption(password);
        int    flag     = 0;

        if (flag == 0)
        {
            qry = "INSERT INTO tblServiceProvider (SPStoreName ,SPName,SPPhone,SPUserName,SPPassword,SPAddress,SPEmail,SPTypeId, SPLic,SPDriverLic,SPReferences) VALUES ('" + lblStoreName.Text + "', '" + lblName.Text + "','" + lblPhone.Text + "','" + txtUserName.Text + "','" + enc + "','" + lblAddress.Text + "','" + lblEmail.Text + "','" + lblTypeID.Text + "','" + lblLic.Text + "','" + lblDriverLic.Text + "','" + lblReferences.Text + "')";
            int i = ClassHome.setRecords(qry);
            qry1 = "DELETE FROM tblPreServiceProvider WHERE PreSPID='" + GridView1.SelectedRow.Cells[1].Text + "'";
            int i1 = ClassHome.setRecords(qry1);
            flag = 1;
        }
        else
        {
        }
        if (flag == 1)
        {
            string text  = "Hello!!" + lblStoreName.Text + " You have been successfully approved for the home solution signup.";
            string text1 = "@ <html><body><p> Congratulations on your approval.</p><p> Now customer can see your all information on their portal.</p>" +
                           "<p> We have attached the username and password to this email </p><hr><b> Your User name is:</b></body></html>" + txtUserName.Text;
            string text2 = @"<html><body><b>And Your password is:</b></body></html>";
            string text3 = @" <html> <body> <br><hr/><br> Thanks and Regards<br><b>Home Solutions and Co. </b></body> </html> ";

            NetworkCredential loginInfo = new NetworkCredential("*****@*****.**", "homesolutions");
            MailMessage       msg       = new MailMessage();
            msg.From = new MailAddress("*****@*****.**");
            msg.To.Add(new MailAddress(lblEmail.Text)); //the email id where you need to send email.
            msg.Subject    = "Your Login Credentials for Home Solutions";
            msg.Body       = text + text1 + text2 + txtPassword.Text + text3;;
            msg.IsBodyHtml = true;
            SmtpClient client = new SmtpClient("smtp.gmail.com", 587);
            client.EnableSsl             = true;
            client.UseDefaultCredentials = false;
            client.Credentials           = loginInfo;
            client.Send(msg);
            //for sending email ends here
            Response.Redirect("PendingApprovals.aspx");
        }
    }