Пример #1
0
        }                             //End public PhotogalleryCRUD()

        public void Create(PhotogallerydetailVM poViewModel, HttpPostedFileBase poFileimage = null)
        {
            try
            {
                using (var db = new DBMAINContext())
                {
                    Photogallery oModel = new Photogallery();
                    //Map Form Data
                    oModel.InjectFrom(poViewModel);
                    //Set Field Header
                    oModel.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
                    //Set DTA_STS
                    oModel.DTA_STS = valFLAG.FLAG_DTA_STS_CREATE;
                    //Set Image file name
                    oModel.PHOTO_IMG = Utility_FileUploadDownload.setImage_Gallery();

                    //Process CRUD
                    db.Photogallerys.Add(oModel);
                    db.SaveChanges();
                    this.ID = oModel.ID;

                    //Save file
                    if (poFileimage != null)
                    {
                        Utility_FileUploadDownload.saveImage_Gallery(poFileimage, oModel.PHOTO_IMG);
                    }                                                                                //End if (poFileimage != null)
                } //End using
            } //End try
            catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Create: " + e.Message; } //End catch
        }                                                                                      //End public void Create
Пример #2
0
        } //End public void Commit()

        private void FileSave()
        {
            if ((this.oFileuploaded != null) && (this.FILE_NAME != null))
            {
                Utility_FileUploadDownload.saveImage_Employee(this.oFileuploaded, this.FILE_NAME);
            }
        } //End public void Commit()
Пример #3
0
        }                        //End public StudentCRUD()

        public void Create(StudentdetailVM poViewModel, HttpPostedFileBase poFileimage = null)
        {
            try
            {
                using (var db = new DBMAINContext())
                {
                    Student oModel = new Student();
                    //Map Form Data
                    oModel.InjectFrom(poViewModel);
                    //Set Field Header
                    oModel.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
                    //Set Image file name
                    if (poFileimage != null)
                    {
                        oModel.STUDENT_IMG = Utility_FileUploadDownload.setImage_Student();
                    }                                                                                                //End if (poFileimage != null)

                    //Process CRUD
                    db.Students.Add(oModel);
                    db.SaveChanges();
                    this.ID = oModel.ID;

                    //Save file
                    if (poFileimage != null)
                    {
                        Utility_FileUploadDownload.saveImage_Student(poFileimage, oModel.STUDENT_IMG);
                    }                                                                                //End if (poFileimage != null)
                } //End using
            } //End try
            catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Create: " + e.Message; } //End catch
        }                                                                                      //End public void Create
Пример #4
0
        }                                                                                      //End public void Create

        public void Update(StudentdetailVM poViewModel, HttpPostedFileBase poFileimage = null)
        {
            try
            {
                using (var db = new DBMAINContext())
                {
                    Student oModel = db.Students.AsNoTracking().SingleOrDefault(fld => fld.ID == poViewModel.ID);
                    //Map Form Data
                    oModel.InjectFrom(poViewModel);
                    //Set Field Header
                    oModel.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
                    //Set DTA_STS
                    oModel.DTA_STS = valFLAG.FLAG_DTA_STS_UPDATE;
                    //Set Image file name
                    if (poFileimage != null)
                    {
                        if ((oModel.STUDENT_IMG == null) || (oModel.STUDENT_IMG == ""))
                        {
                            oModel.STUDENT_IMG = Utility_FileUploadDownload.setImage_Student();
                        }
                    }                                                                                                                                                                    //End if (poFileimage != null)
                    //Process CRUD
                    db.Entry(oModel).State = EntityState.Modified;
                    db.SaveChanges();
                    this.ID = oModel.ID;

                    //Save file
                    if (poFileimage != null)
                    {
                        Utility_FileUploadDownload.saveImage_Student(poFileimage, oModel.STUDENT_IMG);
                    }                                                                        //End if (poFileimage != null)
                }                                                                            //End using
            }                                                                                //End try
            catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Update" + e.Message; } //End catch
        }                                                                                    //End public void Update
