public PRO_tblWarehouseDTO GetDataByID(string username, string language_id, string warehouse_id) { PRO_tblWarehouseDTO result = new PRO_tblWarehouseDTO(); try { DataTable data = db.GetDataTable("PRO_spfrmWarehouse", new string[] { "Activity", "Username", "LanguageID", "WarehouseID" }, new object[] { BaseConstant.COMMAND_GET_DATA_BY_ID_EN, username, language_id, warehouse_id }); if (data != null && data.Rows.Count > 0) { result = ConvertEngine.ConvertDataTableToObjectList<PRO_tblWarehouseDTO>(data)[0]; return result; } } catch (Exception ex) { logger.Error(ex); } return result; }
public async static Task<PRO_tblWarehouseDRO> InsertUpdateStore(PRO_tblWarehouseDTO item, SYS_tblActionLogDTO actionLog) { PRO_tblWarehouseDRO result = new PRO_tblWarehouseDRO(); try { string url = string.Format(@"{0}/InsertUpdateWarehouse", GetBaseUrl()); var postData = new PRO_tblWarehouseDCO { WarehouseID = item.WarehouseID, WarehouseCode = item.WarehouseCode, VNName = item.VNName, ENName = item.ENName, StoreID = item.StoreID, AddressVN = item.AddressVN, AddressEN = item.AddressEN, Phone = item.Phone, Fax = item.Fax, ProvinceID = string.IsNullOrEmpty(item.ProvinceID) ? null : item.ProvinceID, DistrictID = string.IsNullOrEmpty(item.DistrictID) ? null : item.DistrictID, Rank = item.Rank, Used = item.Used, Note = item.Note, UserID = item.UserID, Activity = item.Activity, LanguageID = item.LanguageID }; var json_data = "{\"warehouse\":" + JsonConvert.SerializeObject(postData, new JsonSerializerSettings { DateFormatHandling = DateFormatHandling.MicrosoftDateFormat }) + "}"; result = await PRO_tblWarehouseDAO.InsertUpdateWarehouse(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 uc_WarehouseDetail(uc_Warehouse _parent_form, PRO_tblWarehouseDTO item = null) { CommonEngine.ShowWaitForm(this); InitializeComponent(); Initialize(); parent_form = _parent_form; if (item != null) LoadDataToEdit(item); CommonEngine.LoadUserPermission("18", txtWarehouseID, btnSaveClose, btnSaveInsert); }
private void LoadDataToEdit(PRO_tblWarehouseDTO item) { txtWarehouseID.EditValue = (item == null) ? null : item.WarehouseID; txtWarehouseCode.EditValue = (item == null) ? null : item.WarehouseCode; //txtWarehouseCode.Properties.ReadOnly = (item == null) ? false : true; txtVNName.EditValue = (item == null) ? null : item.VNName; txtENName.EditValue = (item == null) ? null : item.ENName; gluStore.EditValue = (item == null) ? null : item.StoreID; txtAddressEN.EditValue = (item == null) ? null : item.AddressEN; txtAddressVN.EditValue = (item == null) ? null : item.AddressVN; gluProvince.EditValue = (item == null) ? null : item.ProvinceID; gluDistrict.EditValue = (item == null) ? null : item.DistrictID; txtPhone.EditValue = (item == null) ? null : item.Phone; txtFax.EditValue = (item == null) ? null : item.Fax; 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); txtWarehouseCode.Focus(); } }
public string InsertWarehouse(PRO_tblWarehouseDTO item) { string strError = ""; try { strError = db.sExecuteSQL("PRO_spfrmWarehouse", new string[] { "Activity", "Username", "LanguageID", "WarehouseID", "WarehouseCode", "VNName", "ENName", "AddressVN", "AddressEN", "Phone", "Fax", "Rank", "Used", "Note", "StoreID", "ProvinceID", "DistrictID" }, new object[] { item.Activity, item.UserID, item.LanguageID, item.WarehouseID, item.WarehouseCode, item.VNName, item.ENName, item.AddressVN, item.AddressEN, item.Phone, item.Fax, item.Rank, item.Used, item.Note, item.StoreID, item.ProvinceID, item.DistrictID }); if (!string.IsNullOrEmpty(strError)) logger.Error(strError); return strError; } catch (Exception ex) { logger.Error(ex); strError = ex.Message; } return strError; }