public static LoaiHopThuMODEL getLoaiHopThuByID(int id)
{
LoaiHopThuMODEL loaiHopThuModel = new LoaiHopThuMODEL();
//String sql = ConfigurationManager.AppSettings["sql.getLoaiHopThuByID"];
//SqlCommand objCommand = new SqlCommand(sql);
//objCommand.Parameters.AddWithValue("@id", id);
//DataTable result = DataUtil.executeQuery(objCommand);
SqlParameter[] parameter = new SqlParameter[1];
int i = 0;
parameter[i] = new SqlParameter("ID", SqlDbType.VarChar);
parameter[i++].Value = id;
DataTable result = DataUtil.executeStore("sp_getLoaiHopThuByID", parameter);
foreach (DataRow row in result.Rows)
{
loaiHopThuModel.Id = row["ID"].ToString();
loaiHopThuModel.Ten = row["Ten"].ToString();
loaiHopThuModel.Ghi_Chu = row["Ghi_chu"].ToString();
loaiHopThuModel.Ngay_Cap_Nhat_Cuoi = row["Ngay_cap_nhat_cuoi"].ToString();
loaiHopThuModel.User11 = row["User1"].ToString();
loaiHopThuModel.User21 = row["User2"].ToString();
loaiHopThuModel.User31 = row["User3"].ToString();
loaiHopThuModel.User41 = row["User4"].ToString();
loaiHopThuModel.User51 = row["User5"].ToString();
}
return(loaiHopThuModel);
}
private void but_Edit_Click(object sender, EventArgs e)
{
but_Add.Enabled = false;
if (Constants.id.Equals(""))
{
MessageBox.Show("bạn chưa chọn dòng để thay đổi. Xin hãy chọn lại:", "Thông Báo");
}
else
{
pnl_InboxType.Visible = true;
Constants.choose = 2;
loaiHopThuModel = LoaiHopThuDAO.getLoaiHopThuByID(Convert.ToInt32(Constants.id));
txt_IDInbox.Text = loaiHopThuModel.Id;
txt_NameInbox.Text = loaiHopThuModel.Ten;
txt_Note.Text = loaiHopThuModel.Ghi_Chu;
but_Ok.Text = "Cập Nhật";
}
}
public static bool insertLoaiHopThu(LoaiHopThuMODEL loaiHopThuModel)
{
try
{
SqlParameter[] parameter = new SqlParameter[8];
int i = 0;
//parameter[i] = new SqlParameter("ID", SqlDbType.NVarChar);
//parameter[i++].Value = loaiHopThuModel.Id;
parameter[i] = new SqlParameter("Ten", SqlDbType.NVarChar);
parameter[i++].Value = loaiHopThuModel.Ten;
parameter[i] = new SqlParameter("Ghi_chu", SqlDbType.NVarChar);
parameter[i++].Value = loaiHopThuModel.Ghi_Chu;
parameter[i] = new SqlParameter("Ngay_cap_nhat_cuoi", SqlDbType.NVarChar);
parameter[i++].Value = "";
parameter[i] = new SqlParameter("User1", SqlDbType.VarChar);
parameter[i++].Value = "";
parameter[i] = new SqlParameter("User2", SqlDbType.NVarChar);
parameter[i++].Value = "";
parameter[i] = new SqlParameter("User3", SqlDbType.NVarChar);
parameter[i++].Value = "";
parameter[i] = new SqlParameter("User4", SqlDbType.NVarChar);
parameter[i++].Value = "";
parameter[i] = new SqlParameter("User5", SqlDbType.NVarChar);
parameter[i++].Value = "";
Boolean kq = DataUtil.executeNonStore("sp_SMS_InertLoaiHopThu", parameter);
return(kq);
}
catch (Exception)
{
throw;
}
}
