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 button2_Click(object sender, EventArgs e) { custBLL c = new custBLL(); custDAL cd = new custDAL(); queryBLL q = new queryBLL(); queryDAL qd = new queryDAL(); companysBLL b = new companysBLL(); companysDAL dc = new companysDAL(); #region user details //int id; string email; string name = ""; string mobile; //int nquery; #endregion #region query details string ques; string ans; int status = 1; int cid; string cname; int i = dataGridView1.Rows.Count; i--; #endregion for (int j = 1; j < i; j++) { #region get data from table name = dataGridView1.Rows[j].Cells[4].Value.ToString(); mobile = dataGridView1.Rows[j].Cells[5].Value.ToString(); ans = dataGridView1.Rows[j].Cells[3].Value.ToString(); email = dataGridView1.Rows[j].Cells[6].Value.ToString(); cname = dataGridView1.Rows[j].Cells[1].Value.ToString(); ques = dataGridView1.Rows[j].Cells[2].Value.ToString(); #endregion #region fill the query q.u_name = name; q.u_mobile = mobile; q.ques = ques; q.soln = ans; q.status = status; b = dc.GetcompanysForTransaction(cname); cid = b.id; q.c_id = cid; bool isuser1 = cd.chkcustumer(name); if (isuser1 == true) { c = cd.searchcustumer(name); } else { MessageBox.Show("user not found"); } q.cu_id = c.id; q.status = status; bool qadded = qd.Insert(q); if (qadded == false) { MessageBox.Show("query not added"); } #endregion } }