示例#1
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
示例#2
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