public int UpdateDVT(Info.DonViInfo info)
{
cn.ExecuteNonQuery("SP_UPDATEDONVI",
new string[] { "@MADONVI", "@TEN", "@TRANGTHAI" },
new object[] { info.Ma, info.Ten, info.TrangThai });
return(1);
}
public int InsertEmployee(Info.DonViInfo info)
{
//int id = _cn.ExecuteInsert("sp_InserttblMember",
// new string[] { "@UserName", "@Password", "@FullName", "@AuthenticationID", "@Email", "@Address", "@IdentityCardNumber", "@Phone", "@Birthday", "@Pic", "@Active" },
// new object[] { ey.UserName, ey.Password, ey.FullName, ey.AuthenticationID, ey.Email, ey.Address, ey.IdentityCardNumber, ey.Phone, ey.Birthday, ey.Pic, ey.Active });
return(0);
}
public int DeleteDVT(Info.DonViInfo info)
{
int id = cn.ExecuteNonQuery("sp_DeleteDONVI",
new string[] { "@MA" },
new object[] { info.Ma });
return(id);
}
public int InsertDVT(Info.DonViInfo info)
{
int id = cn.ExecuteInsert("SP_INSERTDONVI",
new string[] { "@TEN", "@TRANGTHAI" },
new object[] { info.Ten, info.TrangThai });
return(id);
}
public void UpdateEmployee(Info.DonViInfo info)
{
//_cn.ExecuteNonQuery("sp_UpdatetblMember",
// new string[] { "@ID", "@UserName", "@Password", "@FullName", "@AuthenticationID", "@Email", "@Address", "@IdentityCardNumber", "@Phone", "@Birthday", "@Pic", "@Active" },
// new object[] { ey.ID, ey.UserName, ey.Password, ey.FullName, ey.AuthenticationID, ey.Email, ey.Address, ey.IdentityCardNumber, ey.Phone, ey.Birthday, ey.Pic, ey.Active });
}
