protected void btnSave_Click(object sender, ImageClickEventArgs e) { if (tbIDEmp.Text == "" || tbName.Text == "" || tbDepartment.Text == "") { lbStatus.ForeColor = System.Drawing.Color.Red; lbStatus.Text = "Input All Data!!"; } else { SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-P8LED4T\SQLEXPRESS;Initial Catalog=Borrow;Integrated Security=True; Connect Timeout=15;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"); SqlDataAdapter SearchIDEmp = new SqlDataAdapter("Select Count (*) From Employee Where IDEmp='" + tbIDEmp.Text + "'", con); DataTable dt = new DataTable(); SearchIDEmp.Fill(dt); if (dt.Rows[0][0].ToString() == "1") { lbStatus.ForeColor = System.Drawing.Color.Red; lbStatus.Text = "This ID is Already"; } else { try { dbBorrowDataContext QueryDB = new dbBorrowDataContext(); Employee123 InsertData = new Employee123(); double idemp = Convert.ToDouble(tbIDEmp.Text); InsertData.IDEmp = idemp; InsertData.Name = tbName.Text; InsertData.Department = tbDepartment.Text; QueryDB.Employee123s.InsertOnSubmit(InsertData); QueryDB.SubmitChanges(); gvShow.DataBind(); lbStatus.ForeColor = System.Drawing.Color.Green; lbStatus.Text = "Saved Successed!!"; tbDepartment.Text = ""; tbIDEmp.Text = ""; tbName.Text = ""; } catch { lbStatus.Text = "Input Data Error!!"; lbStatus.ForeColor = System.Drawing.Color.Red; } } } }
protected void btnSave_Click(object sender, ImageClickEventArgs e) { SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-P8LED4T\SQLEXPRESS;Initial Catalog=Borrow;Integrated Security=True; Connect Timeout=15;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"); SqlDataAdapter sda = new SqlDataAdapter("Select Count(*) From Tool where IDTool= '" + tbIDTool.Text + "'", con); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows[0][0].ToString() == "1") { lbStatus.ForeColor = System.Drawing.Color.Red; lbStatus.Text = "This ID is Already"; } else { if (tbIDTool.Text == "" || tbNameTool.Text == "") { lbStatus.ForeColor = System.Drawing.Color.Red; lbStatus.Text = "Input All Data"; } else { try { dbBorrowDataContext QueryDB = new dbBorrowDataContext(); Tool123 InsertData = new Tool123(); double idTool = Convert.ToDouble(tbIDTool.Text); InsertData.IDTool = idTool; InsertData.Description = tbNameTool.Text; QueryDB.Tool123s.InsertOnSubmit(InsertData); QueryDB.SubmitChanges(); lbStatus.ForeColor = System.Drawing.Color.Green; lbStatus.Text = "Added Tool Successed!"; } catch { lbStatus.ForeColor = System.Drawing.Color.Red; lbStatus.Text = "Input Data Error!"; } } } }
protected void btnSave_Click(object sender, ImageClickEventArgs e) { if (txtIDEmp.Text == "" || txtIDTool.Text == "" || txtDate.Text == "") { lbStatus.Text = "Please Input All Data"; lbStatus.ForeColor = System.Drawing.Color.Red; lbDate.Text = "*"; lbIDEmp.Text = "*"; lbIDTool.Text = "*"; } else { try { SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-P8LED4T\SQLEXPRESS;Initial Catalog=Borrow;Integrated Security=True; Connect Timeout=15;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"); SqlDataAdapter CheckEmp = new SqlDataAdapter("Select Count(*) From Employee where IDEmp= '" + txtIDEmp.Text + "'", con); DataTable dtEmp = new DataTable(); CheckEmp.Fill(dtEmp); SqlDataAdapter CheckTool = new SqlDataAdapter("Select Count(*) From Tool where IDTool= '" + txtIDTool.Text + "'", con); DataTable dtTool = new DataTable(); CheckTool.Fill(dtTool); if (dtEmp.Rows[0][0].ToString() == "1" && dtTool.Rows[0][0].ToString() == "1") { dbBorrowDataContext QueryDB = new dbBorrowDataContext(); Borrow InsertData = new Borrow(); InsertData.Detail = txtDetail.Text; double idtool; idtool = Convert.ToDouble(txtIDTool.Text); idtool = double.Parse(txtIDTool.Text); InsertData.IDTool = idtool; var descriptionTool = from tableTool in QueryDB.Tool123s where txtIDTool.Text.Equals(tableTool.IDTool) select tableTool.Description; string Description = ""; foreach (var a in descriptionTool) { Description = a.ToString(); } InsertData.Description = Description; double idemp; idemp = Convert.ToDouble(txtIDEmp.Text); idemp = double.Parse(txtIDEmp.Text); InsertData.IDEmp = idemp; var EmpName = from tableEmployee in QueryDB.Employee123s where txtIDEmp.Text.Equals(tableEmployee.IDEmp) select tableEmployee.Name; string Name = ""; foreach (var a in EmpName) { Name = a.ToString(); } InsertData.Name = Name; var Department = from tableEmployee in QueryDB.Employee123s where txtIDEmp.Text.Equals(tableEmployee.IDEmp) select tableEmployee.Department; string Depart = ""; foreach (var a in Department) { Depart = a.ToString(); } InsertData.Department = Depart; DateTime dt = Convert.ToDateTime(txtDate.Text); InsertData.DateBorrow = dt; InsertData.Amount = txtAmount.Text; InsertData.Detail = txtDetail.Text; QueryDB.Borrows.InsertOnSubmit(InsertData); QueryDB.SubmitChanges(); lbStatus.ForeColor = System.Drawing.Color.Green; lbStatus.Text = "Saved Successed."; gvShow.DataBind(); txtAmount.Text = ""; txtDate.Text = ""; txtDetail.Text = ""; txtIDEmp.Text = ""; txtIDTool.Text = ""; }//if else { lbStatus.Text = "Not Found ID Employee or Tool"; lbStatus.ForeColor = System.Drawing.Color.Red; } }///try catch { lbStatus.Text = "Input Data Error!!"; lbStatus.ForeColor = System.Drawing.Color.Red; } }//else }