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