public uc_ProvinceDetail(uc_Province parent, PRO_tblProvinceDTO item) { InitializeComponent(); parentForm = parent; Initialize(); LoadDataToEdit(item); SetPermission(); }
private void btnUpdate_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (curRow != null) { PRO_tblProvinceDTO item = busProvince.GetDataByID(curRow["ProvinceID"] + "", User.UserInfo.Username, User.UserInfo.LanguageID); if (item != null) { Commons.OpenInputForm(new uc_ProvinceDetail(this, item), "Cập Nhật Tỉnh Thành", "Update Province", new Size(435, 265)); } } }
public uc_ProvinceDetail(uc_Province _parent_form, PRO_tblProvinceDTO item = null) { CommonEngine.ShowWaitForm(this); InitializeComponent(); Initialize(); parent_form = _parent_form; if (item != null) { LoadDataToEdit(item); } CommonEngine.LoadUserPermission("8", txtProvinceID, btnSaveClose, btnSaveInsert); }
private void LoadDataToEdit(PRO_tblProvinceDTO item) { txtProvinceID.EditValue = (item == null) ? null : item.ProvinceID; txtProvinceCode.EditValue = (item == null) ? null : item.ProvinceCode; txtVNName.EditValue = (item == null) ? null : item.VNName; txtENName.EditValue = (item == null) ? null : item.ENName; speRank.EditValue = (item == null) ? 0 : item.Rank; chkUsed.EditValue = (item == null) ? true : item.Used; mmoNote.EditValue = (item == null) ? null : item.Note; if (item == null) { depError.ClearErrors(); this.ParentForm.Text = (User.UserInfo.LanguageID.Equals("VN")) ? "Thêm Mới Tỉnh Thành" : "Insert New Province"; } txtProvinceCode.Focus(); }
private void LoadDataToEdit(PRO_tblProvinceDTO item) { txtProvinceID.EditValue = (item == null) ? null : item.ProvinceID; txtProvinceCode.EditValue = (item == null) ? null : item.ProvinceCode; //txtProvinceCode.Properties.ReadOnly = (item == null) ? false : true; txtVNName.EditValue = (item == null) ? null : item.VNName; txtENName.EditValue = (item == null) ? null : item.ENName; 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); txtProvinceCode.Focus(); } }
public PRO_tblProvinceDTO GetDataByID(string province_id, string username, string language_id) { PRO_tblProvinceDTO result = new PRO_tblProvinceDTO(); try { DataTable data = db.GetDataTable("PRO_spfrmProvince", new string[] { "Activity", "Username", "LanguageID", "ProvinceID" }, new object[] { BaseConstant.COMMAND_GET_DATA_BY_ID_EN, username, language_id, province_id }); if (data != null && data.Rows.Count > 0) { result = ConvertEngine.ConvertDataTableToObjectList <PRO_tblProvinceDTO>(data)[0]; return(result); } } catch (Exception ex) { logger.Error(ex); } return(result); }
public async static Task <PRO_tblProvinceDRO> InsertUpdateProvince(PRO_tblProvinceDTO item, SYS_tblActionLogDTO actionLog) { PRO_tblProvinceDRO result = new PRO_tblProvinceDRO(); try { string url = string.Format(@"{0}/InsertUpdateProvince", GetBaseUrl()); var postData = new PRO_tblProvinceDCO { ProvinceID = item.ProvinceID, ProvinceCode = item.ProvinceCode, VNName = item.VNName, ENName = item.ENName, Rank = item.Rank, Used = item.Used, Note = item.Note, Activity = item.Activity, UserID = item.UserID, LanguageID = item.LanguageID }; var json_data = "{\"province\":" + JsonConvert.SerializeObject(postData, new JsonSerializerSettings { DateFormatHandling = DateFormatHandling.MicrosoftDateFormat }) + "}"; result = await PRO_tblProvinceDAO.InsertUpdateProvince(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); }
private bool SaveProvince(bool isEdit) { string strError = ""; try { PRO_tblProvinceDTO item = new PRO_tblProvinceDTO { Activity = (isEdit) ? "Update" : "Insert", Username = User.UserInfo.Username, LanguageID = User.UserInfo.LanguageID, ProvinceID = txtProvinceID.Text, ProvinceCode = txtProvinceCode.Text, VNName = txtVNName.Text, ENName = txtENName.Text, Rank = speRank.EditValue, Note = mmoNote.Text, Used = chkUsed.Checked }; strError = (isEdit) ? busProvince.UpdateProvince(item) : busProvince.InsertProvince(item); if (strError != "") { Commons.ShowMessage(strError, 0); txtProvinceCode.Focus(); return(false); } else { parentForm.LoadAllData(); } } catch (Exception ex) { Commons.ShowExceptionMessage(ex); return(false); } return(true); }
public string UpdateProvince(PRO_tblProvinceDTO item) { string strError = ""; strError = db.sExecuteSQL("PRO_spfrmProvince", new string[] { "Activity", "Username", "LanguageID", "ProvinceID", "ProvinceCode", "VNName", "ENName", "Rank", "Used", "Note" }, new object[] { item.Activity, item.Username, item.LanguageID, item.ProvinceID, item.ProvinceCode, item.VNName, item.ENName, item.Rank, item.Used, item.Note }); if (strError.Equals("")) { strError = this.InsertActionLog(new SYS_tblActionLogDTO { Activity = "Insert", Username = item.Username, LanguageID = item.LanguageID, ActionVN = "Cập Nhật", ActionEN = "Update", FunctionID = "8", DescriptionVN = string.Format("Tài khoản '{0}' vừa cập nhật thành công tỉnh thành có mã '{1}'.", item.Username, item.ProvinceCode), DescriptionEN = string.Format("Account '{0}' has updated new province successfully with province code is '{1}'.", item.Username, item.ProvinceCode) }); } return(strError); }
public string InsertProvince(PRO_tblProvinceDTO item) { string strError = ""; try { strError = db.sExecuteSQL("PRO_spfrmProvince", new string[] { "Activity", "Username", "LanguageID", "ProvinceID", "ProvinceCode", "VNName", "ENName", "Rank", "Used", "Note" }, new object[] { item.Activity, item.UserID, item.LanguageID, item.ProvinceID, item.ProvinceCode, 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 UpdateProvince(PRO_tblProvinceDTO item) { return(daoProvince.UpdateProvince(item)); }
public string InsertProvince(PRO_tblProvinceDTO item) { return(daoProvince.InsertProvince(item)); }