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; }