コード例 #1
0
ファイル: CompanyDAL.cs プロジェクト: ewin66/RAPH
        public SavingResult SaveLogoFileName(int CompanyID, string FileName)
        {
            SavingResult res = new SavingResult();

            using (dbVisionEntities db = new dbVisionEntities())
            {
                var SaveModel = db.tblCompanies.Find(CompanyID);
                if (SaveModel == null)
                {
                    res.ExecutionResult = eExecutionResult.ValidationError;
                    res.ValidationError = "Selected company not found. It may be deleted over network. Please check again or contact your administrator.";
                    return(res);
                }

                SaveModel.CompanyLogoFileName = FileName;
                db.tblCompanies.Attach(SaveModel);
                db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;

                //--
                try
                {
                    db.SaveChanges();
                    res.PrimeKeyValue   = SaveModel.CompanyID;
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                }
                return(res);
            }
        }
コード例 #2
0
        public SavingResult DeleteRecord(int ID)
        {
            SavingResult res = new SavingResult();

            using (dbUltraCoralEntities db = new dbUltraCoralEntities())
            {
                var RecordToDelete = db.tblProducts.Find(ID);

                if (RecordToDelete == null)
                {
                    res.ExecutionResult = eExecutionResult.ValidationError;
                    res.ValidationError = "Selected record is already deleted or changed over network. Record not found.";
                    return(res);
                }

                db.tblProducts.Remove(RecordToDelete);
                //--
                try
                {
                    db.SaveChanges();
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    ex = Common.Functions.FindFinalError(ex);

                    res.ExecutionResult = eExecutionResult.ErrorWhileExecuting;
                    res.Exception       = ex;
                }
            }
            return(res);
        }
コード例 #3
0
ファイル: UserDAL.cs プロジェクト: ewin66/RAPH
        public SavingResult ChangePassworD(int UserID, string NewPassword)
        {
            SavingResult res = new SavingResult();

            using (dbVisionEntities db = new dbVisionEntities())
            {
                var user = db.tblUsers.Find(UserID);
                if (user == null)
                {
                    return(null);
                }

                user.Password = NewPassword;
                db.tblUsers.Attach(user);
                db.Entry(user).State = System.Data.Entity.EntityState.Modified;

                //--
                try
                {
                    db.SaveChanges();
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                }
            }
            return(res);
        }
コード例 #4
0
        public SavingResult SaveEmployeeProfileImageFileName(int EmployeeID, string ImageFileName)
        {
            SavingResult res = new SavingResult();

            using (dbVisionEntities db = new dbVisionEntities())
            {
                var SaveModel = db.tblEmployees.Find(EmployeeID);
                if (SaveModel == null)
                {
                    res.ExecutionResult = eExecutionResult.ValidationError;
                    res.ValidationError = "Selected record is not found.";
                    return(res);
                }

                SaveModel.EmployeeImageFileName = ImageFileName;

                try
                {
                    db.SaveChanges();
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                }
            }
            return(res);
        }
コード例 #5
0
        public SavingResult SaveMinimumWageCategoryRate(List <MinimumWageCategoryRateChangeListModel> Rates, DateTime?WEFDate)
        {
            DateTime?    PreviousDate = null;
            SavingResult res          = new SavingResult();

            using (dbVisionEntities db = new dbVisionEntities())
            {
                if (WEFDate == null)
                {
                    db.tblMinimumWageRates.RemoveRange(
                        from r in db.tblMinimumWageRates
                        join mc in db.tblMinimumWageCategories on r.MinimumWageCategoryID equals mc.MinimumWageCategoryID
                        where mc.CompanyID == CommonProperties.LoginInfo.LoggedInCompany.CompanyID
                        select r);
                }
                else
                {
                    PreviousDate = WEFDate.Value.AddDays(-1);

                    foreach (var rate in Rates)
                    {
                        var PreviousRates = db.tblMinimumWageRates.Where(r =>
                                                                         r.MinimumWageCategoryID == rate.MinimumWageCategoryID &&
                                                                         (r.WEDateTo == null || r.WEDateTo >= WEFDate));

                        foreach (var prate in PreviousRates)
                        {
                            prate.WEDateTo = PreviousDate;
                            db.tblMinimumWageRates.Attach(prate);
                            db.Entry(prate).State = System.Data.Entity.EntityState.Modified;
                        }

                        db.tblMinimumWageRates.RemoveRange(db.tblMinimumWageRates.Where(r =>
                                                                                        r.MinimumWageCategoryID == rate.MinimumWageCategoryID &&
                                                                                        r.WEDateFrom >= WEFDate));
                    }
                }
                db.tblMinimumWageRates.AddRange(Rates.Where(r => r.RuralRate != 0 || r.UrbanRate != 0).Select(r =>
                                                                                                              new tblMinimumWageRate()
                {
                    MinimumWageCategoryID        = r.MinimumWageCategoryID,
                    MinimumWageCategoryRuralRate = r.RuralRate,
                    MinimumWageCategoryUrbanRate = r.UrbanRate,
                    WEDateFrom = WEFDate,
                    rcdt       = DateTime.Now,
                    rcuid      = CommonProperties.LoginInfo.LoggedinUser.UserID,
                }));

                try
                {
                    db.SaveChanges();
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                }
            }
            return(res);
        }
