protected void btnSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(keyField.Value))//insert
{
DIA_DIEM_DUA_RUOC_MIEN_PHI obj = DIA_DIEM_DUA_RUOC_MIEN_PHI.Insert_Object(txtTenVanPhong.Text, txtDiaChi.Text, ddlTinhThanh.SelectedValue, txtURL.Text.Replace("'", ""));
if (obj == null)
HelpControls.ShowMsgBox(this, "Lưu dữ liệu thất bại!");
else
{
InitListData();
keyField.Value = obj.DIA_DIEM_ID;
btnSave.Text = "Cập nhật";
}
}
else
{
DIA_DIEM_DUA_RUOC_MIEN_PHI dd = new DIA_DIEM_DUA_RUOC_MIEN_PHI();
dd.DIA_DIEM_ID = keyField.Value;
if (dd.Save_Object(txtTenVanPhong.Text, txtDiaChi.Text, ddlTinhThanh.SelectedValue, txtURL.Text.Replace("'", "")))
{
InitListData();
}
else
{
HelpControls.ShowMsgBox(this, "Lưu dữ liệu thất bại!");
}
}
}
//───────────────────────────────────────────────────────────────────────────────────────
public static DIA_DIEM_DUA_RUOC_MIEN_PHI Insert_Object(
string sTEN_DIA_DIEM
,string sDIA_CHI
,string sTINH_THANH
,string sGHI_CHU
)
{
string tem_sTEN_DIA_DIEM=MinhTam.DataAccess.Web.SQLToolWeb.GetSaveValue(sTEN_DIA_DIEM,"nvarchar");
string tem_sDIA_CHI=MinhTam.DataAccess.Web.SQLToolWeb.GetSaveValue(sDIA_CHI,"nchar");
string tem_sTINH_THANH=MinhTam.DataAccess.Web.SQLToolWeb.GetSaveValue(sTINH_THANH,"int");
string tem_sGHI_CHU=MinhTam.DataAccess.Web.SQLToolWeb.GetSaveValue(sGHI_CHU,"nvarchar");
string sqlSave=" INSERT INTO DIA_DIEM_DUA_RUOC_MIEN_PHI("+
"TEN_DIA_DIEM,"
+ "DIA_CHI,"
+ "TINH_THANH,"
+ "GHI_CHU) VALUES("
+tem_sTEN_DIA_DIEM+","
+tem_sDIA_CHI+","
+tem_sTINH_THANH+","
+tem_sGHI_CHU +")";
bool OK = Exec(sqlSave)>=1?true:false;
if (OK)
{
DIA_DIEM_DUA_RUOC_MIEN_PHI newDIA_DIEM_DUA_RUOC_MIEN_PHI= new DIA_DIEM_DUA_RUOC_MIEN_PHI();
newDIA_DIEM_DUA_RUOC_MIEN_PHI.DIA_DIEM_ID=GetTable( " SELECT TOP 1 DIA_DIEM_ID FROM DIA_DIEM_DUA_RUOC_MIEN_PHI ORDER BY DIA_DIEM_ID DESC ").Rows[0][0].ToString();
newDIA_DIEM_DUA_RUOC_MIEN_PHI.TEN_DIA_DIEM=sTEN_DIA_DIEM;
newDIA_DIEM_DUA_RUOC_MIEN_PHI.DIA_CHI=sDIA_CHI;
newDIA_DIEM_DUA_RUOC_MIEN_PHI.TINH_THANH=sTINH_THANH;
newDIA_DIEM_DUA_RUOC_MIEN_PHI.GHI_CHU=sGHI_CHU;
return newDIA_DIEM_DUA_RUOC_MIEN_PHI;
}
else return null ;
}
