public int Update(DoanKhachVO doankhachVO)
{
try
{
return(doankhachDAO.Update(doankhachVO));
}
catch (Exception e)
{
throw e;
}
}
} //end method LoadFind
public int Insert(DoanKhachVO doankhachVO)
{
try
{
return(doankhachDAO.Insert(doankhachVO));
}
catch (Exception e)
{
throw e;
}
}
private DoanKhachVO GetDoanKhachVO()
{
DoanKhachVO doankhachVO = new DoanKhachVO();
doankhachVO.MA_DOAN_KHACH = int.Parse(txt_MaDoanKhach.Text.Substring(2));
doankhachVO.MA_CONG_TY = int.Parse(cbo_MaCongTy.SelectedValue.ToString().Substring(2));
// doankhachVO.NGAY_DEN = DateTime.ParseExact(date_NgayDen.Text, "dd/MM/yyyy hh:mm:ss tt",null);
doankhachVO.NGAY_DEN = date_NgayDen.DateTime;
doankhachVO.HIEU_LUC = true;
return(doankhachVO);
}
public int Update(DoanKhachVO doankhachVO)
{
try
{
String query = "UPDATE DOAN_KHACH SET MA_CONG_TY=@MA_CONG_TY,NGAY_DEN=@NGAY_DEN WHERE MA_DOAN_KHACH=@MA_DOAN_KHACH";
SqlParameter[] sqlParameters = new SqlParameter[3];
sqlParameters[0] = new SqlParameter("@MA_DOAN_KHACH", doankhachVO.MA_DOAN_KHACH);
sqlParameters[1] = new SqlParameter("@MA_CONG_TY", doankhachVO.MA_CONG_TY);
sqlParameters[2] = new SqlParameter("@NGAY_DEN", doankhachVO.NGAY_DEN);
return(Program.dbConnection.ExecuteNonQuery(query, sqlParameters));
}
catch (Exception e)
{
throw e;
}
}
public int Insert(DoanKhachVO doankhachVO)
{
try
{
String query = "INSERT INTO DOAN_KHACH VALUES(@MA_CONGTY,@NGAY_DEN,@HIEU_LUC)";
SqlParameter[] sqlParameters = new SqlParameter[3];
sqlParameters[0] = new SqlParameter("@MA_CONGTY", doankhachVO.MA_CONG_TY);
sqlParameters[1] = new SqlParameter("@NGAY_DEN", doankhachVO.NGAY_DEN);
sqlParameters[2] = new SqlParameter("@HIEU_LUC", doankhachVO.HIEU_LUC);
return(Program.dbConnection.ExecuteNonQuery(query, sqlParameters));
}
catch (Exception e)
{
throw e;
}
}