コード例 #6
0
        public SavingResult SaveNewRecord(tblTAApproval SaveModel)
        {
            SavingResult res = new SavingResult();

            //-- Perform Validation
            //res.ExecutionResult = eExecutionResult.ValidationError;
            //res.ValidationError = "Validation error message";
            //return res;

            //--
            using (dbVisionEntities db = new dbVisionEntities())
            {
                SaveNewRecord(SaveModel, db);
                //--
                try
                {
                    db.SaveChanges();
                    res.PrimeKeyValue   = SaveModel.TAApprovalID;
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                }
            }
            return(res);
        }
コード例 #7
0
        private void btnSaveFormat_Click(object sender, EventArgs e)
        {
            if (lookupFormat.EditValue == null)
            {
                MessageBox.Show("Please select format or type a new format name", "Format Saving", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                lookupFormat.Focus();
                return;
            }

            string LayoutXML = null;

            using (MemoryStream stream = new MemoryStream())
            {
                advBandedGridView1.SaveLayoutToStream(stream, DevExpress.Utils.OptionsLayoutBase.FullLayout);
                stream.Seek(0, SeekOrigin.Begin);
                using (StreamReader reader = new StreamReader(stream))
                {
                    LayoutXML = reader.ReadToEnd();
                }
            }

            SavingResult    res   = ReportDALObj.SaveFormat((int)lookupFormat.EditValue, lookupFormat.Text, LayoutXML);
            SavingParemeter paras = new SavingParemeter()
            {
                SavingResult = res
            };

            AfterSaving(paras);

            if (res.ExecutionResult == eExecutionResult.CommitedSucessfuly && ((int?)lookupFormat.EditValue ?? 0) == -1)
            {
                LoadFormatLookup();
                AssignFormatLookup();
            }
        }
コード例 #8
0
        public SavingResult SaveNewRecord(tblPayrollMonth SaveModel)
        {
            SavingResult res = new SavingResult();

            using (dbVisionEntities db = new dbVisionEntities())
            {
                SaveModel.rcuid = (Model.CommonProperties.LoginInfo.LoggedinUser != null ? (int?)Model.CommonProperties.LoginInfo.LoggedinUser.UserID : null);
                SaveModel.rcdt  = DateTime.Now;
                db.tblPayrollMonths.Add(SaveModel);
                db.Entry(SaveModel).State = System.Data.Entity.EntityState.Added;

                //--
                try
                {
                    db.SaveChanges();
                    res.PrimeKeyValue   = SaveModel.PayrollMonthID;
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                    return(res);
                }
            }
            return(res);
        }
コード例 #9
0
ファイル: CommonFunctions.cs プロジェクト: ewin66/RAPH
        public static void GetFinalError(SavingResult res, Exception ex)
        {
            res.ExecutionResult = eExecutionResult.ErrorWhileExecuting;
            res.Exception       = ex;
            while (res.Exception != null && res.Exception.Message == "An error occurred while updating the entries. See the inner exception for details.")
            {
                res.Exception = res.Exception.InnerException;
            }

            if (ex.GetType() == typeof(System.Data.Entity.Validation.DbEntityValidationException))
            {
                res.ValidationError = "dbEntity Validation Errors : \r\n\r\n";

                System.Data.Entity.Validation.DbEntityValidationException ValidationException = (System.Data.Entity.Validation.DbEntityValidationException)ex;

                foreach (System.Data.Entity.Validation.DbEntityValidationResult ValidRes in ValidationException.EntityValidationErrors)
                {
                    foreach (System.Data.Entity.Validation.DbValidationError ValidError in ValidRes.ValidationErrors)
                    {
                        res.ValidationError += ValidError.PropertyName + " = " + ValidError.ErrorMessage + "\r\n";
                    }
                    res.ValidationError += "\r\n";
                }

                res.Exception = new Exception(res.ValidationError);
            }
        }
コード例 #10
0
        public SavingResult UpdateTACode(int EmployeeID, int TACode)
        {
            SavingResult res = new SavingResult();

            using (dbVisionEntities db = new dbVisionEntities())
            {
                var SaveModel = db.tblEmployees.FirstOrDefault(r => r.EmployeeID == EmployeeID);
                if (SaveModel == null)
                {
                    res.ExecutionResult = eExecutionResult.ValidationError;
                    res.ValidationError = "Employee not found.";
                    return(res);
                }

                SaveModel.TACode = TACode;
                db.tblEmployees.Attach(SaveModel);
                db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;

                try
                {
                    db.SaveChanges();
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                }
            }
            //--
            return(res);
        }
コード例 #11
0
        public SavingResult SaveDataReceiverErrorLog(string Message, string Error)
        {
            SavingResult res = new SavingResult();

            using (dbVisionEntities db = new dbVisionEntities())
            {
                db.tblDataReceiverErrorLogs.Add(new tblDataReceiverErrorLog()
                {
                    Message = Message,
                    Error   = Error,
                    rcdt    = DateTime.Now
                });

                try
                {
                    db.SaveChanges();
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                }
            }
            return(res);
        }
コード例 #12
0
ファイル: SettingDAL.cs プロジェクト: ewin66/RAPH
        public SavingResult SaveSettingL0(string SettingName, object SettingValue)
        {
            SavingResult res = new SavingResult();

            //--
            using (dbVisionEntities db = new dbVisionEntities())
            {
                tblSettingL0 SaveModel = SaveSettingL0(SettingName, SettingValue, db, res);
                if (res.ExecutionResult == eExecutionResult.ValidationError)
                {
                    return(res);
                }
                //--
                try
                {
                    db.SaveChanges();
                    res.PrimeKeyValue   = SaveModel.SettingL0ID;
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                }
            }
            return(res);
        }
コード例 #13
0
        public SavingResult SaveNewRecord(tblEmployeeDepartment SaveModel)
        {
            SavingResult res = new SavingResult();

            //-- Perform Validation
            //res.ExecutionResult = eExecutionResult.ValidationError;
            //res.ValidationError = "Validation error message";
            //return res;

            //--
            using (dbVisionEntities db = new dbVisionEntities())
            {
                //tblEmployeeDepartment SaveModel;

                if (String.IsNullOrWhiteSpace(SaveModel.EmployeeDepartmentName))
                {
                    res.ValidationError = "Can not accept blank value. Please enter Employee Department Name.";
                    res.ExecutionResult = eExecutionResult.ValidationError;
                    return(res);
                }
                else if (IsDuplicateRecord(SaveModel.EmployeeDepartmentName, SaveModel.EmployeeDepartmentID, db))
                {
                    res.ValidationError = "Can not accept duplicate value. The Employee Department Name is already exists.";
                    res.ExecutionResult = eExecutionResult.ValidationError;
                    return(res);
                }

                if (SaveModel.EmployeeDepartmentID == 0) // New Entry
                {
                    SaveModel.rstate    = (byte)eRecordState.Active;
                    SaveModel.CompanyID = CommonProperties.LoginInfo.LoggedInCompany.CompanyID;
                    SaveModel.rcuid     = CommonProperties.LoginInfo.LoggedinUser.UserID;
                    SaveModel.rcdt      = DateTime.Now;
                    db.tblEmployeeDepartments.Add(SaveModel);
                }
                else
                {
                    SaveModel.reuid = CommonProperties.LoginInfo.LoggedinUser.UserID;
                    SaveModel.redt  = DateTime.Now;
                    db.tblEmployeeDepartments.Attach(SaveModel);
                    db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;
                }

                //--
                //--

                try
                {
                    db.SaveChanges();
                    res.PrimeKeyValue   = SaveModel.EmployeeDepartmentID;
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                }
            }
            return(res);
        }
コード例 #14
0
ファイル: LeaveEncashmentDAL.cs プロジェクト: ewin66/RAPH
        public SavingResult SaveNewRecord(tblLeaveEncashment SaveModel)
        {
            SavingResult res = new SavingResult();

            //-- Perform Validation
            //res.ExecutionResult = eExecutionResult.ValidationError;
            //res.ValidationError = "Validation error message";
            //return res;

            //--
            using (dbVisionEntities db = new dbVisionEntities())
            {
                //tblLeaveEncashment SaveModel;
                if (SaveModel.LeaveEncashmentNo == 0)
                {
                    res.ValidationError = "Please enter Leave Application No..";
                    res.ExecutionResult = eExecutionResult.ValidationError;
                    return(res);
                }
                else if (IsDuplicateRecord(SaveModel.LeaveEncashmentNoPrefixID, SaveModel.LeaveEncashmentNo, SaveModel.LeaveEncashmentID, db))
                {
                    res.ValidationError = "Can not accept duplicate value. The Leave Application No. is already exists.";
                    res.ExecutionResult = eExecutionResult.ValidationError;
                    return(res);
                }

                if (SaveModel.LeaveEncashmentID == 0) // New Entry
                {
                    SaveModel.rcuid       = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
                    SaveModel.rcdt        = DateTime.Now;
                    SaveModel.CompanyID   = Model.CommonProperties.LoginInfo.LoggedInCompany.CompanyID;
                    SaveModel.FinPeriodID = Model.CommonProperties.LoginInfo.LoggedInFinPeriod.FinPeriodID;
                    db.tblLeaveEncashments.Add(SaveModel);
                }
                else
                {
                    SaveModel.reuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
                    SaveModel.redt  = DateTime.Now;
                    db.tblLeaveEncashments.Attach(SaveModel);
                    db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;
                }

                //--
                try
                {
                    db.SaveChanges();
                    res.PrimeKeyValue   = SaveModel.LeaveEncashmentID;
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                }
            }
            return(res);
        }
コード例 #15
0
        public SavingResult SaveNewRecord(tblCity SaveModel)
        {
            SavingResult res = new SavingResult();

            //-- Perform Validation
            //res.ExecutionResult = eExecutionResult.ValidationError;
            //res.ValidationError = "Validation error message";
            //return res;

            //--
            using (dbVisionEntities db = new dbVisionEntities())
            {
                //tblCity SaveModel;
                if (SaveModel.CityName == "")
                {
                    res.ValidationError = "Can not accept blank value. Please enter City Name.";
                    res.ExecutionResult = eExecutionResult.ValidationError;
                    return(res);
                }
                else if (IsDuplicateRecord(SaveModel.CityName, SaveModel.CityID, SaveModel.StateID, db))
                {
                    res.ValidationError = "Can not accept duplicate value. The City Name is already exists.";
                    res.ExecutionResult = eExecutionResult.ValidationError;
                    return(res);
                }

                SaveModel.CountryID = db.tblStates.FirstOrDefault(r => r.StateID == SaveModel.StateID).CountryID;
                if (SaveModel.CityID == 0) // New Entry
                {
                    SaveModel.rcuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
                    SaveModel.rcdt  = DateTime.Now;
                    db.tblCities.Add(SaveModel);
                }
                else
                {
                    SaveModel.reuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
                    SaveModel.redt  = DateTime.Now;
                    db.tblCities.Attach(SaveModel);
                    db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;
                }

                //--
                try
                {
                    db.SaveChanges();
                    res.PrimeKeyValue   = SaveModel.CityID;
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                }
            }
            return(res);
        }
コード例 #16
0
        public SavingResult SaveNewRecord(DateTime DateFrom, DateTime DateTo, List <EmployeeRestDayViewModel> dsEmployee)
        {
            SavingResult res = new SavingResult();

            using (dbVisionEntities db = new dbVisionEntities())
            {
                db.tblEmployeeRestDays.RemoveRange(db.tblEmployeeRestDays.Where(r =>
                                                                                r.CompanyID == Model.CommonProperties.LoginInfo.LoggedInCompany.CompanyID &&
                                                                                r.FinPeriodID == Model.CommonProperties.LoginInfo.LoggedInFinPeriod.FinPeriodID &&
                                                                                r.RestDate >= DateFrom && r.RestDate < DateTo));

                foreach (var Employee in dsEmployee)
                {
                    for (int ri = 0; ri < Employee.RestDayDetailDataSource.Count(); ri++)
                    {
                        if (Employee.RestDayDetailDataSource[ri].RestDay)
                        {
                            DateTime date = DateFrom;//.AddDays(ri);
                            while (date.DayOfWeek != Employee.RestDayDetailDataSource[ri].Day)
                            {
                                date = date.AddDays(1);
                            }

                            do
                            {
                                tblEmployeeRestDay SaveModel = new tblEmployeeRestDay()
                                {
                                    EmployeeID = Employee.EmployeeID,
                                    RestDate   = date,

                                    CompanyID   = CommonProperties.LoginInfo.LoggedInCompany.CompanyID,
                                    FinPeriodID = CommonProperties.LoginInfo.LoggedInFinPeriod.FinPeriodID,
                                    rcdt        = DateTime.Now,
                                    rcuid       = CommonProperties.LoginInfo.LoggedinUser.UserID,
                                };
                                db.tblEmployeeRestDays.Add(SaveModel);

                                date = date.AddDays(7);
                            } while (date <= DateTo);
                        }
                    }
                }

                try
                {
                    db.SaveChanges();
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                }
            }
            return(res);
        }
コード例 #17
0
ファイル: UserDAL.cs プロジェクト: ewin66/RAPH
        public SavingResult SaveNewRecord(tblUser SaveModel)
        {
            SavingResult res = new SavingResult();

            //--
            using (dbVisionEntities db = new dbVisionEntities())
            {
                if (SaveModel.UserName == "")
                {
                    res.ValidationError = "Can not accept blank value. The User Name is required.";
                    res.ExecutionResult = eExecutionResult.ValidationError;
                    return(res);
                }
                else if (IsDuplicateRecord(SaveModel.UserName, SaveModel.UserID, db))
                {
                    res.ValidationError = "Can not accept duplicate value. The user Name is already exists.";
                    res.ExecutionResult = eExecutionResult.ValidationError;
                    return(res);
                }
                else if (SaveModel.SuperAdmin)
                {
                    res.ValidationError = "Can not accept add/edit a super user.";
                    res.ExecutionResult = eExecutionResult.ValidationError;
                    return(res);
                }

                if (SaveModel.UserID == 0) // New Entry
                {
                    SaveModel.rcuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
                    SaveModel.rcdt  = DateTime.Now;
                    db.tblUsers.Add(SaveModel);
                }
                else
                {
                    SaveModel.reuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
                    SaveModel.redt  = DateTime.Now;
                    db.tblUsers.Attach(SaveModel);
                    db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;
                }

                //--
                try
                {
                    db.SaveChanges();
                    res.PrimeKeyValue   = SaveModel.UserID;
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                }
            }
            return(res);
        }
コード例 #18
0
        public SavingResult UpdateRateUplift(int ProductID, decimal RateUplift)
        {
            SavingResult res = new SavingResult();

            using (dbUltraCoralEntities db = new dbUltraCoralEntities())
            {
                tblProduct SaveModel = db.tblProducts.Find(ProductID);
                if (SaveModel == null)
                {
                    res.ExecutionResult = eExecutionResult.ValidationError;
                    res.ValidationError = "Product not found";
                    return(res);
                }

                SaveModel = db.tblProducts.FirstOrDefault(r => r.ProductID == ProductID);
                if (SaveModel == null)
                {
                    res.ExecutionResult = eExecutionResult.ValidationError;
                    res.ValidationError = "Selected user has been deleted over network. Can not find product details. Please retry.";
                    return(res);
                }

                if (SaveModel.RateUpliftPerc == RateUplift) // if quantity has not changed then don't update quantity.
                {
                    return(new SavingResult()
                    {
                        ExecutionResult = eExecutionResult.NotExecutedYet
                    });
                }

                SaveModel.RateUpliftPerc = RateUplift;
                SaveModel.redt           = DateTime.Now;
                //SaveModel.reuid = Common.Props.LoginUser.UserID;

                db.tblProducts.Attach(SaveModel);
                db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;

                //--
                try
                {
                    db.SaveChanges();
                    res.PrimeKeyValue   = SaveModel.ProductID;
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    ex = Common.Functions.FindFinalError(ex);

                    res.ExecutionResult = eExecutionResult.ErrorWhileExecuting;
                    res.Exception       = ex;
                }
            }
            return(res);
        }
コード例 #19
0
        public SavingResult ReInstate(int EmployeeID, string Reason, EmployeeServiceDetailViewModel ServiceDetail)
        {
            SavingResult res = new SavingResult();

            using (dbVisionEntities db = new dbVisionEntities())
            {
                var SaveModel = db.tblEmployees.Find(EmployeeID);
                if (SaveModel == null)
                {
                    res.ValidationError = "Selected employee not found.";
                    res.ExecutionResult = eExecutionResult.ValidationError;
                    return(res);
                }

                tblEmployeeServiceDetail EmployeeServiceDetail = new tblEmployeeServiceDetail()
                {
                    tblEmployee             = SaveModel,
                    EmploymentEffectiveDate = ServiceDetail.EmploymentEffectiveDate,
                    ContractExpiryDate      = ServiceDetail.ContractExpiryDate,
                    EmploymentType          = ServiceDetail.EmploymentType,

                    EmployeeDesignationID = ServiceDetail.EmployeeDesignationID,
                    EmployeeDepartmentID  = ServiceDetail.EmployeeDepartmentID,
                    EmployeeWIBAClassID   = ServiceDetail.EmployeeWIBAClassID,
                    LocationID            = ServiceDetail.LocationID,
                    MinimumWageCategoryID = ServiceDetail.MinimumWageCategoryID,

                    DailyRate        = ServiceDetail.DailyRate,
                    BasicSalary      = ServiceDetail.BasicSalary,
                    HousingAllowance = ServiceDetail.HousingAllowance,
                    WeekendAllowance = ServiceDetail.WeekendAllowance,

                    EmployeeShiftType = ServiceDetail.EmployeeShiftTypeID,
                    EmployeeShiftID   = ServiceDetail.EmployeeShiftID,

                    ReinstatementReason = Reason,
                };

                db.tblEmployeeServiceDetails.Add(EmployeeServiceDetail);

                SaveModel.tblEmployeeServiceDetail = EmployeeServiceDetail;
                try
                {
                    db.SaveChanges();
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                }
            }
            return(res);
        }
コード例 #20
0
        public SavingResult Save(int ShiftID, DateTime?WEFDateFrom, int[] SelectedEmployeeIDs)
        {
            SavingResult res = new SavingResult();

            using (dbVisionEntities db = new dbVisionEntities())
            {
                if (SelectedEmployeeIDs.Count() == 0)
                {
                    res.ExecutionResult = eExecutionResult.ErrorWhileExecuting;
                    res.ValidationError = "No employee was selected.";
                    return(res);
                }

                if (WEFDateFrom != null)
                {
                    db.tblEmployeeShiftAllocations.RemoveRange(db.tblEmployeeShiftAllocations.Where(r => SelectedEmployeeIDs.Contains(r.EmployeeID) &&
                                                                                                    r.WEDateFrom >= WEFDateFrom.Value && r.CompanyID == CommonProperties.LoginInfo.LoggedInCompany.CompanyID));
                }
                else
                {
                    db.tblEmployeeShiftAllocations.RemoveRange(db.tblEmployeeShiftAllocations.Where(r => SelectedEmployeeIDs.Contains(r.EmployeeID) &&
                                                                                                    r.CompanyID == CommonProperties.LoginInfo.LoggedInCompany.CompanyID));
                }


                db.tblEmployeeShiftAllocations.AddRange(
                    from e in SelectedEmployeeIDs
                    select new tblEmployeeShiftAllocation()
                {
                    EmployeeID      = e,
                    EmployeeShiftID = ShiftID,
                    WEDateFrom      = WEFDateFrom,
                    CompanyID       = CommonProperties.LoginInfo.LoggedInCompany.CompanyID,
                    FinPeriodID     = CommonProperties.LoginInfo.LoggedInFinPeriod.FinPeriodID,
                    rcdt            = DateTime.Now,
                    rcuid           = CommonProperties.LoginInfo.LoggedinUser.UserID,
                });

                try
                {
                    db.SaveChanges();
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                }
            }
            return(res);
        }
コード例 #21
0
ファイル: frmTaxSlab.cs プロジェクト: ewin66/RAPH
        private void gvPAYERelief_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
        {
            if (e.Row == null)
            {
                return;
            }
            SavingResult         res = null;
            PAYEReliefeViewModel Row = (PAYEReliefeViewModel)e.Row;

            if (dePAYEReliefWED.EditValue == null)
            {
                res = new SavingResult();
                res.ExecutionResult = eExecutionResult.ValidationError;
                res.ValidationError = "Please enter Effective date.";
            }
            else
            {
                res = PAYEReliefDALObj.SaveNewRecord(Row, (DateTime)dePAYEReliefWED.EditValue);
            }

            Row.SavingError = null;
            if (res.ExecutionResult == eExecutionResult.CommitedSucessfuly)
            {
                var newRow = PAYEReliefDALObj.GetViewModelByID((int)res.PrimeKeyValue);
                if (newRow != null)
                {
                    int newRowIndex = PAYEReliefeViewModelBindingSource.IndexOf(Row);
                    //Row = newRow;
                    PAYEReliefeViewModelBindingSource[newRowIndex] = newRow;
                }
                else
                {
                    PAYEReliefeViewModelBindingSource.RemoveAt(gvPAYERelief.GetFocusedDataSourceRowIndex());
                }
            }
            else if (res.ExecutionResult == eExecutionResult.ErrorWhileExecuting)
            {
                Row.SavingError = "Error while saving.\r\n" + res.Exception.Message;
            }
            else if (res.ExecutionResult == eExecutionResult.ValidationError)
            {
                Row.SavingError = "Validation Errors.\r\n" + res.ValidationError;
            }
            else if (!String.IsNullOrWhiteSpace(res.MessageAfterSave))
            {
                Row.SavingError = "Please note:\r\n" + res.MessageAfterSave;
            }
        }
コード例 #22
0
        public SavingResult DeleteRecord(long DeleteID, dbVisionEntities db)
        {
            SavingResult res = null;

            if (DeleteID != 0)
            {
                tblFinPeriod RecordToDelete = db.tblFinPeriods.FirstOrDefault(r => r.FinPeriodID == DeleteID);

                res = DeleteRecord(RecordToDelete, db);
            }
            else
            {
                res = new SavingResult();
            }
            return(res);
        }
コード例 #23
0
ファイル: GridLayoutDAL.cs プロジェクト: ewin66/RAPH
        public SavingResult SaveLayout(eGridControlIDs GridID, string Layout, string PrintOptions, string PageSettings, long CompanyID, long FinPerID)
        {
            SavingResult res = new SavingResult();

            //--
            using (dbVisionEntities db = new dbVisionEntities())
            {
                int           intGrid   = (int)GridID;
                tblGridLayout SaveModel = db.tblGridLayouts.FirstOrDefault(r => r.GridID == intGrid && r.CompanyID == CompanyID && r.FinPerID == FinPerID);

                if (SaveModel == null) // New Entry
                {
                    SaveModel       = new tblGridLayout();
                    SaveModel.rcuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
                    SaveModel.rcdt  = DateTime.Now;
                    db.tblGridLayouts.Add(SaveModel);
                }
                else
                {
                    SaveModel.reuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
                    SaveModel.redt  = DateTime.Now;
                    db.tblGridLayouts.Attach(SaveModel);
                    db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;
                }

                SaveModel.GridID       = (int)GridID;
                SaveModel.Descr        = GridID.ToString();
                SaveModel.Layout       = Layout;
                SaveModel.PrintOptions = PrintOptions;
                SaveModel.PageSettings = PageSettings;
                SaveModel.CompanyID    = Model.CommonProperties.LoginInfo.LoggedInCompany.CompanyID;
                SaveModel.FinPerID     = Model.CommonProperties.LoginInfo.LoggedInFinPeriod.FinPeriodID;

                try
                {
                    db.SaveChanges();
                    res.PrimeKeyValue   = SaveModel.GridLayoutID;
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                }
            }
            return(res);
        }
コード例 #24
0
ファイル: EmployeeListReportDAL.cs プロジェクト: ewin66/RAPH
        public SavingResult SaveFormat(int FormatID, string FormatName, string GridFormat)
        {
            SavingResult res = new SavingResult();

            using (dbVisionEntities db = new dbVisionEntities())
            {
                tblEmployeeListFormat SaveModel = null;
                if (FormatID > 0)
                {
                    SaveModel = db.tblEmployeeListFormats.Find(FormatID);
                }

                if (SaveModel == null)
                {
                    SaveModel = new tblEmployeeListFormat()
                    {
                        rcdt  = DateTime.Now,
                        rcuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID,
                    };
                    db.tblEmployeeListFormats.Add(SaveModel);
                }
                else
                {
                    SaveModel.redt  = DateTime.Now;
                    SaveModel.reuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;

                    db.tblEmployeeListFormats.Attach(SaveModel);
                    db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;
                }

                SaveModel.EmployeeListFormatName = FormatName;
                SaveModel.GridFromat             = GridFormat;

                try
                {
                    db.SaveChanges();
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                    res.PrimeKeyValue   = SaveModel.EmployeeListFormatID;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                }
            }
            return(res);
        }
コード例 #25
0
        public SavingResult UpdateWIBAClassRate(DateTime?WEDate, List <EmployeeWIBAClassRateViewModel> Rate)
        {
            SavingResult res = new SavingResult();

            //--
            using (dbVisionEntities db = new dbVisionEntities())
            {
                var   SelectedRates        = Rate.Where(r => r.Selected);
                int[] SelectedWIBAClassIDs = SelectedRates.Select(r => r.EmployeeWIBClassID).ToArray();
                if (WEDate == null)
                {
                    db.tblEmployeeWIBAClassRates.RemoveRange(db.tblEmployeeWIBAClassRates.Where(r => SelectedWIBAClassIDs.Contains(r.EmployeeWIBAClassID)));
                }
                else
                {
                    db.tblEmployeeWIBAClassRates.RemoveRange(db.tblEmployeeWIBAClassRates.Where(r => SelectedWIBAClassIDs.Contains(r.EmployeeWIBAClassID) && r.WEDate >= WEDate));
                }

                foreach (var rate in SelectedRates)
                {
                    tblEmployeeWIBAClassRate SaveModel = new tblEmployeeWIBAClassRate()
                    {
                        EmployeeWIBAClassID = rate.EmployeeWIBClassID,
                        WEDate = WEDate,
                        EmployeeWIBAClassRate = rate.Rate,
                        CompanyID             = CommonProperties.LoginInfo.LoggedInCompany.CompanyID,
                        rcdt  = DateTime.Now,
                        rcuid = CommonProperties.LoginInfo.LoggedinUser.UserID,
                    };
                    db.tblEmployeeWIBAClassRates.Add(SaveModel);
                }

                try
                {
                    db.SaveChanges();
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                }
            }
            //--
            return(res);
        }
コード例 #26
0
        public ActionResult ApproveCustomer(int id, bool Approved)
        {
            SavingResult SavingRes = DALObj.ApproveUser(id, Approved);

            CustomerViewModel ViewModel = DALObj.FindByID(id);

            if (Common.Functions.SetAfterSaveResult(ModelState, SavingRes))
            {
                CustomerViewModel Customer = DALObj.FindByID(id);

                string SendTo  = null;
                string Subject = null;
                string Body    = null;
                if (Approved)
                {
                    SendTo  = Customer.EMailID;
                    Subject = "You account has been approved.";
                    Body    = string.Format(@"Dear sir,
Your account on {0} has been approved. Now you can place order on {0}.

Please login by clicking on the link below. 

{1}

If the above link is not working then please copy and paste the above link in address bar. If you have any issue, please contact support on {0}
", Common.Props.CurrentDomainName,
                                            Common.Props.CurrentDomainName + @"/Users/Login");

                    Common.Functions.SendEmailFromNoReply(SendTo, Subject, Body);
                }
                else
                {
                    SendTo  = Customer.EMailID;
                    Subject = "You account has been rejected by admin.";
                    Body    = string.Format(@"Dear customer,
Your account on {0} has been disapproved and rejected by admin. Please contact support on {0} for more details.", Common.Props.CurrentDomainName);

                    Common.Functions.SendEmailFromNoReply(SendTo, Subject, Body);
                }

                return(RedirectToAction("ApproveCustomerConfirm", new { id = id }));
            }

            return(View(ViewModel));
        }
コード例 #27
0
ファイル: Functions.cs プロジェクト: HaierAliWajihi/UCA
        public static bool SetAfterSaveResult(ModelStateDictionary ModelState, SavingResult res)
        {
            switch (res.ExecutionResult)
            {
            case eExecutionResult.CommitedSucessfuly:
                return(true);

            case eExecutionResult.ErrorWhileExecuting:
                ModelState.AddModelError("", res.Exception.Message);
                break;

            case eExecutionResult.ValidationError:
                ModelState.AddModelError("", res.ValidationError);
                break;
            }

            return(false);
        }
コード例 #28
0
        public SavingResult Termination(int EmployeeID, eTerminationType Type, DateTime TerminationDate, string Reason)
        {
            SavingResult res = new SavingResult();

            using (dbVisionEntities db = new dbVisionEntities())
            {
                var SaveModel = db.tblEmployees.Find(EmployeeID);
                if (SaveModel == null)
                {
                    res.ValidationError = "Selected employee not found.";
                    res.ExecutionResult = eExecutionResult.ValidationError;
                    return(res);
                }
                tblEmployeeServiceDetail ServiceSaveModel = null;
                if (SaveModel.EmployeeLastServiceDetailID != null)
                {
                    ServiceSaveModel = db.tblEmployeeServiceDetails.Find(SaveModel.EmployeeLastServiceDetailID);
                }
                if (ServiceSaveModel == null)
                {
                    res.ValidationError = "No service detail found.";
                    res.ExecutionResult = eExecutionResult.ValidationError;
                    return(res);
                }

                ServiceSaveModel.EmployeementStatus = (byte)(Type == eTerminationType.Resignation ? eEmployementStatus.Resigned : eEmployementStatus.Terminated);
                ServiceSaveModel.TerminationTypeID  = (byte)Type;
                ServiceSaveModel.TerminationDate    = TerminationDate;
                ServiceSaveModel.TerminationReason  = Reason;
                db.tblEmployeeServiceDetails.Attach(ServiceSaveModel);
                db.Entry(ServiceSaveModel).State = System.Data.Entity.EntityState.Modified;

                try
                {
                    db.SaveChanges();
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    CommonFunctions.GetFinalError(res, ex);
                }
            }
            return(res);
        }
コード例 #29
0
        /// <summary>
        /// Processes the after delete record event.
        /// </summary>
        /// <param name="parameters">Parameters</param>
        /// <returns></returns>
        public async Task <SavingResult> ProcessAfterDeleteRecordAsync(SaveParameters parameters)
        {
            SavingResult result;

            try
            {
                await this.ExecuteActionsAsync(parameters, ETableDbEventType.BeforeCreate);

                result = new SavingResult()
                {
                    Result = parameters.AdditionalParameters
                };
            }
            catch (ALexException ex)
            {
                result = base.GetResultFromException <SavingResult>(ex, 4006);
            }
            return(result);
        }
コード例 #30
0
ファイル: UserDAL.cs プロジェクト: HaierAliWajihi/UCA
        public SavingResult ApproveUser(int UserID)
        {
            SavingResult res = new SavingResult();

            using (dbUltraCoralEntities db = new dbUltraCoralEntities())
            {
                tblUser SaveModel = null;
                SaveModel = db.tblUsers.FirstOrDefault(r => r.UserID == UserID);
                if (SaveModel == null)
                {
                    res.ExecutionResult = eExecutionResult.ValidationError;
                    res.ValidationError = "Selected user has been deleted over network. Can not find user's details. Please retry.";
                    return(res);
                }

                SaveModel.IsApproved = true;
                SaveModel.redt       = DateTime.Now;

                db.tblUsers.Attach(SaveModel);
                db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;

                //--
                try
                {
                    db.SaveChanges();
                    res.PrimeKeyValue   = SaveModel.UserID;
                    res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
                }
                catch (Exception ex)
                {
                    while (ex.Message == "An error occurred while updating the entries. See the inner exception for details.")
                    {
                        ex = ex.InnerException;
                    }

                    res.ExecutionResult = eExecutionResult.ErrorWhileExecuting;
                    res.Exception       = ex;
                }
            }

            return(res);
        }