Пример #5
0
        }                                                                                      //End public void Create

        public void Update(EmployeeVM poViewModel, HttpPostedFileBase poFileimage = null)
        {
            try
            {
                this.DELETE_FILE = false;
                this.oModel      = this.db.Employees.AsNoTracking().SingleOrDefault(fld => fld.ID == poViewModel.ID);
                //Map Form Data
                this.oModel.InjectFrom(poViewModel);
                //Set Field Header
                this.oModel.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
                //Set DTA_STS
                this.oModel.DTA_STS = valFLAG.FLAG_DTA_STS_UPDATE;
                //Set Image file name
                if (poFileimage != null)
                {
                    this.oFileuploaded = poFileimage;
                    if ((this.oModel.EMPLOYEE_IMG == null) || (this.oModel.EMPLOYEE_IMG == ""))
                    {
                        this.oModel.EMPLOYEE_IMG = Utility_FileUploadDownload.setImage_Employee();
                    }                                                                              //End if
                } //End if
                this.FILE_NAME = this.oModel.EMPLOYEE_IMG;

                //Process CRUD
                this.db.Entry(this.oModel).State = EntityState.Modified;
                //this.db.SaveChanges();
                //this.ID = this.oModel.ID;
            }                                                                                //End try
            catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Update" + e.Message; } //End catch
        }                                                                                    //End public void Update
Пример #6
0
        }                   //End public EmployeeCRUD()

        public void Create(EmployeeVM poViewModel, HttpPostedFileBase poFileimage = null)
        {
            try
            {
                this.DELETE_FILE = false;
                this.oModel      = new Employee();
                //Map Form Data
                this.oModel.InjectFrom(poViewModel);
                //Set Field Header
                this.oModel.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
                //Set DTA_STS
                this.oModel.DTA_STS = valFLAG.FLAG_DTA_STS_CREATE;
                //Set Image file name
                if (poFileimage != null)
                {
                    this.oFileuploaded = poFileimage;
                    if ((this.oModel.EMPLOYEE_IMG == null) || (this.oModel.EMPLOYEE_IMG == ""))
                    {
                        this.oModel.EMPLOYEE_IMG = Utility_FileUploadDownload.setImage_Employee();
                    }                                                                              //End if
                } //End if
                this.FILE_NAME = this.oModel.EMPLOYEE_IMG;

                //Process CRUD
                this.db.Employees.Add(this.oModel);
                //this.db.SaveChanges();
                //this.ID = this.oModel.ID;
            }                                                                                  //End try
            catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Create: " + e.Message; } //End catch
        }                                                                                      //End public void Create
Пример #7
0
        } //End public void Commit()

        private void FileDelete()
        {
            //Delete Image file
            if (this.FILE_NAME != null)
            {
                Utility_FileUploadDownload.deleteImage_Employee(this.FILE_NAME);
            }
        } //End public void Commit()
Пример #8
0
        public void CreateCPAR(User_DetailCPARVM poViewModel, HttpPostedFileBase poFileimage)
        {
            string vsMsgErr = "";
            try
            {
                using (var db = new DBMAINContext())
                {
                    #region User Area
                        User oModel = new User();
                        //Map Form Data
                        //Mapper.CreateMap<User_DetailCPARVM, User>();
                        //oModel = Mapper.Map<User_DetailCPARVM, User>(poViewModel);
                        //Set Field Header
                        oModel.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
                        //Set DTA_STS
                        oModel.DTA_STS = oModel.setDTA_STS(hlpFlags_CRUDOption.CREATE);
                        //Set BP_STS (Active)
                        oModel.setActivate();
                        //Set model from Viewmodel
                        oModel.USR_ID = poViewModel.USR_ID;
                        oModel.USR_NM1 = poViewModel.USR_NM1;
                        //Encrypt password
                        oModel.USR_PSWD = hlpObf.randomEncrypt(poViewModel.USR_PSWD);
                    #endregion

                    #region Employee Area
                        Employee oModelEmployee = new Employee();
                        //Set Field Header
                        oModelEmployee.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
                        //Set DTA_STS
                        oModelEmployee.DTA_STS = oModel.setDTA_STS(hlpFlags_CRUDOption.CREATE);
                        //Set RES_TYPE
                        oModelEmployee.setRES_TYPE();
                        //Set BP_STS
                        oModelEmployee.setActivate();
                        //Set model from Viewmodel
                        oModelEmployee.RES_NM1 = poViewModel.USR_NM1;
                        oModelEmployee.DEPT_RUID = poViewModel.DEPT_RUID;
                        //Set Image file name
                        if (poFileimage != null)
                        {
                            oModelEmployee.IMG_SRC = Utility_FileUploadDownload.setImage(oModelEmployee.RUID);
                            Utility_FileUploadDownload.saveImage_Employee(poFileimage, oModelEmployee.IMG_SRC);
                        } //End if (poFileimage != null)
                    #endregion

                    //Set RES_RUID in User Table
                    oModel.RES_RUID = oModelEmployee.RUID;
                    //Process CRUD
                    db.Users.Add(oModel);
                    db.Employees.Add(oModelEmployee);
                    //Save to Database
                    db.SaveChanges();
                    this.RUID = oModel.RUID;
                } //End using
            } //End try
            catch (Exception e) { vsMsgErr = e.Message; } //End catch
        } //End public void CreateCPAR(User_DetailCPARVM poViewModel, HttpPostedFileBase poFileimage)
