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 ActionResult UploadAttachment(HttpPostedFileBase file, string uploadItemCode, string uploadMode)
        {
            Toyota.Common.Credential.User u = Lookup.Get <Toyota.Common.Credential.User>();
            uploadItemCode = u.Username;

            string folderName = "Photo";

            return(UploadFileMultiplePhysicalPath(file, folderName, uploadItemCode, uploadMode));
        }
Beispiel #3
0
        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 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));
        }