private void button2_Click(object sender, EventArgs e) { bool sucess = dcDAL.Updatesoln(qid, textsoln.Text); emailsBLL email = new emailsBLL(); email.to = txtemail.Text; email.subject = "Solidworks support query id =" + qid; string body = "<h3>" + "Query- \n " + "</h3>" + "<b>" + textqry.Text + "</b>" + "<h3>" + " \n\n Solution- \n" + "</h3>" + "<b>" + textsoln.Text + "</b>" + "\n\n\n\n\n"; email.body = body; email.name = txtu_Name.Text; bool sucess1 = eDAL.sendemail(email); if (sucess1 == true) { MessageBox.Show("email sent sucessfully"); } else { MessageBox.Show("email not sent"); } //Calling the Clear Method if (sucess == true) { MessageBox.Show("query updated "); } else { MessageBox.Show("unable to update query"); } }
public bool sendemail(emailsBLL m) { bool sucess = true; string signature = ReadSignature(); try { outlook._Application _app = new outlook.Application(); outlook.MailItem mail = (outlook.MailItem)_app.CreateItem(outlook.OlItemType.olMailItem); mail.BodyFormat = outlook.OlBodyFormat.olFormatHTML; mail.To = m.to; mail.Subject = m.subject; string body = "<html><body>" + "Kind attention Mr. " + "<b>" + m.name + "\n\n thank you for contacting Iris Hightech Technical support. A seervice request has been genrated as below:" + "</b>" + m.body + "<span style='font-size:10.0pt;color:#578a90'>this is a system generated mail and query will be closed by itself in the next 24 hours if no response is received by recipients\n\n</span>" + "<span style='color:#1F497D'> Regards</span> \n <span style='font-size:14.0pt;color:#1F497D'>SOLIDWORKS Technical Support</span> \n <span style='color:#1F497D'>Phone no: 011 - 48175001, 011 - 47005616 </span>\n <span style='color:#1F497D'>Email: [email protected] </span>\n<span style='font-size:13.0pt;color:#C00000'> Iris Hightech Private Limited </span>\n <span style='font-size:10.0pt;color:#C00000'>(Authorized Value Added Reseller & Training Centre - SolidWorks - CAM - MakerBot 3D Printer)</span>" + "</body></html>" + ""; body = body.Replace("\n", "<br/>"); mail.HTMLBody = body; mail.Importance = outlook.OlImportance.olImportanceNormal; ((outlook.MailItem)mail).Send(); } catch (Exception ex) { MessageBox.Show(ex.Message, "message", MessageBoxButtons.OK, MessageBoxIcon.Error); sucess = false; } finally { } return(sucess); }
private async void button2_Click(object sender, EventArgs e) { button4_Click(this, new EventArgs()); await System.Threading.Tasks.Task.Delay(2000); OpenFileDialog file = new OpenFileDialog(); //open dialog to choose file //if there is a file choosen by the user { c = dc.Search(companydeact); emailsBLL email = new emailsBLL(); // txtemail.Text = c.c_email; email.to = txtemail.Text; email.subject = "solidworks deactivation form "; string body = "<span style='color:#1F497D'>Dear Sir,</span> \n<span style='color:#1F497D'>As per our discussion, please find the attached deactivation form.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='color:#1F497D'>Please sign and stamp and revert it asap.<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='color:#1F497D'>It will take 24-48 hours to process the request.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><o:p> </o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='color:#1F497D'>In case of any query, feel free to contact us.</span></b><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='color:#1F497D'> </span></b><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='color:#1F497D'>Technical Support Team</span></b><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='color:#1F497D'>IRIS HIGHTECH PRIVATE LIMITED</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='color:#1F497D'>Contact: mailto [email protected]" + "<span style='color:#6666FF'>[email protected]</span></a><span style='color:#1F497D'> || 011-48175001, 011- 47005616</span><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div> " + "\n\n\n\n\n"; email.body = body; email.name = companydeact; email.attachment = createandsendpath; bool sucess = em.senddeactivationform(email); if (sucess == true) { MessageBox.Show("email sent sucessfully"); } else { MessageBox.Show("email not sent"); } } }
private void button5_Click(object sender, EventArgs e) { OpenFileDialog file = new OpenFileDialog(); //open dialog to choose file string templ = file.FileName; c = dc.Search(companydeact); emailsBLL email = new emailsBLL(); //txtemail.Text = c.c_email; email.to = txtemail.Text; email.subject = "solidworks deactivation form "; string body = "<span style='color:#1F497D'>Dear Sir,</span> \n<span style='color:#1F497D'>As per our discussion, please find the attached deactivation form.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='color:#1F497D'>Please sign and stamp and revert it asap.<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='color:#1F497D'>It will take 24-48 hours to process the request.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><o:p> </o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='color:#1F497D'>In case of any query, feel free to contact us.</span></b><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='color:#1F497D'> </span></b><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='color:#1F497D'>Technical Support Team</span></b><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='color:#1F497D'>IRIS HIGHTECH PRIVATE LIMITED</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='color:#1F497D'>Contact: </span><a href=\"mailto:swsupport @irishightech.com\" target=\"_blank\"><span style='color:#6666FF'>[email protected]</span></a><span style='color:#1F497D'> || 011-48175001, 011- 47005616</span><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div> " + "\n\n\n\n\n"; email.body = body; email.name = companydeact; email.attachment = templ; bool sucess = em.senddeactivationform(email); if (sucess == true) { MessageBox.Show("email sent sucessfully"); } else { MessageBox.Show("email not sent"); } }
public bool senddeactivationform(emailsBLL m) { bool sucess = true; string signature = ReadSignature(); try { outlook._Application _app = new outlook.Application(); outlook.MailItem mail = (outlook.MailItem)_app.CreateItem(outlook.OlItemType.olMailItem); mail.BodyFormat = outlook.OlBodyFormat.olFormatHTML; mail.To = m.to; mail.Subject = m.subject; string body = "<html><body>" + m.body + "<span style='font-size:10.0pt;color:#578a90'>this is a system generated mail and query will be closed by itself in the next 24 hours if no response is received by recipients\n\n</span>"; body = body.Replace("\n", "<br/>"); mail.HTMLBody = body; if (string.IsNullOrEmpty(m.attachment) == false) { // need to check to see if file exists before we attach ! if (!File.Exists(m.attachment)) { MessageBox.Show("Attached document " + m.attachment + " does not exist", "File Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { mail.Attachments.Add(m.attachment, outlook.OlAttachmentType.olByValue, 1, "vaibhav.pdf"); } } //mail.Display(); // display the email mail.Importance = outlook.OlImportance.olImportanceNormal; ((outlook.MailItem)mail).Send(); } catch (Exception ex) { MessageBox.Show(ex.Message, "message", MessageBoxButtons.OK, MessageBoxIcon.Error); sucess = false; } finally { } return(sucess); }
private void Form1_Load(object sender, EventArgs e) { locationsBLL l = new locationsBLL(); locationDAL ld = new locationDAL(); c = dc.Search(companydeact); emailsBLL email = new emailsBLL(); txtemail.Text = c.c_email; txtcompany.Text = c.c_name; l = ld.search("template"); lbltemplate.Text = l.location; filePath = lbltemplate.Text; l = ld.search("save deactivation"); lblsave.Text = l.location; filepathemail = lblsave.Text; savepath = lblsave.Text; }
private void button3_Click(object sender, EventArgs e) { string keyword = txtu_Name.Text; queryBLL q = new queryBLL(); bool qsucess = tDAL.chkcustumer(keyword); custBLL dc = tDAL.searchcustumer(keyword); if (qsucess == true) { keyword = txtcompany.Text; companysBLL c = pDAL.Search(keyword); q.ques = textqry.Text; q.soln = textsoln.Text; q.cu_id = dc.id; q.c_id = dc.cid; q.u_name = dc.name; emailname = q.u_name; q.u_mobile = dc.mobile; dc.nquery = dc.nquery++; bool incquery = tDAL.Increasenoofquery(dc); if (incquery == true) { MessageBox.Show("user and query updated"); } else { MessageBox.Show("user and query not updated"); } q.status = 1; bool success = dcDAL.Insert(q); q = dcDAL.Getqueryforsearch(q); qid = q.q_id; qid1 = q.q_id; } if (qsucess == false) { keyword = txtcompany.Text; bool csucess = pDAL.chkcompanybyname(keyword); if (csucess == true) { keyword = txtcompany.Text; companysBLL c = pDAL.Search(keyword); custBLL ca = new custBLL(); ca.name = txtu_Name.Text; emailname = q.u_name; ca.mobile = txtu_Contact.Text; string type = "user"; ca.type = type; ca.email = txtemail.Text; bool isadded = false; int id = c.id; ca.cid = id; ca.nquery = 0; isadded = tDAL.Insert(ca); if (isadded == true) { MessageBox.Show("new user added"); } else { MessageBox.Show("new user can not be added"); } } else { MessageBox.Show("plz add new company"); addcompanys ca = new addcompanys(); ca.Show(); } //space to add new user(custumer) //addnewcostumer costumer = new addnewcostumer(); //costumer.Show(); //this.Hide(); //MessageBox.Show("plz add new costumer"); //Failed to Add New product //MessageBox.Show("new user added"); } //if the product is added successfully then the value of success will be true else it will be false if (qsucess == true) { //Product Inserted Successfully MessageBox.Show("query Added Successfully"); emailsBLL email = new emailsBLL(); email.to = txtemail.Text; email.subject = "solidworks support query " + qid; string body = "<h3>" + "query- \n " + "</h3>" + "<b>" + textqry.Text + "</b>" + "<h3>" + " \n\n solution- \n" + "</h3>" + "<b>" + textsoln.Text + "</b>" + "\n\n\n\n\n"; email.body = body; email.name = txtu_Name.Text; bool sucess = eDAL.sendemail(email); if (sucess == true) { MessageBox.Show("email sent sucessfully"); } else { MessageBox.Show("email not sent"); } //Calling the Clear Method } }
private void button4_Click(object sender, EventArgs e) { string keyword = txtu_Name.Text; queryBLL q = new queryBLL(); bool qsucess = tDAL.chkcustumer(keyword);//chking costumer custBLL dc = tDAL.searchcustumer(keyword); if (qsucess == true)// if costumer is found { keyword = txtcompany.Text; companysBLL c = pDAL.Search(keyword); q.ques = textqry.Text; q.soln = textsoln.Text; q.cu_id = dc.id; q.c_id = dc.cid; q.u_name = dc.name; emailname = q.u_name; q.u_mobile = dc.mobile; dc.nquery = dc.nquery++; q.status = 0; q.datetime = DateTime.Now; bool success = dcDAL.Insert(q); bool incquery = tDAL.Increasenoofquery(dc); if (incquery == true) { MessageBox.Show("user and query updated"); } else { MessageBox.Show("user and query not updated"); } emailname = q.u_name; q = dcDAL.Getqueryforsearch(q); qid = q.q_id; if (success == true) { //Product Inserted Successfully MessageBox.Show("query Added Successfully"); emailsBLL email = new emailsBLL(); email.to = txtemail.Text; email.subject = "solidworks support query " + qid; string body = "<h3>" + "SR NO." + DateTime.Today + " " + qid + "query- \n " + "</h3>" + "<b>" + textqry.Text + "</b>" + "<h3>" + " \n\n solution- \n" + "</h3>" + "<b>" + textsoln.Text + "</b>" + "\n\n\n\n\n"; email.body = body; email.name = txtu_Name.Text; bool sucess = eDAL.sendemail(email); if (sucess == true) { MessageBox.Show("email sent sucessfully"); } else { MessageBox.Show("email not sent"); } //Calling the Clear Method } } if (qsucess == false) { keyword = txtcompany.Text; bool csucess = pDAL.chkcompanybyname(keyword); if (csucess == true) { keyword = txtcompany.Text; companysBLL c = pDAL.Search(keyword); custBLL ca = new custBLL(); ca.name = txtu_Name.Text; ca.mobile = txtu_Contact.Text; string type = "user"; ca.type = type; ca.email = txtemail.Text; bool isadded = false; int id = c.id; ca.cid = id; ca.nquery = 0; isadded = tDAL.Insert(ca); if (isadded == true) { MessageBox.Show("new user added"); } else { MessageBox.Show("new user can not be added"); } } else { MessageBox.Show("plz add new company"); addcompanys ca = new addcompanys(); ca.Show(); } } }