Пример #9
0
        } //End public void CreateCPAR(User_DetailCPARVM poViewModel, HttpPostedFileBase poFileimage)
        public void UpdateCPAR(User_DetailCPARVM poViewModel, HttpPostedFileBase poFileimage)
        {
            string vsMsgErr = "";
            try
            {
                using (var db = new DBMAINContext())
                {
                    #region User Area
                        User oModel = db.Users.AsNoTracking().SingleOrDefault(fld => fld.RUID == poViewModel.RUID);
                        //Set Field Header
                        oModel.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
                        //Set DTA_STS
                        oModel.DTA_STS = oModel.setDTA_STS(hlpFlags_CRUDOption.UPDATE);
                        //Set BP_STS (Active)
                        oModel.setActivate();
                        //Set model from Viewmodel
                        oModel.USR_NM1 = poViewModel.USR_NM1;
                        oModel.USR_PSWD = hlpObf.randomEncrypt(poViewModel.USR_PSWD);
                    #endregion

                    #region Employee Area
                        Employee oModelEmployee = db.Employees.AsNoTracking().SingleOrDefault(fld => fld.RUID == oModel.RES_RUID);
                        //Set Field Header
                        oModelEmployee.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
                        //Set DTA_STS
                        oModelEmployee.DTA_STS = oModel.setDTA_STS(hlpFlags_CRUDOption.UPDATE);
                        //Set RES_TYPE
                        oModelEmployee.setRES_TYPE();
                        //Set model from Viewmodel
                        oModelEmployee.RES_NM1 = poViewModel.USR_NM1;
                        oModelEmployee.DEPT_RUID = poViewModel.DEPT_RUID;

                        //Set Image file name
                        if (poFileimage != null)
                        {
                            oModelEmployee.IMG_SRC = Utility_FileUploadDownload.setImage(oModelEmployee.RUID);
                            Utility_FileUploadDownload.saveImage_Employee(poFileimage, oModelEmployee.IMG_SRC);
                        } //End if (poFileimage != null)

                    #endregion

                    //Process CRUD
                    db.Entry(oModel).State = EntityState.Modified;
                    db.Entry(oModelEmployee).State = EntityState.Modified;
                    //Save to Database
                    db.SaveChanges();
                    this.RUID = oModel.RUID;
                } //End using
            } //End try
            catch (Exception e) { vsMsgErr = e.Message; } //End catch
        } //End public void UpdateCPAR(User_DetailCPARVM poViewModel, HttpPostedFileBase poFileimage)
Пример #10
0
        }                                                                                    //End public void Update

        public void DeletePARENT(int?id)
        {
            try
            {
                using (var db = new DBMAINContext())
                {
                    User oModel = db.Users.Find(id);
                    db.Users.Remove(oModel);
                    db.SaveChanges();
                    this.ID = oModel.ID;

                    //Delete Image file
                    Utility_FileUploadDownload.deleteImage_User(oModel.USER_IMG);
                }                                                                            //End using
            }                                                                                //End try
            catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Delete" + e.Message; } //End catch
        }                                                                                    //End public void Delete
