protected void btnSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(keyField.Value))//insert
{
DIA_DIEM_DU_LICH obj = DIA_DIEM_DU_LICH.Insert_Object(txtTenVanPhong.Text, txtDiaChi.Text, ddlTinhThanh.SelectedValue, txtSoDienThoai.Text, txtMoTa.Text.Replace("'", ""), 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_DU_LICH dd = new DIA_DIEM_DU_LICH();
dd.DIA_DIEM_ID = keyField.Value;
if (dd.Save_Object(txtTenVanPhong.Text, txtDiaChi.Text, ddlTinhThanh.SelectedValue, txtSoDienThoai.Text, txtMoTa.Text.Replace("'", ""), txtURL.Text.Replace("'", "")))
{
InitListData();
}
else
{
HelpControls.ShowMsgBox(this, "Lưu dữ liệu thất bại!");
}
}
}
//───────────────────────────────────────────────────────────────────────────────────────
public static DIA_DIEM_DU_LICH Insert_Object(
string sTEN_DIA_DIEM
,string sDIA_CHI
,string sTINH_THANH
,string sSO_DIEN_THOAI
,string sMO_TA
,string sMAP_URL
)
{
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,"nvarchar");
string tem_sTINH_THANH=MinhTam.DataAccess.Web.SQLToolWeb.GetSaveValue(sTINH_THANH,"int");
string tem_sSO_DIEN_THOAI=MinhTam.DataAccess.Web.SQLToolWeb.GetSaveValue(sSO_DIEN_THOAI,"varchar");
string tem_sMO_TA=MinhTam.DataAccess.Web.SQLToolWeb.GetSaveValue(sMO_TA,"ntext");
string tem_sMAP_URL=MinhTam.DataAccess.Web.SQLToolWeb.GetSaveValue(sMAP_URL,"ntext");
string sqlSave=" INSERT INTO DIA_DIEM_DU_LICH("+
"TEN_DIA_DIEM,"
+ "DIA_CHI,"
+ "TINH_THANH,"
+ "SO_DIEN_THOAI,"
+ "MO_TA,"
+ "MAP_URL) VALUES("
+tem_sTEN_DIA_DIEM+","
+tem_sDIA_CHI+","
+tem_sTINH_THANH+","
+tem_sSO_DIEN_THOAI+","
+tem_sMO_TA+","
+tem_sMAP_URL +")";
bool OK = Exec(sqlSave)>=1?true:false;
if (OK)
{
DIA_DIEM_DU_LICH newDIA_DIEM_DU_LICH= new DIA_DIEM_DU_LICH();
newDIA_DIEM_DU_LICH.DIA_DIEM_ID=GetTable( " SELECT TOP 1 DIA_DIEM_ID FROM DIA_DIEM_DU_LICH ORDER BY DIA_DIEM_ID DESC ").Rows[0][0].ToString();
newDIA_DIEM_DU_LICH.TEN_DIA_DIEM=sTEN_DIA_DIEM;
newDIA_DIEM_DU_LICH.DIA_CHI=sDIA_CHI;
newDIA_DIEM_DU_LICH.TINH_THANH=sTINH_THANH;
newDIA_DIEM_DU_LICH.SO_DIEN_THOAI=sSO_DIEN_THOAI;
newDIA_DIEM_DU_LICH.MO_TA=sMO_TA;
newDIA_DIEM_DU_LICH.MAP_URL=sMAP_URL;
return newDIA_DIEM_DU_LICH;
}
else return null ;
}