public string InsertStore(PRO_tblStoreDTO item)
{
string strError = "";
try
{
if (string.IsNullOrEmpty(item.Photo))
{
item.Photo = @"Data\Images\no_image.png";
}
strError = db.sExecuteSQL("PRO_spfrmStore", new string[] { "Activity", "Username", "LanguageID", "StoreID", "StoreCode", "ShortCode", "VNName", "ENName", "BuildDate", "EndDate", "AddressVN", "AddressEN", "Phone", "Fax", "Rank", "TaxCode", "Used", "IsRoot", "Representives", "Note", "Photo", "ProvinceID", "DistrictID" }, new object[] { item.Activity, item.UserID, item.LanguageID, item.StoreID, item.StoreCode, item.ShortCode, item.VNName, item.ENName, item.BuildDate, item.EndDate, item.AddressVN, item.AddressEN, item.Phone, item.Fax, item.Rank, item.TaxCode, item.Used, item.IsRoot, item.Representatives, item.Note, item.Photo, item.ProvinceID, item.DistrictID });
if (!string.IsNullOrEmpty(strError))
{
logger.Error(strError);
}
return(strError);
}
catch (Exception ex)
{
logger.Error(ex);
strError = ex.Message;
}
return(strError);
}
private void LoadDataToEdit(PRO_tblStoreDTO item)
{
txtStoreID.EditValue = (item == null) ? null : item.StoreID;
txtStoreCode.EditValue = (item == null) ? null : item.StoreCode;
txtShortCode.EditValue = (item == null) ? null : item.ShortCode;
txtVNName.EditValue = (item == null) ? null : item.VNName;
txtENName.EditValue = (item == null) ? null : item.ENName;
dteBuildDate.EditValue = (item == null) ? null : item.BuildDate;
dteEndDate.EditValue = (item == null) ? null : item.EndDate;
picPhoto.EditValue = (item == null) ? null : item.Photo;
txtAddressVN.EditValue = (item == null) ? null : item.AddressVN;
txtAddressEN.EditValue = (item == null) ? null : item.AddressEN;
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;
txtTaxCode.EditValue = (item == null) ? null : item.TaxCode;
speRank.EditValue = (item == null) ? null : item.Rank;
txtRepresentives.EditValue = (item == null) ? null : item.Representatives;
chkIsRoot.Checked = (item == null) ? false : item.IsRoot;
chkUsed.Checked = (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 Cửa Hàng" : "Insert New Store";
}
txtStoreCode.Focus();
}
public uc_StoreDetail(uc_Store parent, PRO_tblStoreDTO item)
{
InitializeComponent();
parentForm = parent;
Initialize();
LoadDataToEdit(item);
SetPermission();
}
private void btnUpdate_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (curRow != null)
{
PRO_tblStoreDTO item = busStore.GetDataByID(curRow["StoreID"] + "", User.UserInfo.Username, User.UserInfo.LanguageID);
if (item != null)
{
Commons.OpenInputForm(new uc_StoreDetail(this, item), "Cập Nhật Cửa Hàng", "Update Store", new Size(660, 400));
}
}
}
public uc_StoreDetail(uc_Store _parent_form, PRO_tblStoreDTO item = null)
{
CommonEngine.ShowWaitForm(this);
InitializeComponent();
Initialize();
parent_form = _parent_form;
if (item != null)
{
LoadDataToEdit(item);
}
CommonEngine.LoadUserPermission("13", txtStoreID, btnSaveClose, btnSaveInsert);
}
public async static Task <PRO_tblStoreDRO> InsertUpdateStore(PRO_tblStoreDTO item, SYS_tblActionLogDTO actionLog)
{
PRO_tblStoreDRO result = new PRO_tblStoreDRO();
try
{
string url = string.Format(@"{0}/InsertUpdateStore", GetBaseUrl());
var postData = new PRO_tblStoreDCO
{
StoreID = item.StoreID,
StoreCode = item.StoreCode,
ShortCode = item.ShortCode,
VNName = item.VNName,
ENName = item.ENName,
BuildDate = item.BuildDate,
EndDate = item.EndDate,
AddressVN = item.AddressVN,
AddressEN = item.AddressEN,
Phone = item.Phone,
Fax = item.Fax,
TaxCode = item.TaxCode,
Rank = item.Rank,
Used = item.Used,
IsRoot = item.IsRoot,
Representatives = item.Representatives,
Note = item.Note,
Photo = item.Photo,
ProvinceID = string.IsNullOrEmpty(item.ProvinceID) ? null : item.ProvinceID,
DistrictID = string.IsNullOrEmpty(item.DistrictID) ? null : item.DistrictID,
UserID = item.UserID,
Activity = item.Activity,
LanguageID = item.LanguageID
};
var json_data = "{\"store\":" + JsonConvert.SerializeObject(postData, new JsonSerializerSettings
{
DateFormatHandling = DateFormatHandling.MicrosoftDateFormat
}) + "}";
result = await PRO_tblStoreDAO.InsertUpdateStore(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 SaveStore(bool isEdit)
{
string strError = "";
try
{
PRO_tblStoreDTO item = new PRO_tblStoreDTO
{
Activity = (isEdit) ? "Update" : "Insert",
Username = User.UserInfo.Username,
LanguageID = User.UserInfo.LanguageID,
StoreID = txtStoreID.Text,
StoreCode = txtStoreCode.Text,
ShortCode = txtShortCode.Text,
VNName = txtVNName.Text,
ENName = txtENName.Text,
BuildDate = dteBuildDate.EditValue,
EndDate = dteEndDate.EditValue,
AddressVN = txtAddressVN.Text,
AddressEN = txtAddressEN.Text,
Phone = txtPhone.Text,
Fax = txtFax.Text,
Rank = speRank.EditValue,
TaxCode = txtTaxCode.Text,
Used = chkUsed.Checked,
IsRoot = chkIsRoot.Checked,
Representatives = txtRepresentives.Text,
Note = mmoNote.Text,
Photo = picPhoto.EditValue,
ProvinceID = gluProvince.EditValue + "",
DistrictID = gluDistrict.EditValue + ""
};
strError = (isEdit) ? busStore.UpdateStore(item) : busStore.InsertStore(item);
if (strError != "")
{
Commons.ShowMessage(strError, 0);
txtStoreCode.Focus();
return(false);
}
else
{
parentForm.LoadAllData();
}
}
catch (Exception ex)
{
Commons.ShowExceptionMessage(ex);
return(false);
}
return(true);
}
public PRO_tblStoreDTO GetDataByID(string username, string language_id, string store_id)
{
PRO_tblStoreDTO result = new PRO_tblStoreDTO();
try
{
DataTable data = db.GetDataTable("PRO_spfrmStore", new string[] { "Activity", "Username", "LanguageID", "StoreID" }, new object[] { BaseConstant.COMMAND_GET_DATA_BY_ID_EN, username, language_id, store_id });
if (data != null && data.Rows.Count > 0)
{
result = ConvertEngine.ConvertDataTableToObjectList <PRO_tblStoreDTO>(data)[0];
return(result);
}
}
catch (Exception ex)
{
logger.Error(ex);
}
return(result);
}
public string UpdateStore(PRO_tblStoreDTO item)
{
string strError = "";
strError = db.sExecuteSQL("PRO_spfrmStore", new string[] { "Activity", "Username", "LanguageID", "StoreID", "StoreCode", "ShortCode", "VNName", "ENName", "BuildDate", "EndDate", "AddressVN", "AddressEN", "Phone", "Fax", "Rank", "TaxCode", "Used", "IsRoot", "Representives", "Note", "Photo", "ProvinceID", "DistrictID" }, new object[] { item.Activity, item.Username, item.LanguageID, item.StoreID, item.StoreCode, item.ShortCode, item.VNName, item.ENName, item.BuildDate, item.EndDate, item.AddressVN, item.AddressEN, item.Phone, item.Fax, item.Rank, item.TaxCode, item.Used, item.IsRoot, item.Representatives, item.Note, item.Photo, item.ProvinceID, item.DistrictID });
if (strError.Equals(""))
{
strError = this.InsertActionLog(new DTO.System.SYS_tblActionLogDTO
{
Activity = "Insert",
Username = item.Username,
LanguageID = item.LanguageID,
ActionVN = "Cập Nhật",
ActionEN = "Update",
FunctionID = "13",
DescriptionVN = string.Format("Tài khoản '{0}' vừa cập nhật thành công cửa hàng có mã '{1}'.", item.Username, item.StoreCode),
DescriptionEN = string.Format("Account '{0}' has updated store successfully with store code is '{1}'.", item.Username, item.StoreCode)
});
}
return(strError);
}
private void LoadDataToEdit(PRO_tblStoreDTO item)
{
txtStoreID.EditValue = (item == null) ? null : item.StoreID;
txtStoreCode.EditValue = (item == null) ? null : item.StoreCode;
//txtStoreCode.Properties.ReadOnly = (item == null) ? false : true;
txtShortCode.EditValue = (item == null) ? null : item.ShortCode;
txtVNName.EditValue = (item == null) ? null : item.VNName;
txtENName.EditValue = (item == null) ? null : item.ENName;
dteBuildDate.EditValue = (item == null) ? null : item.BuildDate;
dteEndDate.EditValue = (item == null) ? null : item.EndDate;
txtAddressVN.EditValue = (item == null) ? null : item.AddressVN;
txtAddressEN.EditValue = (item == null) ? null : item.AddressEN;
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;
txtTaxCode.EditValue = (item == null) ? null : item.TaxCode;
speRank.EditValue = (item == null) ? null : item.Rank;
txtRepresentives.EditValue = (item == null) ? null : item.Representatives;
chkIsRoot.Checked = (item == null) ? false : item.IsRoot;
chkUsed.Checked = (item == null) ? true : item.Used;
mmoNote.EditValue = (item == null) ? null : item.Note;
if (item != null && !string.IsNullOrEmpty(item.PhotoUri))
{
picPhoto.LoadAsync(item.PhotoUri);
}
else
{
picPhoto.EditValue = null;
}
if (item == null)
{
depError.ClearErrors();
this.ParentForm.Text = LanguageEngine.GetOpenFormText(this.Name, ConfigEngine.Language, false);
txtStoreCode.Focus();
}
}
public string UpdateStore(PRO_tblStoreDTO item)
{
return(daoStore.UpdateStore(item));
}
public string InsertStore(PRO_tblStoreDTO item)
{
return(daoStore.InsertStore(item));
}
