예제 #1
0
        public ActionResult Create([Bind(Include = "CastCode,ReligionID,CastName")] CastMaster CastMasters)
        {
            //if (ModelState.IsValid)
            //{
            //    db.CastMasters.Add(CastMasters);
            //    db.SaveChanges();
            //    return RedirectToAction("Index");
            //}

            //ViewBag.ReligionID = new SelectList(db.ReligionMaster, "ReligionID", "ReligionShortName", CastMasters.ReligionID);
            //return View(CastMasters);

            if (ModelState.IsValid)
            {
                bool isValid = db.CastMasters.Any(x => x.ReligionID == CastMasters.ReligionID && x.CastName == CastMasters.CastName);
                if (!isValid)
                {
                    db.CastMasters.Add(CastMasters);
                    db.SaveChanges();
                    ViewBag.success = "Cast Name is Successfully created!";
                    ModelState.Clear();
                    ViewBag.ReligionID = new SelectList(db.ReligionMasters, "ReligionID", "ReligionName", CastMasters.ReligionID);
                    return(View());
                }
                else
                {
                    ViewBag.error      = "Sorry! Cast Name is already exist!";
                    ViewBag.ReligionID = new SelectList(db.ReligionMasters, "ReligionID", "ReligionName", CastMasters.ReligionID);
                    return(View(CastMasters));
                }
            }
            ViewBag.ReligionID = new SelectList(db.ReligionMasters, "ReligionID", "ReligionName", CastMasters.ReligionID);

            return(View(CastMasters));
        }
        public ActionResult Create([Bind(Include = "Category_ID,Category_Name,Grade_Name,Grade_Detail")] HRMS_CATEGORY_GRADE hRMS_CATEGORY_GRADE)
        {
            if (ModelState.IsValid)
            {
                var category_name = db.HRMS_CATEGORY_GRADE.FirstOrDefault(rec => rec.Category_Name == hRMS_CATEGORY_GRADE.Category_Name);
                if (category_name != null)
                {
                    var grade_name = db.HRMS_CATEGORY_GRADE.FirstOrDefault(rec => rec.Grade_Name == hRMS_CATEGORY_GRADE.Grade_Name);
                    if (grade_name != null)
                    {
                        ViewBag.Grade_Status = "Grade name is Already exist in the same category !";
                        return(View());
                    }
                    db.HRMS_CATEGORY_GRADE.Add(hRMS_CATEGORY_GRADE);
                    db.SaveChanges();
                    ViewBag.Grade_Status = "Grade is added Successfuly.";
                    return(View(hRMS_CATEGORY_GRADE));
                }
                db.HRMS_CATEGORY_GRADE.Add(hRMS_CATEGORY_GRADE);
                db.SaveChanges();
                ViewBag.Grade_Status = "Grade is added Successfuly.";
                return(View(hRMS_CATEGORY_GRADE));
            }

            return(View(hRMS_CATEGORY_GRADE));
        }
예제 #3
0
        public ActionResult Create([Bind(Include = "ID,Short_Name,Name,Description")] HRMS_Travel_type hRMS_Travel_type)
        {
            if (ModelState.IsValid)
            {
                HRMS_Travel_type short_typealready = db.HRMS_Travel_type.Where(rec => rec.Short_Name == hRMS_Travel_type.Short_Name).FirstOrDefault();
                if (short_typealready == null)
                {
                    HRMS_Travel_type type_name_already = db.HRMS_Travel_type.Where(rec => rec.Name == hRMS_Travel_type.Name).FirstOrDefault();
                    if (type_name_already == null)
                    {
                        db.HRMS_Travel_type.Add(hRMS_Travel_type);
                        db.SaveChanges(); ModelState.Clear();

                        ViewBag.TypeStatus = "New Travel Type is added successfully.";
                        return(View());
                    }
                    else
                    {
                        ViewBag.TypeStatus = "The name is already exist in another travel type!";
                        return(View());
                    }
                }
                else
                {
                    ViewBag.TypeStatus = "The short name is already exist in another travel type!";
                    return(View());
                }
            }

            return(View(hRMS_Travel_type));
        }
