/// <summary>
/// 更改员工
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Update_EmployeeTableData(Employee_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Update"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@E_id", obj.E_id),
new SqlParameter("@Dep_id", obj.Dep_id),
new SqlParameter("@E_Address", obj.E_Address),
new SqlParameter("@E_Date", obj.E_Date),
new SqlParameter("@E_Education", obj.E_Education),
new SqlParameter("@E_IdS", obj.E_IdS),
new SqlParameter("@E_LastLoginAddress", obj.E_LastLoginAddress),
new SqlParameter("@E_LastLoginDate", obj.E_LastLoginDate),
new SqlParameter("@E_LoginAddress", obj.E_LoginAddress),
new SqlParameter("@E_LoginDate", obj.E_LoginDate),
new SqlParameter("@E_Name", obj.E_Name),
new SqlParameter("@E_Pay", obj.E_Pay),
new SqlParameter("@E_Phone", obj.E_Phone),
new SqlParameter("@E_School", obj.E_School),
new SqlParameter("@E_Sex", obj.E_Sex),
new SqlParameter("@E_UserName", obj.E_UserName),
new SqlParameter("@IDT_id", obj.IDT_id),
new SqlParameter("@LS_ID", obj.LS_ID),
new SqlParameter("@Post_id", obj.Post_id),
new SqlParameter("@E_UserPwd", obj.E_UserPwd)
}));
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
ForceValidation();
if (Validation.GetHasError(txtName) || Validation.GetHasError(txtPhone) ||
Validation.GetHasError(txtDesg) || Validation.GetHasError(txtSalary) ||
Validation.GetHasError(txtAddress))
{
MessageBox.Show("Error Some Data is Missing", "ERROR");
return;
}
Employee_Table obj = new Employee_Table();
obj.E_Name = txtName.Text.Trim();
int ph = Convert.ToInt32(txtPhone.Text);
obj.E_Phone = ph;
obj.E_Desg = txtDesg.Text.Trim();
obj.E_Address = txtAddress.Text.Trim();
obj.E_Salary = decimal.Parse(txtSalary.Text);
EmployeeFactory iobj = new EmployeeFactory();
if (iobj.insert(obj))
{
MessageBox.Show("Data Saved Successfully", "Saved");
txtName.Text = null;
txtDesg.Text = null;
txtAddress.Text = null;
txtPhone.Text = null;
txtSalary.Text = null;
}
else
{
MessageBox.Show("Error in Data ", "Error");
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
ForceValidation();
if (Validation.GetHasError(txtName) || Validation.GetHasError(txtPhone) ||
Validation.GetHasError(txtDesg) || Validation.GetHasError(txtSalary) ||
Validation.GetHasError(txtAddress))
{
MessageBox.Show("Error Some Data is Missing", "ERROR");
return;
}
EmployeeFactory EFobj = new EmployeeFactory();
_vm = new EmployeeViewModel();
Employee_Table Eobj = new Employee_Table();
Eobj.E_ID = EmployeeId;
Eobj.E_Name = txtName.Text;
Eobj.E_Address = txtAddress.Text;
Eobj.E_Desg = txtDesg.Text;
Eobj.E_Salary = decimal.Parse(txtSalary.Text.ToString());
Eobj.E_Phone = int.Parse(txtPhone.Text.ToString());
if (EFobj.Update(Eobj))
{
MessageBox.Show("Data is Changed Successfully", "Changed");
}
else
{
MessageBox.Show("Data is not Changed", "ERROR");
}
this.Close();
}
public bool Delete(string Name)
{
Employee_Table std = obj.Employee_Table.Where(x => x.E_Name == Name).FirstOrDefault();
if (std != null)
{
obj.Employee_Table.Remove(std);
}
return(obj.SaveChanges() > 0);
}
//get the record of the Employee to dislplay on loading the database
public void OnGet(int?id)
{
if (id != null)
{//get the details after comparing the id
var data = (from Employee in Context.Employee_Table
where Employee.id == id
select Employee).SingleOrDefault();
Employee = data;
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
EmployeeFactory EFobj = new EmployeeFactory();
Employee_Table ETobj = EFobj.GetAllByName(EmployeeId);
_vm = new EmployeeViewModel();
_vm.E_Name = ETobj.E_Name;
_vm.E_Address = ETobj.E_Address;
_vm.E_Desg = ETobj.E_Desg;
_vm.E_Phone = ETobj.E_Phone;
_vm.E_Salary = ETobj.E_Salary;
this.DataContext = _vm;
}
public bool Update(Employee_Table ETobj)
{
Employee_Table std = obj.Employee_Table.Where(x => x.E_ID == ETobj.E_ID).FirstOrDefault();
if (std != null)
{
std.E_Name = ETobj.E_Name;
std.E_Desg = ETobj.E_Desg;
std.E_Address = ETobj.E_Address;
std.E_Salary = ETobj.E_Salary;
std.E_Phone = ETobj.E_Phone;
}
return(obj.SaveChanges() > 0);
}
/// <summary>
/// 根据ID查询员工信息
/// </summary>
/// <param name="con"></param>
/// <returns></returns>
public Employee_Table GetEmployeeTableByConn(string con)
{
Employee_Table obj = null;
SqlDataReader dr = DBHerlper.ExecuteReader(
"Select * from Employee_Table where E_id=@E_id",
CommandType.Text, new SqlParameter[] {
new SqlParameter("@E_id", con)
});
if (dr.Read())
{
obj = new Employee_Table()
{
Dep_id = Convert.ToInt32(dr["Dep_id"]),
E_Address = dr["E_Address"].ToString(),
E_Date = Convert.ToDateTime(dr["E_Date"]),
E_Education = dr["E_Education"].ToString(),
E_id = Convert.ToInt32(dr["E_id"]),
E_IdS = dr["E_IdS"].ToString(),
E_LastLoginAddress = dr["E_LastLoginAddress"].ToString(),
E_LastLoginDate = Convert.ToDateTime(dr["E_LastLoginDate"]),
E_LoginAddress = dr["E_LoginAddress"].ToString(),
E_LoginDate = Convert.ToDateTime(dr["E_LoginDate"]),
E_Name = dr["E_Name"].ToString(),
E_Pay = Convert.ToDouble(dr["E_Pay"]),
E_Phone = dr["E_Phone"].ToString(),
E_School = dr["E_School"].ToString(),
E_Sex = dr["E_Sex"].ToString(),
E_UserName = dr["E_UserName"].ToString(),
E_UserPwd = dr["E_UserPwd"].ToString(),
IDT_id = Convert.ToInt32(dr["IDT_id"]),
LS_ID = Convert.ToInt32(dr["LS_ID"]),
Post_id = Convert.ToInt32(dr["Post_id"])
};
}
dr.Close();
DBHerlper.CloseConn();
return(obj);
}
/// <summary>
/// 获取全部的员工
/// </summary>
/// <returns></returns>
public List <Employee_Table> GetEmployeeTableAll()
{
List <Employee_Table> list = new List <Employee_Table>();
SqlDataReader dr = DBHerlper.ExecuteReader(GetSqlString("Select"),
CommandType.StoredProcedure);
while (dr.Read())
{
Employee_Table obj = new Employee_Table()
{
Dep_id = Convert.ToInt32(dr["Dep_id"]),
E_Address = dr["E_Address"].ToString(),
E_Date = Convert.ToDateTime(dr["E_Date"]),
E_Education = dr["E_Education"].ToString(),
E_id = Convert.ToInt32(dr["E_id"]),
E_IdS = dr["E_IdS"].ToString(),
E_LastLoginAddress = dr["E_LastLoginAddress"].ToString(),
E_LastLoginDate = Convert.ToDateTime(dr["E_LastLoginDate"]),
E_LoginAddress = dr["E_LoginAddress"].ToString(),
E_LoginDate = Convert.ToDateTime(dr["E_LoginDate"]),
E_Name = dr["E_Name"].ToString(),
E_Pay = Convert.ToDouble(dr["E_Pay"]),
E_Phone = dr["E_Phone"].ToString(),
E_School = dr["E_School"].ToString(),
E_Sex = dr["E_Sex"].ToString(),
E_UserName = dr["E_UserName"].ToString(),
E_UserPwd = dr["E_UserPwd"].ToString(),
IDT_id = Convert.ToInt32(dr["IDT_id"]),
LS_ID = Convert.ToInt32(dr["LS_ID"]),
Post_id = Convert.ToInt32(dr["Post_id"])
};
list.Add(obj);
}
dr.Close();
return(list);
}
public bool Insert(Employee_Table eobj)
{
obj.Employee_Table.Add(eobj);
return(obj.SaveChanges() > 0);
}
/// <summary>
/// 添加员工信息
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_EmployeeTableData(Employee_Table obj)
{
return(relevanceClass.Insert_EmployeeTableData(obj));
}
/// <summary>
/// 更改员工信息
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Update_EmployeeTableData(Employee_Table obj)
{
return(relevanceClass.Update_EmployeeTableData(obj));
}
