public ActionResult UploadDataFile(HttpPostedFileBase file, string uploadMode) { AjaxResult ajaxResult = new AjaxResult(); RepoResult repoResult = null; IDBContext db = databaseManager.GetContext(); IList <string> errMesgs = new List <string>(); IList <Items> data = new List <Items>(); Toyota.Common.Credential.User u = Lookup.Get <Toyota.Common.Credential.User>(); string userName = u.Username; try { data = this.GetDataLocalUploadExcel(file, errMesgs); if (errMesgs.Count >= 1) { ajaxResult.Result = AjaxResult.VALUE_ERROR; ajaxResult.ErrMesgs = new string[] { string.Format("{0}", errMesgs[0]) }; } else { db.BeginTransaction(); foreach (Items loopInsert in data) { repoResult = itemRepo.InsertUpdate(db, userName, loopInsert, uploadMode); } CopyPropertiesRepoToAjaxResult(repoResult, ajaxResult); if (AjaxResult.VALUE_ERROR.Equals(ajaxResult.Result)) { db.AbortTransaction(); } else { db.CommitTransaction(); } } } catch (Exception ex) { db.AbortTransaction(); ajaxResult.Result = AjaxResult.VALUE_ERROR; ajaxResult.ErrMesgs = new string[] { string.Format("{0} = {1}", ex.GetType().FullName, ex.Message) }; } finally { db.Close(); } return(Json(ajaxResult)); }
public JsonResult AddEditSave(string screenMode, PakAnas.Models.Approval data) { AjaxResult ajaxResult = new AjaxResult(); RepoResult repoResult = null; IDBContext db = databaseManager.GetContext(); try { db.BeginTransaction(); ajaxResult = Validation(data); //Validasi Controller if (AjaxResult.VALUE_SUCCESS.Equals(ajaxResult.Result)) { if (CommonConstant.SCREEN_MODE_ADD.Equals(screenMode)) { repoResult = approvalRepo.Insert(GetLoginUserId(), data); } else if (CommonConstant.SCREEN_MODE_EDIT.Equals(screenMode)) { repoResult = approvalRepo.Update(GetLoginUserId(), data); } CopyPropertiesRepoToAjaxResult(repoResult, ajaxResult); if (AjaxResult.VALUE_ERROR.Equals(ajaxResult.Result)) { db.AbortTransaction(); } else { db.CommitTransaction(); } } } catch (Exception ex) { db.AbortTransaction(); ajaxResult.Result = AjaxResult.VALUE_ERROR; ajaxResult.ErrMesgs = new string[] { string.Format("{0} = {1}", ex.GetType().FullName, ex.Message) }; } finally { db.Close(); } return(Json(ajaxResult)); }
public ActionResult AddEditSave(string screenMode, PakAnass data) { AjaxResult ajaxResult = new AjaxResult(); RepoResult repoResult = null; IDBContext db = databaseManager.GetContext(); Toyota.Common.Credential.User u = Lookup.Get <Toyota.Common.Credential.User>(); string userName = u.Username; try { repoResult = pakanasRepo.InsertUpdate(db, userName, data, screenMode); CopyPropertiesRepoToAjaxResult(repoResult, ajaxResult); if (AjaxResult.VALUE_ERROR.Equals(ajaxResult.Result)) { db.AbortTransaction(); } else { db.CommitTransaction(); } } catch (Exception ex) { db.AbortTransaction(); ajaxResult.Result = AjaxResult.VALUE_ERROR; ajaxResult.ErrMesgs = new string[] { string.Format("{0} = {1}", ex.GetType().FullName, ex.Message) }; } finally { db.Close(); } return(Json(ajaxResult)); }
public JsonResult Delete(List <string> selectedKeys) { AjaxResult ajaxResult = new AjaxResult(); RepoResult repoResult = null; IDBContext db = databaseManager.GetContext(); try { db.BeginTransaction(); repoResult = pakanasRepo.DeleteMultiple(db, selectedKeys); CopyPropertiesRepoToAjaxResult(repoResult, ajaxResult); if (AjaxResult.VALUE_ERROR.Equals(ajaxResult.Result)) { db.AbortTransaction(); } else { db.CommitTransaction(); } } catch (Exception ex) { db.AbortTransaction(); ajaxResult.Result = AjaxResult.VALUE_ERROR; ajaxResult.ErrMesgs = new string[] { string.Format("{0} = {1}", ex.GetType().FullName, ex.Message) }; } finally { db.Close(); } return(Json(ajaxResult)); }
public int UpdateData(string record, string table, string PK) { IDBContext db = DatabaseManager.Instance.GetContext(); var tambah = record.Replace("+", " "); var ubah = tambah.Replace("%3A", ":"); var split = ubah.Split('&'); var tampung = ""; string[] split_tampungnya; var field = ""; var value = ""; int res = 0; db.BeginTransaction(); try { for (int i = 0; i < split.Length; i++) { tampung = split[i]; split_tampungnya = tampung.Split('='); if (field == "") { field = split_tampungnya[0].ToString(); value = split_tampungnya[1].ToString(); } else { field = field + "," + split_tampungnya[0].ToString(); value = value + "," + split_tampungnya[1].ToString(); } } res = db.Execute("Master/SimpleMasterCustom_UpdateData", new { P_FIELD = field, P_VALUE = value, P_TABLE = table, PK = PK, }); db.Close(); db.CommitTransaction(); } catch (Exception E) { db.AbortTransaction(); } return(res); }
public int DeleteData(string PK, string table) { IDBContext db = DatabaseManager.Instance.GetContext(); int res = 0; db.BeginTransaction(); try { res = db.Execute("Master/SimpleMasterCustom_DeleteData", new { PK = PK, TABLE_NAME = table }); db.Close(); db.CommitTransaction(); } catch (Exception E) { db.AbortTransaction(); } return(res); }
public ActionResult AddEditSave(string screenMode, Items data) { AjaxResult ajaxResult = new AjaxResult(); RepoResult repoResult = null; IDBContext db = databaseManager.GetContext(); Toyota.Common.Credential.User u = Lookup.Get <Toyota.Common.Credential.User>(); string userName = u.Username; try { db.BeginTransaction(); ajaxResult = Validation(data); //Validasi Controller if (AjaxResult.VALUE_SUCCESS.Equals(ajaxResult.Result)) { if (CommonConstant.SCREEN_MODE_EDIT.Equals(screenMode)) { Items dtUpload = itemRepo.GetByKey(data.ITEM_CODE); if (dtUpload.UPLOAD_PATH != null) { if (dtUpload.UPLOAD_PATH != data.UPLOAD_HALF_PATH) { this.DeleteUploadedFile(dtUpload.UPLOAD_PATH); } } } repoResult = itemRepo.InsertUpdate(db, userName, data, screenMode); CopyPropertiesRepoToAjaxResult(repoResult, ajaxResult); if (AjaxResult.VALUE_ERROR.Equals(ajaxResult.Result)) { db.AbortTransaction(); } else { db.CommitTransaction(); string sourceDirPath = itemRepo.FindBySettingCd(CommonConstant.SYS_FILE_LOC_TEMP_FOLDER); string destDirPath = itemRepo.FindBySettingCd(CommonConstant.SYS_FILE_LOC_MAIN_FOLDER); MoveFiles(sourceDirPath, destDirPath, data.UPLOAD_HALF_PATH); } } } catch (Exception ex) { db.AbortTransaction(); ajaxResult.Result = AjaxResult.VALUE_ERROR; ajaxResult.ErrMesgs = new string[] { string.Format("{0} = {1}", ex.GetType().FullName, ex.Message) }; } finally { db.Close(); } return(Json(ajaxResult)); }