예제 #4
0
        public IHttpActionResult PutUserMasters(int id, tblUserMaster UserMaster)
        {
            if (id != UserMaster.UserID)
            {
                return(BadRequest());
            }
            db.Entry(UserMaster).State = EntityState.Modified;
            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!UserMastersExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
        public IHttpActionResult PutEmployee(string id, Employee employee)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != employee.ID)
            {
                return(BadRequest());
            }

            db.Entry(employee).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!EmployeeExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
예제 #6
0
 //Apply leave
 public int ApplyLeave(LeaveStatu leavestatus)
 {
     //obj.LeaveStatus(leavestatus);
     obj.LeaveStatus.Add(leavestatus);
     obj.SaveChanges();
     return(leavestatus.ID);
 }
예제 #7
0
        public ActionResult Create([Bind(Include = "ID,Cost_Cntr_Code,Cost_Cntr_Name,Parent_Cost_Cntr_Code,Ledger_Code")] HRMS_COST_CENTER hRMS_COST_CENTER)
        {
            if (ModelState.IsValid)
            {
                var existData = db.HRMS_COST_CENTER.FirstOrDefault(rec => rec.Cost_Cntr_Code == hRMS_COST_CENTER.Cost_Cntr_Code && rec.Cost_Cntr_Name == hRMS_COST_CENTER.Cost_Cntr_Name);
                if (existData == null)
                {
                    var existCode = db.HRMS_COST_CENTER.FirstOrDefault(rec => rec.Cost_Cntr_Code == hRMS_COST_CENTER.Cost_Cntr_Code);
                    if (existCode == null)
                    {
                        var ExistName = db.HRMS_COST_CENTER.FirstOrDefault(rec => rec.Cost_Cntr_Name == hRMS_COST_CENTER.Cost_Cntr_Name);
                        if (ExistName == null)
                        {
                            db.HRMS_COST_CENTER.Add(hRMS_COST_CENTER);
                            db.SaveChanges();
                            ViewBag.cost_Status = "New Cost added succcessfully.";
                            return(View());
                        }
                        ViewBag.cost_Status = "This Cost Name is Already Exist ! ";
                        return(View());
                    }
                    ViewBag.cost_Status = "This Cost code is already exist !";
                    return(View());
                }
                ViewBag.cost_Status = "this cost Code and Name is already exist !";
                return(View());
            }

            return(View(hRMS_COST_CENTER));
        }
예제 #8
0
        public ActionResult Create([Bind(Include = "ID,FacultyType,EMP_ID,External_Name,PAN_No,ServiceTaxNo,Qualification,Contact,Email,Remark,IsActive,Empty")] HRMS_Faculty_MS hRMS_Faculty_MS)
        {
            if (ModelState.IsValid)
            {
                if (hRMS_Faculty_MS.FacultyType == "Internal" && hRMS_Faculty_MS.EMP_ID != null)
                {
                    bool IsExist = db.HRMS_Faculty_MS.Any(x => x.EMP_ID == hRMS_Faculty_MS.EMP_ID);
                    if (IsExist)
                    {
                        ViewBag.error = "Faculty type already assigned to this Employee!";
                        ModelState.Clear();
                        return(View());
                    }
                    else
                    {
                        HRMS_Emp_Details obj  = db.HRMS_Emp_Details.Where(x => x.EMP_ID == hRMS_Faculty_MS.EMP_ID).FirstOrDefault();
                        string           name = obj.First_Name + " " + obj.Last_Name;
                        hRMS_Faculty_MS.External_Name = name;
                        db.HRMS_Faculty_MS.Add(hRMS_Faculty_MS);
                        db.SaveChanges();
                        ModelState.Clear();
                        ViewBag.success = "Successfully Faculty type assigned to this Employee!";
                        return(View());
                    }
                }
                db.HRMS_Faculty_MS.Add(hRMS_Faculty_MS);
                db.SaveChanges();
                ModelState.Clear();
                ViewBag.success = "Successfully Faculty type assigned to this Employee!";
                return(View());
            }

            return(View(hRMS_Faculty_MS));
        }
        public ActionResult Create([Bind(Include = "ReligionID,ReligionShortName,ReligionName")] ReligionMaster religionMaster)
        {
            if (ModelState.IsValid)
            {
                bool isValid = db.ReligionMaster.Any(x => x.ReligionShortName == religionMaster.ReligionShortName || x.ReligionName == religionMaster.ReligionName);
                if (!isValid)
                {
                    db.ReligionMaster.Add(religionMaster);
                    db.SaveChanges();
                    ViewBag.success = "Religion is Successfully created!";
                    ModelState.Clear();
                    return(View());
                }
                else
                {
                    if (db.ReligionMaster.Any(x => x.ReligionName == religionMaster.ReligionName))
                    {
                        ViewBag.error = "Sorry! Religion name is already exist!";
                        return(View(religionMaster));
                    }
                    else
                    {
                        ViewBag.error = "Sorry! Religion Short Name is already exist!";
                        return(View(religionMaster));
                    }
                }
            }

            return(View(religionMaster));
        }
