Esempio n. 1
0
        public async Task <ActionResult> DeleteConfirmed(int id)
        {
            hr_EmployeeSalary hr_EmployeeSalary = await db.hr_EmployeeSalary.FindAsync(id);

            db.hr_EmployeeSalary.Remove(hr_EmployeeSalary);
            await db.SaveChangesAsync();

            return(RedirectToAction("Index"));
        }
Esempio n. 2
0
        public ActionResult Save(hr_EmployeeSalary Item)
        {
            int status = 0;


            // Start Validation cheack
            if (ModelState.IsValid)
            {
                //################### Edit Item ###################//
                //Item.EmployeeJobID = .;
                var salary = new hr_SalaryHistory();
                Item = db.hr_EmployeeSalary.Where(a => a.EmployeeID == Item.EmployeeID).FirstOrDefault();
                salary.ImployeeID = Item.EmployeeID ?? 0;
                salary.SalaryHistoryAllownaceAmount  = Item.EmployeesSalaryAllownace;
                salary.SalaryHistoryAmount           = Item.EmployeesSalary ?? 0;
                salary.SalaryHistoryDeducationAmount = Item.EmployeesSalarydeducate;
                salary.SalaryHistoryProcduerDate     = DateTime.Now;
                salary.SalaryHistoryDate             = Item.EmployeesSalarydate;
                salary.ImployeeName = db.hr_Employees.Find(Item.EmployeeID).EmployeeFullName;
                db.hr_SalaryHistory.Add(salary);
                db.SaveChanges();
                ////////////////////
                var employeeDebtRecords = db.hr_EmployeeDebtRecords.Where(h => h.DebtRecordsEmpoloyeeID == Item.EmployeeID);

                foreach (var item in employeeDebtRecords.Where(x => employeeDebtRecords.Any(y => y.DebtRecordsEmpoloyeeID == Item.EmployeeID)).ToList())
                {
                    db.hr_EmployeeDebtRecords.Remove(item);
                }

                db.SaveChanges();
                status = 2;  // 2 fro

                //End Save New Item

                return(new JsonResult {
                    Data = new { status = status }
                });
            }
            // End Validation cheack


            // Start Send validation error
            else
            {
                var errorList = ModelState.Values.SelectMany(m => m.Errors)
                                .Select(e => e.ErrorMessage)
                                .ToList();

                return(new JsonResult {
                    Data = new { status = errorList }
                });
            }
            // End  Send validation error
        }
Esempio n. 3
0
        public async Task <ActionResult> Edit([Bind(Include = "Id,EmployeeID,EmployeesSalary,EmployeesSalarydate")] hr_EmployeeSalary hr_EmployeeSalary)
        {
            if (ModelState.IsValid)
            {
                db.Entry(hr_EmployeeSalary).State = EntityState.Modified;
                await db.SaveChangesAsync();

                return(RedirectToAction("Index"));
            }
            return(View(hr_EmployeeSalary));
        }
Esempio n. 4
0
        public async Task <ActionResult> Create([Bind(Include = "Id,EmployeeID,EmployeesSalary,EmployeesSalarydate")] hr_EmployeeSalary hr_EmployeeSalary)
        {
            if (ModelState.IsValid)
            {
                db.hr_EmployeeSalary.Add(hr_EmployeeSalary);
                await db.SaveChangesAsync();

                return(RedirectToAction("Index"));
            }

            return(View(hr_EmployeeSalary));
        }
Esempio n. 5
0
        // GET: EmployeeSalary/Delete/5
        public async Task <ActionResult> Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            hr_EmployeeSalary hr_EmployeeSalary = await db.hr_EmployeeSalary.FindAsync(id);

            if (hr_EmployeeSalary == null)
            {
                return(HttpNotFound());
            }
            return(View(hr_EmployeeSalary));
        }