Пример #11
0
        }                                                                                    //End public void Update

        public void Delete(int?id)
        {
            try
            {
                using (var db = new DBMAINContext())
                {
                    Student oModel = db.Students.Find(id);
                    db.Students.Remove(oModel);
                    db.SaveChanges();
                    this.ID = oModel.ID;

                    //Delete Image file name
                    Utility_FileUploadDownload.deleteImage_Student(oModel.STUDENT_IMG);
                }                                                                            //End using
            }                                                                                //End try
            catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Delete" + e.Message; } //End catch
        }                                                                                    //End public void Delete
Пример #12
0
        }                                                                                            //End public void Update

        public void Delete(int?id)
        {
            try
            {
                using (var db = new DBMAINContext())
                {
                    Photogallery oModel = db.Photogallerys.Find(id);
                    db.Photogallerys.Remove(oModel);
                    db.SaveChanges();
                    this.ID = oModel.ID;

                    //Delete Image file
                    Utility_FileUploadDownload.deleteImage_Gallery(oModel.PHOTO_IMG);
                }                                                                            //End using
            }                                                                                //End try
            catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Delete" + e.Message; } //End catch
        }                                                                                    //End public void Delete
Пример #13
0
        }                        //End public StudentCRUD()

        public void Create(StudentdetailVM poViewModel, HttpPostedFileBase poFileimage = null)
        {
            try
            {
                using (var db = new DBMAINContext())
                {
                    using (var edupar = new hlpEduparInfo(poViewModel.REG_DT, poViewModel.CLASSLEVEL_ID, poViewModel.CLASSROOM_ID)) {
                        Student oModel = new Student();
                        //Map Form Data
                        oModel.InjectFrom(poViewModel);
                        //Set Field Header
                        oModel.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
                        //Set DTA_STS
                        oModel.DTA_STS = valFLAG.FLAG_DTA_STS_CREATE;
                        //Set main parameter fields

                        oModel.BRANCH_ID     = edupar.DEFBRANCH_ID;
                        oModel.YEAR_ID       = edupar.YEAR_ID;
                        oModel.SEMESTER_ID   = edupar.SEMESTER_ID;
                        oModel.CLASSLEVEL_ID = oDSClassroom.getData(poViewModel.CLASSROOM_ID).CLASSLEVEL_ID;
                        oModel.CLASSTYPE_ID  = oDSClasslevel.getData(oModel.CLASSLEVEL_ID).CLASSTYPE_ID;
                        oModel.CLASSROOM_ID  = poViewModel.CLASSROOM_ID;

                        //Set Image file name
                        if (poFileimage != null)
                        {
                            oModel.STUDENT_IMG = Utility_FileUploadDownload.setImage_Student();
                        }                                                                                                //End if (poFileimage != null)

                        //Process CRUD
                        db.Students.Add(oModel);
                        db.SaveChanges();
                        this.ID = oModel.ID;

                        //Save file
                        if (poFileimage != null)
                        {
                            Utility_FileUploadDownload.saveImage_Student(poFileimage, oModel.STUDENT_IMG);
                        }                                                                                  //End if (poFileimage != null)
                    } //End using (var edupar = new hlpEduparInfo())
                } //End using
            }                                                                                  //End try
            catch (Exception e) { isERR = true; this.ERRMSG = "CRUD - Create: " + e.Message; } //End catch
        }                                                                                      //End public void Create
Пример #14
0
 } //End public void UpdateCPAR(User_DetailCPARVM poViewModel, HttpPostedFileBase poFileimage)
 public void DeleteCPAR(string id)
 {
     string vsMsgErr = "";
     try
     {
         using (var db = new DBMAINContext())
         {
             //User Area
             User oModel = db.Users.Find(id);
             db.Users.Remove(oModel);
             //Employee Area
             Employee oModelEmployee = db.Employees.Find(oModel.RES_RUID);
             db.Employees.Remove(oModelEmployee);
             //Save to Database
             db.SaveChanges();
             //Delete Photo
             Utility_FileUploadDownload.deleteImage_Employee(oModel.RES_RUID);
         } //End using
     } //End try
     catch (Exception e) { vsMsgErr = e.Message; } //End catch
 } //End public void DeleteCPAR(string id)
