public uc_DistrictDetail(uc_District parent, PRO_tblDistrictDTO item)
{
InitializeComponent();
parentForm = parent;
Initialize();
SetPermission();
LoadDataToEdit(item);
}
private void btnUpdate_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (curRow != null)
{
PRO_tblDistrictDTO item = busDistrict.GetDataByID(curRow["DistrictID"] + "", User.UserInfo.Username, User.UserInfo.LanguageID);
if (item != null)
{
Commons.OpenInputForm(new uc_DistrictDetail(this, item), "Cập Nhật Quận Huyện", "Update District", new Size(435, 270));
}
}
}
public uc_DistrictDetail(uc_District _parent_form, PRO_tblDistrictDTO item = null)
{
CommonEngine.ShowWaitForm(this);
InitializeComponent();
Initialize();
parent_form = _parent_form;
if (item != null)
{
LoadDataToEdit(item);
}
CommonEngine.LoadUserPermission("12", txtDistrictID, btnSaveClose, btnSaveInsert);
}
private void LoadDataToEdit(PRO_tblDistrictDTO item)
{
txtDistrictID.EditValue = (item == null) ? null : item.DistrictID;
txtDistrictCode.EditValue = (item == null) ? null : item.DistrictCode;
txtVNName.EditValue = (item == null) ? null : item.VNName;
txtENName.EditValue = (item == null) ? null : item.ENName;
gluProvince.EditValue = (item == null) ? null : item.ProvinceID;
mmoNote.EditValue = (item == null) ? null : item.Note;
chkUsed.Checked = (item == null) ? true : item.Used;
speRank.EditValue = (item == null) ? null : item.Rank;
if (item == null)
{
depError.ClearErrors();
this.ParentForm.Text = (User.UserInfo.LanguageID.Equals("VN")) ? "Thêm Mới Quận Huyện" : "Insert New District";
}
txtDistrictCode.Focus();
}
private void LoadDataToEdit(PRO_tblDistrictDTO item)
{
txtDistrictID.EditValue = (item == null) ? null : item.DistrictID;
txtDistrictCode.EditValue = (item == null) ? null : item.DistrictCode;
//txtDistrictCode.Properties.ReadOnly = (item == null) ? false : true;
txtVNName.EditValue = (item == null) ? null : item.VNName;
txtENName.EditValue = (item == null) ? null : item.ENName;
gluProvince.EditValue = (item == null) ? null : item.ProvinceID;
speRank.EditValue = (item == null) ? null : item.Rank;
chkUsed.Checked = (item == null) ? true : item.Used;
mmoNote.EditValue = (item == null) ? null : item.Note;
if (item == null)
{
depError.ClearErrors();
this.ParentForm.Text = LanguageEngine.GetOpenFormText(this.Name, ConfigEngine.Language, false);
txtDistrictCode.Focus();
}
}
public PRO_tblDistrictDTO GetDataByID(string district_id, string username, string language_id)
{
PRO_tblDistrictDTO result = new PRO_tblDistrictDTO();
try
{
DataTable data = db.GetDataTable("PRO_spfrmDistrict", new string[] { "Activity", "Username", "LanguageID", "DistrictID" }, new object[] { BaseConstant.COMMAND_GET_DATA_BY_ID_EN, username, language_id, district_id });
if (data != null && data.Rows.Count > 0)
{
result = ConvertEngine.ConvertDataTableToObjectList <PRO_tblDistrictDTO>(data)[0];
return(result);
}
}
catch (Exception ex)
{
logger.Error(ex);
}
return(result);
}
private bool SaveDistrict(bool isEdit)
{
string strError = "";
try
{
PRO_tblDistrictDTO item = new PRO_tblDistrictDTO
{
Activity = (isEdit) ? "Update" : "Insert",
Username = User.UserInfo.Username,
LanguageID = User.UserInfo.LanguageID,
DistrictID = txtDistrictID.Text,
DistrictCode = txtDistrictCode.Text,
VNName = txtVNName.Text,
ENName = txtENName.Text,
ProvinceID = gluProvince.EditValue + "",
Rank = speRank.EditValue,
Used = chkUsed.Checked,
Note = mmoNote.EditValue + ""
};
strError = (isEdit) ? busDistrict.UpdateDistrict(item) : busDistrict.InsertDistrict(item);
if (strError != "")
{
Commons.ShowMessage(strError, 0);
txtDistrictCode.Focus();
return(false);
}
else
{
parentForm.LoadAllData();
}
}
catch (Exception ex)
{
Commons.ShowExceptionMessage(ex);
return(false);
}
return(true);
}
public async static Task <PRO_tblDistrictDRO> InsertUpdateDistrict(PRO_tblDistrictDTO item, SYS_tblActionLogDTO actionLog)
{
PRO_tblDistrictDRO result = new PRO_tblDistrictDRO();
try
{
string url = string.Format(@"{0}/InsertUpdateDistrict", GetBaseUrl());
var postData = new PRO_tblDistrictDCO
{
DistrictID = item.DistrictID,
DistrictCode = item.DistrictCode,
VNName = item.VNName,
ENName = item.ENName,
ProvinceID = item.ProvinceID,
Rank = item.Rank,
Used = item.Used,
Note = item.Note,
Activity = item.Activity,
UserID = item.UserID,
LanguageID = item.LanguageID
};
var json_data = "{\"district\":" + JsonConvert.SerializeObject(postData, new JsonSerializerSettings
{
DateFormatHandling = DateFormatHandling.MicrosoftDateFormat
}) + "}";
result = await PRO_tblDistrictDAO.InsertUpdateDistrict(url, json_data);
if (string.IsNullOrEmpty(result.ResponseItem.Message))
{
result.ResponseItem = await SYS_tblActionLogBUS.InsertUpdateLog(actionLog);
}
}
catch (Exception ex)
{
logger.Error(ex);
result.ResponseItem.Message = ex.Message;
}
return(result);
}
public string UpdateDistrict(PRO_tblDistrictDTO item)
{
string strError = "";
strError = db.sExecuteSQL("PRO_spfrmDistrict", new string[] { "Activity", "Username", "LanguageID", "DistrictID", "ProvinceID", "DistrictCode", "VNName", "ENName", "Rank", "Used", "Note" }, new object[] { item.Activity, item.Username, item.LanguageID, item.DistrictID, item.ProvinceID, item.DistrictCode, item.VNName, item.ENName, item.Rank, item.Used, item.Note });
if (strError.Equals(""))
{
strError = this.InsertActionLog(new SYS_tblActionLogDTO
{
Activity = item.Activity,
Username = item.Username,
LanguageID = item.LanguageID,
ActionVN = "Cập Nhật",
ActionEN = "Update",
FunctionID = "12",
DescriptionVN = string.Format("Tài khoản '{0}' vừa cập nhật thành công quận huyện có mã '{1}'.", item.Username, item.DistrictCode),
DescriptionEN = string.Format("Account '{0}' has updated new district successfully with district code is '{1}'.", item.Username, item.DistrictCode)
});
}
return(strError);
}
public string InsertDistrict(PRO_tblDistrictDTO item)
{
string strError = "";
try
{
strError = db.sExecuteSQL("PRO_spfrmDistrict", new string[] { "Activity", "Username", "LanguageID", "DistrictID", "DistrictCode", "ProvinceID", "VNName", "ENName", "Rank", "Used", "Note" }, new object[] { item.Activity, item.UserID, item.LanguageID, item.DistrictID, item.DistrictCode, item.ProvinceID, item.VNName, item.ENName, item.Rank, item.Used, item.Note });
if (!string.IsNullOrEmpty(strError))
{
logger.Error(strError);
}
return(strError);
}
catch (Exception ex)
{
logger.Error(ex);
strError = ex.Message;
}
return(strError);
}
public string UpdateDistrict(PRO_tblDistrictDTO item)
{
return(daoDistrict.UpdateDistrict(item));
}
public string InsertDistrict(PRO_tblDistrictDTO item)
{
return(daoDistrict.InsertDistrict(item));
}