Esempio n. 6
0
        public ActionResult Save(hr_Employees Item, FormCollection form)
        {
            int status = 0;

            if (!EmployeeValidation(Item))
            {
                NameErrow         = "الرجاء إدخال إسم الموظف";
                ViewBag.NameErrow = NameErrow;
                return(View());
            }

            // Start Validation cheack
            if (ModelState.IsValid)
            {
                //################### Edit Item ###################//
                if (Item.EmployeeID > 0)
                {
                    var v = db.hr_Employees.Where(I => I.EmployeeID == Item.EmployeeID).FirstOrDefault();
                    if (v != null)
                    {
                        v.EmployeeID           = Item.EmployeeID;
                        v.EmployeeFullName     = Item.EmployeeFullName;
                        v.EmployeeDepartmentID = Item.EmployeeDepartmentID;
                        v.EmployeeJobID        = Item.EmployeeJobID;
                        v.EmployeePhone        = Item.EmployeePhone;
                        v.EmployeeAddress      = Item.EmployeeAddress;
                        v.PointOfsaleID        = Item.PointOfsaleID;
                        v.EmployeeStatus       = Item.EmployeeStatus ?? 1;
                        db.SaveChanges();
                        status = 1; // 1 for update
                    }
                    status = 1;     // 1 for update
                }
                //################### Edit Item //###################

                // Start Save New Item
                else
                {
                    //Item.EmployeeJobID = .;
                    Item.EmployeeStatus = 1;
                    Item.EmployeeGender = 1;
                    db.hr_Employees.Add(Item);
                    db.SaveChanges();
                    var salary = new hr_EmployeeSalary();
                    salary.EmployeeID          = Item.EmployeeID;
                    salary.EmployeesSalarydate = DateTime.Now;
                    salary.EmployeesSalary     = Double.Parse(db.hr_JobsName.Find(Item.EmployeeJobID).JobNameBasicSalary.ToString());
                    db.hr_EmployeeSalary.Add(salary);
                    db.SaveChanges();
                    status = 2;  // 2 fro
                }
                //End Save New Item

                return(new JsonResult {
                    Data = new { status = status }
                });
            }
            // End Validation cheack


            // Start Send validation error
            else
            {
                var errorList = ModelState.Values.SelectMany(m => m.Errors)
                                .Select(e => e.ErrorMessage)
                                .ToList();

                return(new JsonResult {
                    Data = new { status = errorList }
                });
            }
            // End  Send validation error
        }
        public ActionResult Save(hr_EmpDedicationAllowance Item)
        {
            int status = 0;


            // Start Validation cheack
            if (ModelState.IsValid)
            {
                var type = db.hr_DedicationAllowanceList.Find(Item.DedicationAllowanceListID).DeductionAllowanceID;
                //################### Edit Item ###################//
                if (Item.EmpDedicationAllowanceID > 0)
                {
                    var v = db.hr_EmpDedicationAllowance.Where(I => I.EmpDedicationAllowanceID == Item.EmpDedicationAllowanceID).FirstOrDefault();
                    if (v != null)
                    {
                        updateSalary(Item.DedicationAllowanceListID, (int)v.EmpBatchValue, (int)Item.EmpBatchValue, Item.EmployeeID, type);
                        v.EmpBatchValue = Item.EmpBatchValue;
                        db.SaveChanges();
                        status = 1; // 1 for update


                        ///////////////////////////////
                    }
                    status = 1; // 1 for update
                }
                //################### Edit Item //###################

                // Start Save New Item
                else
                {
                    Item.EmpBatchDate = DateTime.Now;
                    db.hr_EmpDedicationAllowance.Add(Item);
                    db.SaveChanges();
                    /////////////////////////////////////////////
                    var salary = new hr_EmployeeSalary();

                    salary = db.hr_EmployeeSalary.Where(I => I.EmployeeID == Item.EmployeeID).FirstOrDefault();
                    if (type == 1)
                    {
                        salary.EmployeesSalaryAllownace = salary.EmployeesSalaryAllownace + (Double)Item.EmpBatchValue;
                    }
                    else
                    {
                        salary.EmployeesSalarydeducate = salary.EmployeesSalarydeducate + (Double)Item.EmpBatchValue;
                    }

                    db.SaveChanges();
                    status = 2;
                }
                //End Save New Item

                return(new JsonResult {
                    Data = new { status = status }
                });
            }
            // End Validation cheack


            // Start Send validation error
            else
            {
                var errorList = ModelState.Values.SelectMany(m => m.Errors)
                                .Select(e => e.ErrorMessage)
                                .ToList();

                return(new JsonResult {
                    Data = new { status = errorList }
                });
            }
            // End  Send validation error
        }