Пример #15
0
        }                                                  //End public EmployeeCRUD()

        public void Create(Employee_DetailVM poViewModel, HttpPostedFileBase poFileimage)
        {
            string vsMsgErr = "";

            try
            {
                using (var db = new DBMAINContext())
                {
                    #region Employee
                    Employee oModel = new Employee();
                    //Map Form Data
                    Mapper.CreateMap <Employee_DetailVM, Employee>();
                    oModel = Mapper.Map <Employee_DetailVM, Employee>(poViewModel);
                    //Set Field Header
                    oModel.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
                    //Set DTA_STS
                    oModel.DTA_STS = oModel.setDTA_STS(hlpFlags_CRUDOption.CREATE);
                    //Set RES_TYPE
                    oModel.setRES_TYPE();
                    //Set BP_STS
                    oModel.setActivate();

                    //Set Image file name
                    if (poFileimage != null)
                    {
                        oModel.IMG_SRC = Utility_FileUploadDownload.setImage(oModel.RUID);
                        Utility_FileUploadDownload.saveImage_Employee(poFileimage, oModel.IMG_SRC);
                    }     //End if (poFileimage != null)

                    //Process CRUD
                    db.Employees.Add(oModel);
                    db.SaveChanges();
                    #endregion

                    #region Employee_Address
                    Employee_address oModel_addressKTP = new Employee_address();
                    //Set Field Header
                    oModel_addressKTP.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
                    //Set DTA_STS
                    oModel_addressKTP.DTA_STS = oModel.setDTA_STS(hlpFlags_CRUDOption.CREATE);
                    //Set Address KTP
                    oModel_addressKTP.DTA_STS = oModel.DTA_STS;
                    //oModel_addressKTP.BP_STS = poViewModel.
                    oModel_addressKTP.RES_RUID   = oModel.RUID;
                    oModel_addressKTP.CNTRY_RUID = poViewModel.CNTRY_RUID_IC;
                    oModel_addressKTP.CITY_RUID  = poViewModel.CITY_RUID_IC;
                    oModel_addressKTP.ZIP        = poViewModel.ZIP_IC;
                    oModel_addressKTP.ADDR_TYP   = oModel.setAddressIC();
                    oModel_addressKTP.ADDR1      = poViewModel.ADDR1_IC;
                    oModel_addressKTP.ADDR2      = poViewModel.ADDR2_IC;
                    oModel_addressKTP.ADDR3      = poViewModel.ADDR3_IC;
                    //oModel_addressKTP.ADDR4 = poViewModel.
                    //oModel_addressKTP.ADDR5 = poViewModel.

                    //Set Address DOMISILI
                    Employee_address oModel_addressDOM = new Employee_address();
                    //Set Field Header
                    oModel_addressDOM.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
                    //Set DTA_STS
                    oModel_addressDOM.DTA_STS = oModel.setDTA_STS(hlpFlags_CRUDOption.CREATE);
                    oModel_addressDOM.DTA_STS = oModel.DTA_STS;
                    //oModel_addressDOM.BP_STS = poViewModel.
                    oModel_addressDOM.RES_RUID   = oModel.RUID;
                    oModel_addressDOM.CNTRY_RUID = poViewModel.CNTRY_RUID_DMCL;
                    oModel_addressDOM.CITY_RUID  = poViewModel.CITY_RUID_DMCL;
                    oModel_addressDOM.ZIP        = poViewModel.ZIP_DMCL;
                    oModel_addressDOM.ADDR_TYP   = oModel.setAddressDMCL();
                    oModel_addressDOM.ADDR1      = poViewModel.ADDR1_DMCL;
                    oModel_addressDOM.ADDR2      = poViewModel.ADDR2_DMCL;
                    oModel_addressDOM.ADDR3      = poViewModel.ADDR3_DMCL;
                    //oModel_addressDOM.ADDR4 = poViewModel.
                    //oModel_addressDOM.ADDR5 = poViewModel.

                    //Process CRUD
                    db.Employee_addresss.Add(oModel_addressKTP);
                    db.Employee_addresss.Add(oModel_addressDOM);
                    db.SaveChanges();
                    #endregion
                }                                         //End using
            }                                             //End try
            catch (Exception e) { vsMsgErr = e.Message; } //End catch
        }                                                 //End public void Create
