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
}
