private void import_Click(object sender, EventArgs e) { queryBLL q = new queryBLL(); companysBLL b = new companysBLL(); companysDAL dc = new companysDAL(); int i = dataGridView1.Rows.Count; i--; string add = ""; string name; string mobile; string sub; string email; string subend = "12/12/2009"; string cat = "na"; for (int j = 1; j < i; j++) { name = dataGridView1.Rows[j].Cells[11].Value.ToString(); bool sucess = dc.chkcompanybyname(name); if (sucess == false) { add = dataGridView1.Rows[j].Cells[6].Value.ToString(); add = add + dataGridView1.Rows[j].Cells[7].Value.ToString(); add = add + dataGridView1.Rows[j].Cells[3].Value.ToString(); add = add + dataGridView1.Rows[j].Cells[8].Value.ToString(); b.c_location = add; name = dataGridView1.Rows[j].Cells[11].Value.ToString(); mobile = dataGridView1.Rows[j].Cells[1].Value.ToString(); sub = dataGridView1.Rows[j].Cells[2].Value.ToString(); email = dataGridView1.Rows[j].Cells[0].Value.ToString(); sub = dataGridView1.Rows[j].Cells[2].Value.ToString(); b.c_name = name; b.c_mobile = mobile; b.c_email = email; b.subend_date = sub; b.substart_date = subend; b.c_category = cat; bool suck = dc.Insert(b); add = " "; if (suck != true) { MessageBox.Show("nhi add hui"); } } } }
private void button1_Click(object sender, EventArgs e) { companysBLL tc = new companysBLL(); custBLL c = new custBLL(); string keyword = textcompany.Text; bool sucess = pDAL.chkcompanybyname(keyword); if (sucess == true) { MessageBox.Show("company found"); tc = pDAL.GetcompanysForTransaction(keyword); int id = tc.id; c.cid = id; c.nquery = 0; } else { addcompanys ca = new addcompanys(); ca.Show(); } c.name = txtu_Name.Text; c.mobile = textmobile.Text; c.type = texttyp.Text; c.email = textemail.Text; tc = pDAL.Search(textcompany.Text); sucess = tDAL.Insert(c); if (sucess == true) { MessageBox.Show("costumer added sucessfully"); clear(); } else { MessageBox.Show("costumer can not be added"); } }
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 } }