Пример #16
0
        } //End public static void setValidCredential()

        public static void setValidCredential(string psUsername = null, UsercredentialVM poViewmodel = null, int?pnMdleId = null)
        {
            hlpConfig.SessionInfo.setAppUsername(psUsername);
            hlpConfig.SessionInfo.setAppUserdisplayname(poViewmodel.DISPLAY_NAME);
            hlpConfig.SessionInfo.setAppUserId(poViewmodel.ID);
            hlpConfig.SessionInfo.setAppRoleId(poViewmodel.ROLE_ID);
            hlpConfig.SessionInfo.setAppResId(poViewmodel.RES_ID);
            hlpConfig.SessionInfo.setAppMdleId(pnMdleId);
            hlpConfig.SessionInfo.setAppUserIMG(poViewmodel.USER_IMG);


            string sTempinfo1 = "";
            string sTempinfo2 = "";
            string sTempinfo3 = "";
            string sTempinfo4 = "";
            string sIMG       = Utility_FileUploadDownload.getImage_UserNA();

            if (poViewmodel.ROLE_ID == APPBASE.Svcbiz.valFLAG.FLAG_ROLE_P)
            {
                StudentDS oDSStudent = new StudentDS();
                var       oData      = oDSStudent.getData_shortinfo(poViewmodel.RES_ID);
                if (oData != null)
                {
                    if (oData.STUDENT_IMG != null)
                    {
                        sIMG = Utility_FileUploadDownload.getImage_Student(oData.STUDENT_IMG);
                    }
                    sTempinfo1 = "";
                    if (oData.BRANCH_DESC != null)
                    {
                        sTempinfo1 = oData.BRANCH_DESC;
                    }
                    sTempinfo2 = "";
                    if (oData.CLASSTYPE_NAME != null)
                    {
                        sTempinfo2 = oData.CLASSTYPE_NAME;
                    }
                    sTempinfo3 = "";
                    if (oData.CLASSROOM_NAME != null)
                    {
                        sTempinfo3 = oData.CLASSROOM_NAME;
                    }
                    sTempinfo4 = "";
                    if (oData.CLASSTYPE_ID != null)
                    {
                        sTempinfo4 = oData.CLASSTYPE_ID.ToString();
                    }
                } //End if (oData != null)
            }     //End if (poViewmodel.ROLE_ID == APPBASE.Svcbiz.valFLAG.FLAG_ROLE_P)
            else
            {
                EmployeeDS oDSEmployee = new EmployeeDS();
                var        oData       = oDSEmployee.getData_shortinfo(poViewmodel.RES_ID);
                if (oData != null)
                {
                    if (oData.EMPLOYEE_IMG != null)
                    {
                        sIMG = Utility_FileUploadDownload.getImage_Employee(oData.EMPLOYEE_IMG);
                    }
                    sTempinfo1 = "";
                    if (oData.BRANCH_DESC != null)
                    {
                        sTempinfo1 = oData.BRANCH_DESC;
                    }
                    sTempinfo2 = "";
                    if (oData.SENTRA_NAME != null)
                    {
                        sTempinfo2 = oData.SENTRA_NAME;
                    }
                    sTempinfo3 = "";
                    if (oData.JOBTITLE_DESC != null)
                    {
                        sTempinfo3 = oData.JOBTITLE_DESC;
                    }
                } //End if (oData != null)
            }     //End if (poViewmodel.ROLE_ID == APPBASE.Svcbiz.valFLAG.FLAG_ROLE_P)
            hlpConfig.SessionInfo.setAppResIMG(sIMG);
            hlpConfig.SessionInfo.setAppResinfo1(sTempinfo1);
            hlpConfig.SessionInfo.setAppResinfo2(sTempinfo2);
            hlpConfig.SessionInfo.setAppResinfo3(sTempinfo3);
            hlpConfig.SessionInfo.setAppResinfo4(sTempinfo4);
        } //End public static void setValidCredential()
