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 txtSearch_TextChanged(object sender, EventArgs e) { //Get the keyword fro the text box string keyword = txtcSearch.Text; if (keyword == "") { //Clear all the textboxes txtcname.Text = ""; txtcemail.Text = ""; txtcmobile.Text = ""; txtclocation.Text = ""; txtcsubend.Text = ""; return; } //Write the code to get the details and set the value on text boxes companysBLL dc = pDAL.Search(keyword); //Now transfer or set the value from DeCustBLL to textboxes txtcname.Text = dc.c_name; txtcemail.Text = dc.c_email; txtcmobile.Text = dc.c_mobile; txtclocation.Text = dc.c_location; txtccatogary.Text = dc.c_category; txtcsubend.Text = dc.subend_date; }
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"); } }
private void button2_Click(object sender, EventArgs e) { companysBLL dc = new companysBLL(); dc.id = Convert.ToInt32(cidtxt.Text); dc.c_name = txtcname.Text; dc.c_email = txtcemail.Text; dc.c_mobile = txtcmobile.Text; dc.c_location = txtclocation.Text; dc.c_category = txtccatogary.Text; dc.subend_date = txtcsubend.Text; dc.substart_date = "vaibhav"; bool success = pDAL.Delete(dc); if (success == true) { MessageBox.Show("company deleted sucessfully"); clear(); DataTable dt = new DataTable(); dt = pDAL.Select(); dvgcinfo.DataSource = dt; } else { MessageBox.Show("company can not be deleted"); } }
private void txtu_Name_TextChanged(object sender, EventArgs e) { //Get the keyword fro the text box string keyword = txtu_Name.Text; if (keyword == "") { //Clear all the textboxes txtu_Name.Text = ""; txtu_Contact.Text = ""; txtcompany.Text = ""; textqry.Text = ""; return; } custBLL dc = tDAL.searchcustumer(keyword); //Write the code to get the details and set the value on text boxes //queryBLL q = new queryBLL(); //Now transfer or set the value from DeCustBLL to textboxes // dc.name= txtu_Name.Text; txtu_Contact.Text = dc.mobile; int Cid = dc.cid; companysBLL c = pDAL.Searchfromid(Cid); txtcompany.Text = c.c_name; txtemail.Text = dc.email; }
public bool Update(companysBLL p) { //create a boolean variable and set its initial value to false bool isSuccess = false; //Create SQL Connection for DAtabase SqlConnection conn = new SqlConnection(myconnstrng); try { //SQL Query to Update Data in dAtabase String sql = "UPDATE tbl_companys SET c_name=@c_name, c_category=@c_category, c_location=@c_location, c_mobile=@c_mobile, substart_date=@substart_date, subend_date=@subend_date WHERE id=@id"; //Create SQL Cmmand to pass the value to query SqlCommand cmd = new SqlCommand(sql, conn); //Passing the values using parameters and cmd cmd.Parameters.AddWithValue("@c_name", p.c_name); cmd.Parameters.AddWithValue("@c_category", p.c_category); cmd.Parameters.AddWithValue("@c_location", p.c_location); cmd.Parameters.AddWithValue("@c_mobile", p.c_mobile); cmd.Parameters.AddWithValue("@c_email", p.c_email); cmd.Parameters.AddWithValue("@substart_date", p.substart_date); cmd.Parameters.AddWithValue("@subend_date", p.subend_date); cmd.Parameters.AddWithValue("@id", p.id); //Open the Database connection conn.Open(); //Create Int Variable to check if the query is executed successfully or not int rows = cmd.ExecuteNonQuery(); //if the query is executed successfully then the value of rows will be greater than 0 else it will be less than zero if (rows > 0) { //Query ExecutedSuccessfully isSuccess = true; } else { //Failed to Execute Query isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(isSuccess); }
public bool Insert(companysBLL p) { //Creating Boolean Variable and set its default value to false bool isSuccess = false; //Sql Connection for DAtabase SqlConnection conn = new SqlConnection(myconnstrng); try { //SQL Query to insert company into database String sql = "INSERT INTO tbl_companys (c_name, c_category, c_location, c_mobile, c_email, substart_date, subend_date) VALUES (@c_name, @c_category, @c_location, @c_mobile, @c_email, @substart_date, @subend_date)"; //Creating SQL Command to pass the values SqlCommand cmd = new SqlCommand(sql, conn); //Passign the values through parameters cmd.Parameters.AddWithValue("@c_name", p.c_name); cmd.Parameters.AddWithValue("@c_category", p.c_category); cmd.Parameters.AddWithValue("@c_location", p.c_location); cmd.Parameters.AddWithValue("@c_mobile", p.c_mobile); cmd.Parameters.AddWithValue("@c_email", p.c_email); cmd.Parameters.AddWithValue("@substart_date", p.substart_date); cmd.Parameters.AddWithValue("@subend_date", p.subend_date); //Opening the Database connection conn.Open(); int rows = cmd.ExecuteNonQuery(); //If the query is executed successfully then the value of rows will be greater than 0 else it will be less than 0 if (rows > 0) { //Query Executed Successfully isSuccess = true; } else { //FAiled to Execute Query isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(isSuccess); }
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"); } } } }
public bool Delete(companysBLL p) { //Create Boolean Variable and Set its default value to false bool isSuccess = false; //SQL Connection for DB connection SqlConnection conn = new SqlConnection(myconnstrng); try { //Write Query company from DAtabase String sql = "DELETE FROM tbl_companys WHERE id=@id"; //Sql Command to Pass the Value SqlCommand cmd = new SqlCommand(sql, conn); //Passing the values using cmd cmd.Parameters.AddWithValue("@id", p.id); //Open Database Connection conn.Open(); int rows = cmd.ExecuteNonQuery(); //If the query is executed successfullly then the value of rows will be greated than 0 else it will be less than 0 if (rows > 0) { //Query Executed Successfully isSuccess = true; } else { //Failed to Execute Query isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(isSuccess); }
public companysBLL Searchfromid(int keywords) { //SQL Connection fro DB Connection SqlConnection conn = new SqlConnection(myconnstrng); //Creating DAtaTable to hold value from dAtabase companysBLL p = new companysBLL(); DataTable dt = new DataTable(); try { //SQL query to search company string sql = "SELECT * FROM tbl_companys WHERE id LIKE '%" + keywords + "%' "; //Sql Command to execute Query SqlCommand cmd = new SqlCommand(sql, conn); //SQL Data Adapter to hold the data from database temporarily SqlDataAdapter adapter = new SqlDataAdapter(cmd); //Open Database Connection conn.Open(); adapter.Fill(dt); if (dt.Rows.Count > 0) { p.c_name = dt.Rows[0]["c_name"].ToString(); p.c_mobile = dt.Rows[0]["c_mobile"].ToString(); p.id = int.Parse(dt.Rows[0]["id"].ToString()); p.c_email = dt.Rows[0]["c_email"].ToString(); p.c_category = dt.Rows[0]["c_category"].ToString(); p.c_location = (dt.Rows[0]["c_location"].ToString()); p.id = int.Parse(dt.Rows[0]["id"].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(p); }
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; }
public bool chkcompanybyname(string keyword) { bool sucess = false; //Create an object of companysBLL and return it companysBLL p = new companysBLL(); //SqlConnection SqlConnection conn = new SqlConnection(myconnstrng); //Datatable to store data temporarily DataTable dt = new DataTable(); try { //Write the Query to Get the detaisl string sql = "SELECT c_name, c_mobile, c_email FROM tbl_companys WHERE c_name LIKE '%" + keyword + "%' OR c_mobile LIKE '%" + keyword + "%'"; //Create Sql Data Adapter to Execute the query SqlDataAdapter adapter = new SqlDataAdapter(sql, conn); //Open DAtabase Connection conn.Open(); //Pass the value from adapter to dt adapter.Fill(dt); //If we have any values on dt then set the values to companysBLL if (dt.Rows.Count > 0) { sucess = true; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { //Close Database Connection conn.Close(); } return(sucess); }
public companysBLL GetcompanysForTransaction(string keyword) { //Create an object of companysBLL and return it companysBLL p = new companysBLL(); //SqlConnection SqlConnection conn = new SqlConnection(myconnstrng); //Datatable to store data temporarily DataTable dt = new DataTable(); try { //Write the Query to Get the detaisl string sql = "SELECT id FROM tbl_companys WHERE c_name LIKE '%" + keyword + "%' OR c_mobile LIKE '%" + keyword + "%'"; //Create Sql Data Adapter to Execute the query SqlDataAdapter adapter = new SqlDataAdapter(sql, conn); //Open DAtabase Connection conn.Open(); //Pass the value from adapter to dt adapter.Fill(dt); //If we have any values on dt then set the values to companysBLL if (dt.Rows.Count > 0) { p.id = int.Parse(dt.Rows[0]["id"].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { //Close Database Connection conn.Close(); } return(p); }
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"); } }
public DataTable Select(string user, string company) { //Create Sql Connection to connect Databaes SqlConnection conn = new SqlConnection(myconnstrng); companysBLL qb = new companysBLL(); companysDAL qd = new companysDAL(); qb = qd.Search(company); //DAtaTable to hold the data from database DataTable dt = new DataTable(); try { //Writing the Query to Select all the companys from database String sql = "SELECT q_id,u_name,u_mobile,ques,soln FROM tbl_query WHERE c_id =" + qb.id + "AND u_name LIKE '%" + user + "%'"; //Creating SQL Command to Execute Query SqlCommand cmd = new SqlCommand(sql, conn); //SQL Data Adapter to hold the value from database temporarily SqlDataAdapter adapter = new SqlDataAdapter(cmd); //Open DAtabase Connection conn.Open(); adapter.Fill(dt); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(dt); }
public companysBLL GetcompanyIDFromc_name(int c_id) { //First Create an Object of DeaCust BLL and REturn it companysBLL p = new companysBLL(); //SQL Conection here SqlConnection conn = new SqlConnection(myconnstrng); //Data TAble to Holdthe data temporarily DataTable dt = new DataTable(); try { //SQL Query to Get id based on c_name string sql = "SELECT id FROM tbl_companys WHERE id='" + c_id + "'"; //Create the SQL Data Adapter to Execute the Query SqlDataAdapter adapter = new SqlDataAdapter(sql, conn); conn.Open(); //Passing the CAlue from Adapter to DAtatable adapter.Fill(dt); if (dt.Rows.Count > 0) { //Pass the value from dt to DeaCustBLL dc p.id = int.Parse(dt.Rows[0]["id"].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(p); }
private void button1_Click(object sender, EventArgs e) { companysBLL dc = new companysBLL(); dc.id = Convert.ToInt32(cidtxt.Text); pDAL.Update(dc); bool success = pDAL.Update(dc); if (success == true) { MessageBox.Show("company updated sucessfully"); clear(); DataTable dt = new DataTable(); dt = pDAL.Select(); dvgcinfo.DataSource = dt; } else { MessageBox.Show("company can not be updated"); } }
private void txtSearchProduct_TextChanged(object sender, EventArgs e) { //Get the keyword from productsearch textbox string keyword = txtSearchProduct.Text; //Check if we have value to txtSearchProduct or not if (keyword == "") { txtProductName.Text = ""; txtInventory.Text = ""; txtRate.Text = ""; TxtQty.Text = ""; return; } //Search the product and display on respective textboxes companysBLL p = pDAL.GetcompanysForTransaction(keyword); //Set the values on textboxes based on p object txtProductName.Text = p.c_name; txtInventory.Text = p.c_mobile.ToString(); txtRate.Text = p.c_email.ToString(); }
private void btnSave_Click(object sender, EventArgs e) { //Get the Values from PurchaseSales Form First transactionsBLL transaction = new transactionsBLL(); transaction.type = lblTop.Text; //Get the ID of Dealer or Customer Here //Lets get name of the dealer or customer first string deaCustName = txtName.Text; DeaCustBLL dc = dcDAL.GetDeaCustIDFromName(deaCustName); transaction.dea_cust_id = dc.id; transaction.grandTotal = Math.Round(decimal.Parse(txtGrandTotal.Text), 2); transaction.transaction_date = DateTime.Now; transaction.tax = decimal.Parse(txtVat.Text); transaction.discount = decimal.Parse(txtDiscount.Text); //Get the Username of Logged in user string username = frmLogin.loggedIn; userBLL u = uDAL.GetIDFromUsername(username); transaction.added_by = u.id; transaction.transactionDetails = transactionDT; //Lets Create a Boolean Variable and set its value to false bool success = false; //Actual Code to Insert Transaction And Transaction Details using (TransactionScope scope = new TransactionScope()) { int transactionID = -1; //Create aboolean value and insert transaction bool w = tDAL.Insert_Transaction(transaction, out transactionID); //Use for loop to insert Transaction Details for (int i = 0; i < transactionDT.Rows.Count; i++) { //Get all the details of the product transactionDetailBLL transactionDetail = new transactionDetailBLL(); //Get the Product name and convert it to id string ProductName = transactionDT.Rows[i][0].ToString(); companysBLL p = pDAL.GetcompanyIDFromc_name(1); transactionDetail.product_id = p.id; transactionDetail.rate = decimal.Parse(transactionDT.Rows[i][1].ToString()); transactionDetail.qty = decimal.Parse(transactionDT.Rows[i][2].ToString()); transactionDetail.total = Math.Round(decimal.Parse(transactionDT.Rows[i][3].ToString()), 2); transactionDetail.dea_cust_id = dc.id; transactionDetail.added_date = DateTime.Now; transactionDetail.added_by = u.id; //Here Increase or Decrease Product Quantity based on Purchase or sales string transactionType = lblTop.Text; //Lets check whether we are on Purchase or Sales bool x = false; if (transactionType == "Purchase") { //Increase the Product x = pDAL.Increasecompany(transactionDetail.product_id, transactionDetail.qty); } else if (transactionType == "Sales") { //Decrease the Product Quntiyt x = pDAL.Decreasecompany(transactionDetail.product_id, transactionDetail.qty); } //Insert Transaction Details inside the database bool y = tdDAL.InsertTransactionDetail(transactionDetail); success = w && x && y; } if (success == true) { //Transaction Complete scope.Complete(); //Code to Print Bill DGVPrinter printer = new DGVPrinter(); printer.Title = "\r\n\r\n\r\n ANYSTORE PVT. LTD. \r\n\r\n"; printer.SubTitle = "Kathmandu, Nepal \r\n Phone: 01-045XXXX \r\n\r\n"; printer.SubTitleFormatFlags = StringFormatFlags.LineLimit | StringFormatFlags.NoClip; printer.PageNumbers = true; printer.PageNumberInHeader = false; printer.PorportionalColumns = true; printer.HeaderCellAlignment = StringAlignment.Near; printer.Footer = "Discount: " + txtDiscount.Text + "% \r\n" + "VAT: " + txtVat.Text + "% \r\n" + "Grand Total: " + txtGrandTotal.Text + "\r\n\r\n" + "Thank you for doing business with us."; printer.FooterSpacing = 15; printer.PrintDataGridView(dgvAddedProducts); MessageBox.Show("Transaction Completed Sucessfully"); //Celar the Data Grid View and Clear all the TExtboxes dgvAddedProducts.DataSource = null; dgvAddedProducts.Rows.Clear(); txtSearch.Text = ""; txtName.Text = ""; txtEmail.Text = ""; txtContact.Text = ""; txtAddress.Text = ""; txtSearchProduct.Text = ""; txtProductName.Text = ""; txtInventory.Text = "0"; txtRate.Text = "0"; TxtQty.Text = "0"; txtSubTotal.Text = "0"; txtDiscount.Text = "0"; txtVat.Text = "0"; txtGrandTotal.Text = "0"; txtPaidAmount.Text = "0"; txtReturnAmount.Text = "0"; } else { //Transaction Failed MessageBox.Show("Transaction Failed"); } } }
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 } }
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(); } } }
private void button1_Click(object sender, EventArgs e) { #region dal and bll custBLL c = new custBLL(); custDAL cd = new custDAL(); queryBLL q = new queryBLL(); queryDAL qd = new queryDAL(); companysBLL b = new companysBLL(); companysDAL dc = new companysDAL(); #endregion #region query variables string ques; string ans; int cid; string cname; #endregion #region user details //int id; string type = "user"; string email; string name = ""; string mobile; //int nquery; #endregion int i = dataGridView1.Rows.Count; i--; for (int j = 1; j < i; j++) { cname = dataGridView1.Rows[j].Cells[4].Value.ToString(); bool sucess = cd.chkcustumer(cname); if (sucess == false) { #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 adding the user bool isuser = cd.chkcustumer(name); if (isuser == false) { c.name = name; c.mobile = mobile; c.email = email; c.type = type; b = dc.GetcompanysForTransaction(cname); cid = b.id; c.cid = cid; c.nquery = 0; bool useradded = cd.Insert(c); bool qinc = cd.Increasenoofquery(c); if (useradded == false) { MessageBox.Show("user adding failed"); } } #endregion } } }