예제 #10
0
        public ActionResult Create([Bind(Include = "UnitCode,UnitName,Address,Country,City,Pincode,Priority,PaySlip,IsActive,State")] UnitMaster unitMaster)
        {
            if (ModelState.IsValid)
            {
                bool isValid = db.UnitMasters.Any(x => x.UnitName == unitMaster.UnitName || x.Priority == unitMaster.Priority);
                if (!isValid)
                {
                    unitMaster.IsActive = true;
                    db.UnitMasters.Add(unitMaster);
                    db.SaveChanges();
                    ViewBag.success = "Unit is Successfully created!";
                    ModelState.Clear();
                    ViewBag.Country = new SelectList(db.Countries, "CountryName", "CountryName");
                    ViewBag.State   = new SelectList("");
                    ViewBag.City    = new SelectList("");
                    return(View());
                }
                else
                {
                    ViewBag.error = "Sorry! Unitname is already exist!";
                    long cid = db.Countries.Where(x => x.CountryName == unitMaster.Country).Select(x => x.CountryID).SingleOrDefault();
                    long sid = db.States.Where(x => x.StateName == unitMaster.State).Select(x => x.StateID).SingleOrDefault();
                    ViewBag.Country = new SelectList(db.Countries, "CountryName", "CountryName");
                    ViewBag.State   = new SelectList(db.States.Where(x => x.CountryID == cid), "StateName", "StateName");
                    ViewBag.City    = new SelectList(db.Cities.Where(x => x.StateID == sid), "CityName", "CityName");

                    return(View(unitMaster));
                }
            }

            ViewBag.Country = new SelectList(db.Countries, "CountryName", "CountryName");
            ViewBag.State   = new SelectList("");
            ViewBag.City    = new SelectList("");
            return(View(unitMaster));
        }