Пример #17
0
        }                                                 //End public void Create

        public void Update(Employee_DetailVM poViewModel, HttpPostedFileBase poFileimage)
        {
            string vsMsgErr = "";

            try
            {
                using (var db = new DBMAINContext())
                {
                    #region Employee
                    Employee oModel = db.Employees.AsNoTracking().SingleOrDefault(fld => fld.RUID == poViewModel.RUID);
                    //Map Form Data
                    Mapper.CreateMap <Employee_DetailVM, Employee>();
                    oModel = Mapper.Map <Employee_DetailVM, Employee>(poViewModel);
                    //Set Field Header
                    oModel.setFIELD_HEADER(hlpFlags_CRUDOption.UPDATE);
                    //Set DTA_STS
                    oModel.DTA_STS = oModel.setDTA_STS(hlpFlags_CRUDOption.UPDATE);
                    //Set RES_TYPE
                    oModel.setRES_TYPE();

                    //Set Image file name
                    if (poFileimage != null)
                    {
                        oModel.IMG_SRC = Utility_FileUploadDownload.setImage(oModel.RUID);
                        Utility_FileUploadDownload.saveImage_Employee(poFileimage, oModel.IMG_SRC);
                    }     //End if (poFileimage != null)

                    //Process CRUD
                    db.Entry(oModel).State = EntityState.Modified;
                    db.SaveChanges();
                    #endregion

                    #region Employee_address
                    //Delete old address
                    var oModel_address = db.Employee_addresss.Where(fld => fld.RES_RUID == poViewModel.RUID);
                    foreach (Employee_address item in oModel_address)
                    {
                        db.Employee_addresss.Remove(item);
                    }                                                                                            //End foreach

                    //Set Address DOMISILI
                    Employee_address oModel_addressKTP = new Employee_address();
                    //Set Field Header
                    oModel_addressKTP.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
                    //Set DTA_STS
                    oModel_addressKTP.DTA_STS = oModel.setDTA_STS(hlpFlags_CRUDOption.CREATE);
                    //Set Address KTP
                    oModel_addressKTP.DTA_STS = oModel.DTA_STS;
                    //oModel_addressKTP.BP_STS = poViewModel.
                    oModel_addressKTP.RES_RUID   = oModel.RUID;
                    oModel_addressKTP.CNTRY_RUID = poViewModel.CNTRY_RUID_IC;
                    oModel_addressKTP.CITY_RUID  = poViewModel.CITY_RUID_IC;
                    oModel_addressKTP.ZIP        = poViewModel.ZIP_IC;
                    oModel_addressKTP.ADDR_TYP   = oModel.setAddressIC();
                    oModel_addressKTP.ADDR1      = poViewModel.ADDR1_IC;
                    oModel_addressKTP.ADDR2      = poViewModel.ADDR2_IC;
                    oModel_addressKTP.ADDR3      = poViewModel.ADDR3_IC;
                    //oModel_addressKTP.ADDR4 = poViewModel.
                    //oModel_addressKTP.ADDR5 = poViewModel.

                    //Set Address DOMISILI
                    Employee_address oModel_addressDOM = new Employee_address();
                    //Set Field Header
                    oModel_addressDOM.setFIELD_HEADER(hlpFlags_CRUDOption.CREATE);
                    //Set DTA_STS
                    oModel_addressDOM.DTA_STS = oModel.setDTA_STS(hlpFlags_CRUDOption.CREATE);
                    oModel_addressDOM.DTA_STS = oModel.DTA_STS;
                    //oModel_addressDOM.BP_STS = poViewModel.
                    oModel_addressDOM.RES_RUID   = oModel.RUID;
                    oModel_addressDOM.CNTRY_RUID = poViewModel.CNTRY_RUID_DMCL;
                    oModel_addressDOM.CITY_RUID  = poViewModel.CITY_RUID_DMCL;
                    oModel_addressDOM.ZIP        = poViewModel.ZIP_DMCL;
                    oModel_addressDOM.ADDR_TYP   = oModel.setAddressDMCL();
                    oModel_addressDOM.ADDR1      = poViewModel.ADDR1_DMCL;
                    oModel_addressDOM.ADDR2      = poViewModel.ADDR2_DMCL;
                    oModel_addressDOM.ADDR3      = poViewModel.ADDR3_DMCL;
                    //oModel_addressDOM.ADDR4 = poViewModel.
                    //oModel_addressDOM.ADDR5 = poViewModel.

                    //Process CRUD
                    db.Employee_addresss.Add(oModel_addressKTP);
                    db.Employee_addresss.Add(oModel_addressDOM);
                    db.SaveChanges();
                    #endregion
                }                                         //End using
            }                                             //End try
            catch (Exception e) { vsMsgErr = e.Message; } //End catch
        }                                                 //End public void Update