public PRO_tblStallDTO GetDataByID(string username, string language_id, string stall_id)
{
PRO_tblStallDTO result = new PRO_tblStallDTO();
try
{
DataTable data = db.GetDataTable("PRO_spfrmStall", new string[] { "Activity", "Username", "LanguageID", "StallID" }, new object[] { BaseConstant.COMMAND_GET_DATA_BY_ID_EN, username, language_id, stall_id });
if (data != null && data.Rows.Count > 0)
{
result = ConvertEngine.ConvertDataTableToObjectList<PRO_tblStallDTO>(data)[0];
return result;
}
}
catch (Exception ex)
{
logger.Error(ex);
}
return result;
}
public async static Task<PRO_tblStallDRO> InsertUpdateStall(PRO_tblStallDTO item, SYS_tblActionLogDTO actionLog)
{
PRO_tblStallDRO result = new PRO_tblStallDRO();
try
{
string url = string.Format(@"{0}/InsertUpdateStall", GetBaseUrl());
var postData = new PRO_tblStallDCO
{
StallID = item.StallID,
StallCode = item.StallCode,
VNName = item.VNName,
ENName = item.ENName,
StoreID = item.StoreID,
WarehouseID = item.WarehouseID,
Rank = item.Rank,
Used = item.Used,
Note = item.Note,
UserID = item.UserID,
Activity = item.Activity,
LanguageID = item.LanguageID
};
var json_data = "{\"stall\":" + JsonConvert.SerializeObject(postData, new JsonSerializerSettings
{
DateFormatHandling = DateFormatHandling.MicrosoftDateFormat
}) + "}";
result = await PRO_tblStallDAO.InsertUpdateStall(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 InsertStall(PRO_tblStallDTO item)
{
string strError = "";
try
{
strError = db.sExecuteSQL("PRO_spfrmStall", new string[] { "Activity", "Username", "LanguageID", "StallID", "StallCode", "VNName", "ENName", "Rank", "Used", "Note", "StoreID", "WarehouseID" }, new object[] { item.Activity, item.UserID, item.LanguageID, item.StallID, item.StallCode, item.VNName, item.ENName, item.Rank, item.Used, item.Note, item.StoreID, item.WarehouseID });
if (!string.IsNullOrEmpty(strError))
logger.Error(strError);
return strError;
}
catch (Exception ex)
{
logger.Error(ex);
strError = ex.Message;
}
return strError;
}