예제 #11
0
        public IHttpActionResult PutHoliday(int id, tblHoliday holiday)
        {
            if (id != holiday.ID)
            {
                return(BadRequest());
            }
            db.Entry(holiday).State = EntityState.Modified;
            holiday.HOLIDAY_DAY     = holiday.HOLIDAY_DATE.DayOfWeek.ToString();
            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!HolidayExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
예제 #12
0
        public IHttpActionResult PutProjects(int id, tblProject project)
        {
            if (id != project.ID)
            {
                return(BadRequest());
            }
            db.Entry(project).State = EntityState.Modified;
            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!ProjectExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
예제 #13
0
        public ActionResult Create([Bind(Include = "CitizenShip_ID,CitizenShip_Country_NM")] HRMS_EMP_CITIZENSHIP_MS hRMS_EMP_CITIZENSHIP_MS)
        {
            if (ModelState.IsValid)
            {
                bool isValid = db.HRMS_EMP_CITIZENSHIP_MS.Any(x => x.CitizenShip_Country_NM == hRMS_EMP_CITIZENSHIP_MS.CitizenShip_Country_NM);
                if (!isValid)
                {
                    db.HRMS_EMP_CITIZENSHIP_MS.Add(hRMS_EMP_CITIZENSHIP_MS);
                    db.SaveChanges();
                    ViewBag.success = "It is Successfully Added!";
                    ModelState.Clear();
                    return(View());
                }
                else
                {
                    ViewBag.success = "Sorry! It is already exist!";
                    return(View(hRMS_EMP_CITIZENSHIP_MS));
                }


                //db.HRMS_EMP_CITIZENSHIP_MS.Add(hRMS_EMP_CITIZENSHIP_MS);
                //db.SaveChanges();
                //ModelState.Clear();

                //return RedirectToAction("Index");
            }

            return(View(hRMS_EMP_CITIZENSHIP_MS));
        }
예제 #14
0
        public IHttpActionResult PutTaskHistory(int task_id, tblTaskHistory taskHistory)
        {
            if (task_id != taskHistory.TASK_ID)
            {
                return(BadRequest());
            }
            db.Entry(taskHistory).State = EntityState.Modified;
            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!TaskHistoryExists(task_id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
예제 #15
0
        public ActionResult Create([Bind(Include = "Mode_ID,Mode_Type,Mode_Name,Mode_Short_Name")] HRMS_TravelMode_MS hRMS_TravelMode_MS)
        {
            if (ModelState.IsValid)
            {
                bool isValid = db.HRMS_TravelMode_MS.Any(x => (x.Mode_Name == hRMS_TravelMode_MS.Mode_Name || x.Mode_Short_Name == hRMS_TravelMode_MS.Mode_Short_Name));
                if (!isValid)
                {
                    db.HRMS_TravelMode_MS.Add(hRMS_TravelMode_MS);
                    db.SaveChanges();
                    ViewBag.success = "Travel Mode is Successfully Added!";
                    ModelState.Clear();
                    return(View());
                }
                else
                {
                    if (db.HRMS_TravelMode_MS.Any(x => x.Mode_Name == hRMS_TravelMode_MS.Mode_Name))
                    {
                        ViewBag.error = "Sorry! Mode Name is already exist!";
                        return(View(hRMS_TravelMode_MS));
                    }
                    else
                    {
                        ViewBag.error = "Sorry! Mode Short Name is already exist!";
                        return(View(hRMS_TravelMode_MS));
                    }
                }
            }

            return(View(hRMS_TravelMode_MS));
        }
예제 #16
0
        public ActionResult Create([Bind(Include = "Skill_ID,Skill_Name,Skill_Remark")] HRMS_TRAINING_SKILL_MS hRMS_TRAINING_SKILL_MS)
        {
            if (ModelState.IsValid)
            {
                ViewBag.Status = "";
                var existData = db.HRMS_TRAINING_SKILL_MS.FirstOrDefault(rec => rec.Skill_Name == hRMS_TRAINING_SKILL_MS.Skill_Name && rec.Skill_Remark == hRMS_TRAINING_SKILL_MS.Skill_Remark);
                if (existData == null)
                {
                    //var ExistRemark = db.HRMS_TRAINING_SKILL_MS.FirstOrDefault(rec => rec.Skill_Remark == hRMS_TRAINING_SKILL_MS.Skill_Remark);
                    //if (ExistRemark == null)
                    //{
                    db.HRMS_TRAINING_SKILL_MS.Add(hRMS_TRAINING_SKILL_MS);
                    db.SaveChanges();
                    ModelState.Clear();
                    ViewBag.Status = "New Skill added succcessfully.";
                    return(View());
                    //}
                    //ViewBag.Status = "This Remark is Already Exist ! ";
                    //return View();
                }
                ViewBag.Status = "this Skill is already exist !";
                return(View());
            }

            return(View(hRMS_TRAINING_SKILL_MS));
        }
예제 #17
0
        public ActionResult Create([Bind(Include = "Designation_ID,Designation_Parent,Designation_ShortName,Designation_Name")] HRMS_EMP_DESIGNATION_MS hRMS_EMP_DESIGNATION_MS)
        {
            HRMS_EMP_DESIGNATION_MS        h1 = db.HRMS_EMP_DESIGNATION_MS.Where(rec => rec.Designation_ID != 0).FirstOrDefault();
            List <HRMS_EMP_DESIGNATION_MS> h2 = db.HRMS_EMP_DESIGNATION_MS.ToList();
            dynamic MultiView = new ExpandoObject();

            MultiView.data  = h1;
            MultiView.list1 = h2;



            HRMS_EMP_DESIGNATION_MS hed = new HRMS_EMP_DESIGNATION_MS();
            string D_parent             = Request["D_parent"];
            string D_name = Request["D_name"];

            if (D_parent == "" || D_parent == null)
            {
                if (db.HRMS_EMP_DESIGNATION_MS.Where(rec => rec.Designation_Parent == D_name).Any())
                {
                    ViewBag.message = "Designation Already exist  !!!!!!!";
                }
                else
                {
                    hed.Designation_Parent    = Request["D_name"];
                    hed.Designation_ShortName = Request["D_shortname"];
                    hed.Designation_Name      = Request["D_name"];
                    db.HRMS_EMP_DESIGNATION_MS.Add(hed);
                    db.SaveChanges();
                    ViewBag.message = "Designation Added as parent  !!!!!!!";
                }
            }
            else if (db.HRMS_EMP_DESIGNATION_MS.Where(rec => rec.Designation_Parent == D_parent && rec.Designation_Name == D_name).Any())
            {
                ViewBag.message = "Designation Relationship already existed  !!!!!!!";
            }
            else
            {
                if (D_parent == D_name)
                {
                    ViewBag.message = "Not Valid Relationship  !!!!!!!";
                }
                else
                {
                    hed.Designation_Parent    = Request["D_parent"];
                    hed.Designation_ShortName = Request["D_shortname"];
                    hed.Designation_Name      = Request["D_name"];
                    db.HRMS_EMP_DESIGNATION_MS.Add(hed);
                    db.SaveChanges();
                    ViewBag.message = "Added  !!!!!!!";
                }
            }



            //                return RedirectToAction("Index");


            return(View("Create", MultiView));
        }
예제 #18
0
        public ActionResult Vieww(HRMS_TrainingApproval obj)
        {
            obj.Status = 1; //pending request

            db.HRMS_TrainingApproval.Add(obj);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        public ActionResult Revieww(IEnumerable <string> Answer, IEnumerable <long> Question, IEnumerable <string> flag, String Textt, string Check)
        {
            //Answer.Zip(Question, Tuple.Create)
            //a:answer
            //b:question
            //c:flag
            long ProID = Convert.ToInt64(TempData["ProgramID"]);

            if (Textt == "")
            {
                TempData["Error"] = "Please!Fill the Rating!";
                return(RedirectToAction("Review", new { id = ProID }));
            }

            long empid = Convert.ToInt64(Session["id"]);
            // long ProID =Convert.ToInt64(TempData["ProgramID"]);
            var results = Answer.ZipThree(Question, flag, (a, b, c) => new { a, b, c });

            foreach (var item in results)
            {
                HRMS_TrainingReview obj = new HRMS_TrainingReview();
                obj.Emp_ID        = empid;
                obj.ProgramID     = ProID;
                obj.QuestionID    = item.b;
                obj.Date          = DateTime.Now;
                obj.OtherComments = Textt;
                if (Check != null)
                {
                    obj.IsWorthy = true;
                }
                else
                {
                    obj.IsWorthy = false;
                }

                if (item.c == "False")  //dropdown
                {
                    obj.NonDescriptive = Convert.ToInt32(item.a);
                }
                else
                {
                    obj.Descriptive = item.a;
                }
                db.HRMS_TrainingReview.Add(obj);
                db.SaveChanges();
            }

            //flag insert in trainingApproval
            HRMS_TrainingApproval TA = db.HRMS_TrainingApproval.Where(x => x.Program_ID == ProID && x.EMP_ID == empid).FirstOrDefault();

            TA.IsReviewDone    = 1; //Review Done
            db.Entry(TA).State = EntityState.Modified;
            db.SaveChanges();

            return(RedirectToAction("Index"));
        }
예제 #20
0
        public ActionResult Create([Bind(Include = "Gender_ID,Gender_Value")] HRMS_EMP_GENDER_MS hRMS_EMP_GENDER_MS)
        {
            if (ModelState.IsValid)
            {
                db.HRMS_EMP_GENDER_MS.Add(hRMS_EMP_GENDER_MS);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(hRMS_EMP_GENDER_MS));
        }
예제 #21
0
        public ActionResult Create([Bind(Include = "CitizenShip_ID,CitizenShip_Country_NM")] HRMS_EMP_CITIZENSHIP_MS hRMS_EMP_CITIZENSHIP_MS)
        {
            if (ModelState.IsValid)
            {
                db.HRMS_EMP_CITIZENSHIP_MS.Add(hRMS_EMP_CITIZENSHIP_MS);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(hRMS_EMP_CITIZENSHIP_MS));
        }
        public ActionResult Create([Bind(Include = "Travel_Other_Details_ID,Travel_Other_Details_NM")] HRMS_TRAVEL_OTHER_DETAILS_MS hRMS_TRAVEL_OTHER_DETAILS_MS)
        {
            if (ModelState.IsValid)
            {
                db.HRMS_TRAVEL_OTHER_DETAILS_MS.Add(hRMS_TRAVEL_OTHER_DETAILS_MS);
                db.SaveChanges(); ModelState.Clear();

                return(RedirectToAction("Index"));
            }

            return(View(hRMS_TRAVEL_OTHER_DETAILS_MS));
        }
예제 #23
0
        public ActionResult Create([Bind(Include = "Meal_Expense_ID,Meal_Expense_NM,Meal_Expense_Status")] HRMS_TRAVEL_MEAL_EXPENSE_MS hRMS_TRAVEL_MEAL_EXPENSE_MS)
        {
            if (ModelState.IsValid)
            {
                db.HRMS_TRAVEL_MEAL_EXPENSE_MS.Add(hRMS_TRAVEL_MEAL_EXPENSE_MS);
                db.SaveChanges();
                ModelState.Clear();
                return(RedirectToAction("Index"));
            }

            return(View(hRMS_TRAVEL_MEAL_EXPENSE_MS));
        }
예제 #24
0
        public JsonResult AddFacultyy(string facid, string proid)
        {
            db.Configuration.ProxyCreationEnabled = false;

            //adding into table
            long fac_id = Convert.ToInt64(facid);
            long pro_id = Convert.ToInt64(proid);

            bool IsExist = db.HRMS_ProgramFaculty.Any(x => x.ProgramID == pro_id && x.FacultyID == fac_id);

            if (!IsExist)
            {
                HRMS_Faculty_MS obj = db.HRMS_Faculty_MS.Where(x => x.ID == fac_id).FirstOrDefault();

                HRMS_ProgramFaculty obj1 = new HRMS_ProgramFaculty();
                obj1.FacultyID   = fac_id;
                obj1.FacultyName = obj.External_Name;
                obj1.Email       = obj.Email;
                obj1.ProgramID   = pro_id;

                db.HRMS_ProgramFaculty.Add(obj1);
                db.SaveChanges();


                //List<HRMS_ProgramFaculty> FacList = db.HRMS_ProgramFaculty.Where(x => x.ProgramID == pro_id).ToList();
                var FacList = pro_id;
                return(Json(FacList, JsonRequestBehavior.AllowGet));
            }
            else
            {
                var FacList = "Faculty Already Exist!";
                return(Json(FacList, JsonRequestBehavior.AllowGet));
            }
        }
예제 #25
0
        public ActionResult Create(HRMS_EMP_BUSINESSDIVISION_MS hRMS_EMP_BUSINESSDIVISION_MS)
        {
            ViewBag.message = "";

            HRMS_EMP_BUSINESSDIVISION_MS hebd = new HRMS_EMP_BUSINESSDIVISION_MS();
            string BD_name1    = Request["BD_name"];
            string BD_sapcode1 = (Request["BD_sapcode"]);

            if (BD_name1 != null && BD_name1 != "" && BD_sapcode1 != "" && BD_sapcode1 != null)
            {
                string BD_name    = Request["BD_name"];
                long   BD_sapcode = Convert.ToInt64(Request["BD_sapcode"]);
                if (db.HRMS_EMP_BUSINESSDIVISION_MS.Where(rec => rec.BusinessDivision_Name == BD_name && rec.BusinessDivision_SapCode == BD_sapcode).Any())
                {
                    ViewBag.message = "SAPCODE for this BUSINESS DIVISION Already Exist !!!!!";
                    return(View(hRMS_EMP_BUSINESSDIVISION_MS));
                }
                else
                {
                    if (db.HRMS_EMP_BUSINESSDIVISION_MS.Where(rec => rec.BusinessDivision_Name == BD_name).Any())
                    {
                        ViewBag.message = "BUSINESS DIVISION Already Exist !!!!!";

                        return(View(hRMS_EMP_BUSINESSDIVISION_MS));
                    }
                    else if (db.HRMS_EMP_BUSINESSDIVISION_MS.Where(rec => rec.BusinessDivision_SapCode == BD_sapcode).Any())
                    {
                        ViewBag.message = "SAP CODE Already allocated !!!!!";

                        return(View(hRMS_EMP_BUSINESSDIVISION_MS));
                    }
                    else
                    {
                        hebd.BusinessDivision_Name    = BD_name;
                        hebd.BusinessDivision_SapCode = BD_sapcode;
                        db.HRMS_EMP_BUSINESSDIVISION_MS.Add(hebd);
                        db.SaveChanges(); ModelState.Clear();

                        return(RedirectToAction("Index"));
                    }
                }
            }
            else
            {
                ViewBag.message = "please fill up all value !!!!!";
            }


            return(View());
        }
예제 #26
0
        public ActionResult _New(Branch branch)
        {
            string msg = "";

            sess = (Session_CRM)Session["CRM_Session"];
            var UserID = sess.User.UserID;

            if (branch.BranchID == 0 || branch.BranchID == null)
            {
                Branch _branch = new Branch();
                _branch.Name       = branch.Name;
                _branch.CreatedBy  = UserID;
                _branch.CreateDate = DateTime.Now;
                _branch.IsActive   = true;
                db.Branches.Add(_branch);
                db.SaveChanges();
            }
            else
            {
            }

            List <Branch> brnch = new List <Branch>();

            try
            {
                brnch = db.Branches.Where(x => x.IsActive == true).ToList();
            }
            catch (Exception ex)
            {
                err.WriteError(ex);
            }
            return(PartialView("_Index", brnch));
        }
예제 #27
0
        public ActionResult Save(AT_Pages peg)
        {
            string msg = "";

            try
            {
                Session_CRM sess = (Session_CRM)Session["CRM_Session"];
                if (peg.PageID > 0)
                {
                    db.AT_Pages.Attach(peg);
                    db.UpdateExcept <AT_Pages>(peg);
                }
                else
                {
                    db.Entry(peg).State = System.Data.Entity.EntityState.Added;
                }
                db.SaveChanges();
                msg = "Page saved successfully!";
            }
            catch (Exception ex)
            {
                msg = ex.Message;
            }
            ViewBag.msg = msg;
            db          = new HRMSEntities();
            return(PartialView("_Index", db.AT_Pages.ToList()));
        }
        public ActionResult Create([Bind(Include = "Emp_ID,Emp_Cd,Old_Emp_Cd,Join_Date,Card_Id,salutation,First_Name,Middle_Name,Last_Name,Display_Name,Designation,Work_Location,Unit,Department,Cost_Center,UAN_No_")] HRMS_Emp_Details hRMS_Emp_Details)
        {
            if (ModelState.IsValid)
            {
                db.HRMS_Emp_Details.Add(hRMS_Emp_Details);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.Cost_Center   = new SelectList(db.HRMS_COST_CENTER, "ID", "Cost_Cntr_Name", hRMS_Emp_Details.Cost_Center);
            ViewBag.Department    = new SelectList(db.HRMS_DEPT, "Dept_Id", "Dept_Name", hRMS_Emp_Details.Department);
            ViewBag.Designation   = new SelectList(db.HRMS_EMP_DESIGNATION_MS, "Designation_ID", "Designation_Parent", hRMS_Emp_Details.Designation);
            ViewBag.salutation    = new SelectList(db.HRMS_SALUTATION, "Salutation_ID", "Salutation_Name", hRMS_Emp_Details.salutation);
            ViewBag.Unit          = new SelectList(db.UnitMasters, "UnitCode", "UnitName", hRMS_Emp_Details.Unit);
            ViewBag.Work_Location = new SelectList(db.WorkLocationMasters, "WorkID", "WorkLocationName", hRMS_Emp_Details.Work_Location);
            return(View(hRMS_Emp_Details));
        }
        public ActionResult Create([Bind(Include = "ID,Gender,DOB,Category,IdentityMark1,IdentityMark2,Religion,Citizenship,Caste,Race,MarraigeStatus,MarraigeDate,NoOfChild,NoOfDependents,AadharNo,SIN,AKA,MilitaryService,BirthCity,Note,Hobbies,MilitaryServiceDetail,EmployeeID")] Employee_Personal_Detail employee_Personal_Detail)
        {
            if (ModelState.IsValid)
            {
                db.Employee_Personal_Detail.Add(employee_Personal_Detail);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.Caste          = new SelectList(db.CastMasters, "CastCode", "CastName", employee_Personal_Detail.Caste);
            ViewBag.Category       = new SelectList(db.HRMS_CATEGORY_GRADE, "Category_ID", "Category_Name", employee_Personal_Detail.Category);
            ViewBag.Citizenship    = new SelectList(db.HRMS_EMP_CITIZENSHIP_MS, "CitizenShip_ID", "CitizenShip_Country_NM", employee_Personal_Detail.Citizenship);
            ViewBag.Gender         = new SelectList(db.HRMS_EMP_GENDER_MS, "Gender_ID", "Gender_Value", employee_Personal_Detail.Gender);
            ViewBag.MarraigeStatus = new SelectList(db.MaritalMasters, "MaritalID", "MaritalName", employee_Personal_Detail.MarraigeStatus);
            ViewBag.Religion       = new SelectList(db.ReligionMasters, "ReligionID", "ReligionShortName", employee_Personal_Detail.Religion);
            return(View(employee_Personal_Detail));
        }
예제 #30
0
        public ActionResult Create([Bind(Include = "ApplicationId,request_date,EmpID,designationID,DepartmentId,Training_Name,TrainingDetails,ApprovedDate,Status,ApprovedBy_ID,Approved_Remarks,Skill")] HRMS_Training_Request_Application hRMS_Training_Request_Application)
        {
            long             emp_id         = Convert.ToInt64(Session["id"]);
            HRMS_Emp_Details employeedetail = db.HRMS_Emp_Details.Where(rec => rec.EMP_ID == emp_id).FirstOrDefault();

            hRMS_Training_Request_Application.EmployeeName  = employeedetail.Display_Name;
            hRMS_Training_Request_Application.designationID = employeedetail.Designation;
            hRMS_Training_Request_Application.DepartmentId  = employeedetail.Department;

            if (ModelState.IsValid)
            {
                var existTrainingName = db.HRMS_Training_Request_Application.Where(rec => rec.Training_Name == hRMS_Training_Request_Application.Training_Name && rec.EmpID == hRMS_Training_Request_Application.EmpID).FirstOrDefault();
                if (existTrainingName == null)
                {
                    hRMS_Training_Request_Application.Status = 0;

                    db.HRMS_Training_Request_Application.Add(hRMS_Training_Request_Application);
                    db.SaveChanges();
                    ViewBag.RequestStatus = "Training Request is Added successfully.";
                    ViewBag.Department    = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
                    ViewBag.Designation   = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
                    ViewBag.Skill         = new SelectList(db.HRMS_TRAINING_SKILL_MS, "Skill_ID", "Skill_Name");
                    return(View());
                }
                else
                {
                    ViewBag.RequestStatus = "This Training Request is already exist!";
                    ViewBag.Department    = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
                    ViewBag.Designation   = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
                    ViewBag.Skill         = new SelectList(db.HRMS_TRAINING_SKILL_MS, "Skill_ID", "Skill_Name");
                    return(View());
                }
            }

            //ViewBag.EmpID = new SelectList(db.Accounts, "ID", "UserName", hRMS_Training_Request_Application.EmpID);
            //ViewBag.ApprovedBy_ID = new SelectList(db.Accounts, "ID", "UserName", hRMS_Training_Request_Application.ApprovedBy_ID);
            //ViewBag.DepartmentId = new SelectList(db.HRMS_DEPT, "Dept_Id", "Dept_Name", hRMS_Training_Request_Application.DepartmentId);
            //ViewBag.designationID = new SelectList(db.HRMS_DESG_MS, "Desg_Id", "Desg_Name", hRMS_Training_Request_Application.designationID);
            //ViewBag.Skill = new SelectList(db.HRMS_TRAINING_SKILL_MS, "Skill_ID", "Skill_Name", hRMS_Training_Request_Application.Skill);
            ViewBag.Department  = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
            ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
            ViewBag.Skill       = new SelectList(db.HRMS_TRAINING_SKILL_MS, "Skill_ID", "Skill_Name");
            return(View(hRMS_Training_Request_Application));
        }