Example #1
0
        public ActionResult Index()
        {
            HttpCookie myCookie = new HttpCookie("UInfo");

            myCookie = Request.Cookies["UInfo"];
            if (myCookie != null)
            {
                Hashtable hst = new Hashtable();
                objTools = new Utility();

                DataModel.DMLoginDetails DL = objTools.GetLoginDetails(myCookie.Value.ToString());
                ViewBag.Foto       = DL.Foto;
                ViewBag.UserName   = DL.FullName;
                ViewBag.Department = DL.DepartmentName;
                ViewBag.RolesName  = DL.RolesName;
                ViewBag.LastLogin  = Convert.ToDateTime(DL.LastLogin).ToString("dd MMM yyyy HH:mm:ss");
                hst.Add("@RoleID", Convert.ToInt16(DL.RoleID));
                ViewBag.TxtMenu = objTools.CreateMenu(hst, "[SP_T_SuperAdmin_Menu_Load]");
                return(View());
            }
            else
            {
                return(RedirectPermanent("/"));
            }
        }
Example #2
0
        public ActionResult Index()
        {
            HttpCookie myCookie = new HttpCookie("UInfo");

            myCookie = Request.Cookies["UInfo"];
            if (myCookie != null)
            {
                Hashtable hst = new Hashtable();
                objTools = new Utility();

                DataModel.DMUsersLoginDetails DL = objTools.GetClientLoginDetails(myCookie.Value.ToString());
                ViewBag.Foto     = DL.Foto;
                ViewBag.UserName = DL.FullName;
                ViewBag.ClientID = DL.ClientID;

                ViewBag.LastLogin = Convert.ToDateTime(DL.LastLogin).ToString("dd MMM yyyy HH:mm:ss");
                hst.Add("@ClientID", Convert.ToInt16(DL.ClientID));
                ViewBag.TxtMenu = objTools.CreateMenu(hst, "[SP_UsersMenuLoad]");

                DataModel.DMSearchField DY = new DataModel.DMSearchField();
                DY.MonthList = objTools.GetMonths();
                DY.YearList  = objTools.GetYears();

                return(View(DY));
            }
            else
            {
                return(RedirectPermanent("/"));
            }
        }
Example #3
0
        public ActionResult HolidaySearch(int Year, int Month)
        {
            HttpCookie myCookie = new HttpCookie("UInfo");

            myCookie = Request.Cookies["UInfo"];
            if (myCookie != null)
            {
                Hashtable        hst     = new Hashtable();
                List <DMHoliday> Holiday = new List <DMHoliday>();
                DataTable        dt      = new DataTable();
                DBA      = new DBClass();
                objTools = new Utility();


                DataModel.DMUsersLoginDetails DL = objTools.GetClientLoginDetails(myCookie.Value.ToString());
                hst.Add("@ClientID", Convert.ToInt16(DL.ClientID));
                hst.Add("@Year", Year);
                hst.Add("@Month", Month);
                dt      = DBA.GetDataTables("[SP_HolidayView]", hst);
                Holiday = dt.DataTableToList <DMHoliday>();


                return(PartialView("_Holiday", Holiday));
            }
            else
            {
                return(RedirectPermanent("/"));
            }
        }
Example #4
0
        public ActionResult UpdateWorkingHour(int TimeGroupID)
        {
            HttpCookie myCookie = new HttpCookie("UInfo");

            myCookie = Request.Cookies["UInfo"];
            if (myCookie != null)
            {
                try
                {
                    DBA      = new DBClass();
                    objTools = new Utility();
                    Hashtable hst = new Hashtable();
                    DataTable dt  = new DataTable();
                    List <DMNewWorkingHour>       Data = new List <DMNewWorkingHour>();
                    DataModel.DMUsersLoginDetails DL   = objTools.GetClientLoginDetails(myCookie.Value.ToString());
                    hst.Add("@TimeGroupID", TimeGroupID);
                    hst.Add("@UserName", DL.FullName);

                    dt   = DBA.GetDataTables("[SP_AttendanceTimeGroup_FActive]", hst);
                    Data = dt.DataTableToList <DMNewWorkingHour>();
                    return(PartialView("_WorkingTimeGroupList", Data));
                }
                catch (Exception ex)
                {
                    return(Json(new { isSuccess = false, msg = string.Format("Failed!<br/>" + ex.Message.ToString()), url = "/" }, JsonRequestBehavior.AllowGet));
                }
            }
            else
            {
                return(RedirectPermanent("/"));
            }
        }
Example #5
0
        public ActionResult WorkingTimeGroupSearch(DMSearchField data)
        {
            HttpCookie myCookie = new HttpCookie("UInfo");

            myCookie = Request.Cookies["UInfo"];
            if (myCookie != null)
            {
                try
                {
                    DBA      = new DBClass();
                    objTools = new Utility();
                    Hashtable hst = new Hashtable();
                    DataTable dt  = new DataTable();
                    List <DMNewWorkingHour>       Data = new List <DMNewWorkingHour>();
                    DataModel.DMUsersLoginDetails DL   = objTools.GetClientLoginDetails(myCookie.Value.ToString());
                    hst.Add("@ClientID", Convert.ToInt16(DL.ClientID));
                    hst.Add("@BranchID", data.Searching.Key2);
                    hst.Add("@Key", data.Searching.Key);
                    dt   = DBA.GetDataTables("[SP_AttendanceTimeGroup_View]", hst);
                    Data = dt.DataTableToList <DMNewWorkingHour>();
                    return(PartialView("_WorkingTimeGroupList", Data));
                }
                catch (Exception ex)
                {
                    return(Json(new { isSuccess = false, msg = string.Format("Failed!<br/>" + ex.Message.ToString()), url = "/" }, JsonRequestBehavior.AllowGet));
                }
            }
            else
            {
                return(RedirectPermanent("/"));
            }
        }
Example #6
0
        public ActionResult Index()
        {
            HttpCookie myCookie = new HttpCookie("UInfo");

            myCookie = Request.Cookies["UInfo"];
            if (myCookie != null)
            {
                Hashtable hst = new Hashtable();
                DBA      = new DBClass();
                objTools = new Utility();
                DataModel.DMLoginDetails DL = objTools.GetLoginDetails(myCookie.Value.ToString());
                hst.Add("@RoleID", Convert.ToInt16(DL.RoleID));
                ViewBag.TxtMenu = objTools.CreateMenu(hst, "[SP_T_SuperAdmin_Menu_Load]");

                ViewBag.Foto       = DL.Foto;
                ViewBag.UserName   = DL.FullName;
                ViewBag.Department = DL.DepartmentName;
                ViewBag.RolesName  = DL.RolesName;
                ViewBag.LastLogin  = Convert.ToDateTime(DL.LastLogin).ToString("dd MMM yyyy hh:mm:ss");
                List <DataModel.DMClientMaster> CLList = new List <DataModel.DMClientMaster>();
                HttpContext.Cache.Insert("ChaceClientList", CLList, null, Cache.NoAbsoluteExpiration, new TimeSpan(0, 30, 0));

                return(View());
            }
            else
            {
                return(RedirectPermanent("/SuperAdmin/Default/"));
            }
        }
Example #7
0
        public ActionResult NewCustomer(int id = 0)
        {
            HttpCookie myCookie = new HttpCookie("UInfo");

            myCookie = Request.Cookies["UInfo"];
            if (myCookie != null)
            {
                Hashtable hst = new Hashtable();
                objTools = new Utility();

                DataModel.DMUsersLoginDetails DL = objTools.GetClientLoginDetails(myCookie.Value.ToString());
                ViewBag.Foto     = DL.Foto;
                ViewBag.UserName = DL.FullName;
                ViewBag.ClientID = DL.ClientID;

                ViewBag.LastLogin = Convert.ToDateTime(DL.LastLogin).ToString("dd MMM yyyy HH:mm:ss");
                hst.Add("@ClientID", Convert.ToInt16(DL.ClientID));
                ViewBag.TxtMenu = objTools.CreateMenu(hst, "[SP_UsersMenuLoad]");

                ViewBag.Foto      = DL.Foto;
                ViewBag.UserName  = DL.FullName;
                ViewBag.LastLogin = Convert.ToDateTime(DL.LastLogin).ToString("dd MMM yyyy hh:mm:ss");

                hst.Clear();
                DataModel.DMUserNewCustomerInsert DNC    = new DataModel.DMUserNewCustomerInsert();
                DataModel.DMUsersNewCustomer      DC     = new DataModel.DMUsersNewCustomer();
                List <DataModel.DMEnum>           IDType = objTools.GetEnum("ID Type");
                if (id != 0)
                {
                    DBA = new DBClass();

                    DataTable dt = new DataTable();
                    hst.Clear();
                    hst.Add("@ClientID", DL.ClientID);
                    hst.Add("@ID", id);
                    dt = DBA.GetDataTables("[SP_UsersCustomerDetails]", hst);
                    for (var i = 0; i <= dt.Rows.Count - 1; i++)
                    {
                        DC.CompanyName   = dt.Rows[i]["CompanyName"].ToString();
                        DC.Address       = dt.Rows[i]["Address1"].ToString();
                        DC.City          = dt.Rows[i]["City"].ToString();
                        DC.Province      = dt.Rows[i]["StateProvince"].ToString();
                        DC.ZIP           = dt.Rows[i]["ZipCode"].ToString();
                        DC.Phone         = dt.Rows[i]["Phone"].ToString();
                        DC.NPWP          = dt.Rows[i]["NPWP"].ToString();
                        DC.ContactPerson = dt.Rows[i]["ContactPerson"].ToString();
                    }
                }
                DNC.NewCustomer = DC;
                DNC.IDType      = IDType;

                return(View(DNC));
            }
            else
            {
                return(RedirectPermanent("/"));
            }
        }
Example #8
0
        public ActionResult EDShiftGroup(int ShiftID, int BranchID = 0)
        {
            HttpCookie myCookie = new HttpCookie("UInfo");

            myCookie = Request.Cookies["UInfo"];
            if (myCookie != null)
            {
                try
                {
                    DBA      = new DBClass();
                    objTools = new Utility();
                    Hashtable                  hst          = new Hashtable();
                    DataTable                  dt           = new DataTable();
                    DMGroupShiftList           Data         = new DMGroupShiftList();
                    List <DMGroupShiftHeader>  ShiftHeader  = new List <DMGroupShiftHeader>();
                    List <DMGroupShiftDetails> ShiftDetails = new List <DMGroupShiftDetails>();

                    DataModel.DMUsersLoginDetails DL = objTools.GetClientLoginDetails(myCookie.Value.ToString());
                    hst.Add("@ShiftID", ShiftID);
                    hst.Add("@UserName", DL.FullName);

                    DBA.ExecSP("[SP_AttendanceShiftGroup_FActive]", hst);

                    hst.Clear();
                    hst.Add("@ClientID", Convert.ToInt16(DL.ClientID));
                    hst.Add("@BranchID", BranchID);
                    hst.Add("@Key", String.Empty);
                    dt          = DBA.GetDataTables("[SP_AttendanceShiftGroupHeader_View]", hst);
                    ShiftHeader = dt.DataTableToList <DMGroupShiftHeader>();
                    dt.Clear();
                    hst.Clear();
                    for (int i = 0; i <= ShiftHeader.Count - 1; i++)
                    {
                        hst.Clear();
                        hst.Add("@ShiftID", ShiftHeader[i].ID);
                        dt = DBA.GetDataTables("[SP_AttendanceShiftGroupDetails_View]", hst);
                        for (int y = 0; y <= dt.Rows.Count - 1; y++)
                        {
                            ShiftDetails.Add(new DMGroupShiftDetails {
                                ShiftID = Convert.ToInt32(dt.Rows[y][0].ToString()), WorkingHourID = Convert.ToInt32(dt.Rows[y][1].ToString()), WorkingDay = Convert.ToInt32(dt.Rows[y][2].ToString()), OffDay = Convert.ToInt32(dt.Rows[y][3].ToString()), CurrentIn = Convert.ToDateTime(dt.Rows[y][4].ToString()), CurrentOut = Convert.ToDateTime(dt.Rows[y][5].ToString())
                            });
                        }
                    }
                    Data.GroupShiftHeader  = ShiftHeader;
                    Data.GroupShiftDetails = ShiftDetails;

                    return(PartialView("_GroupShiftList", Data));
                }
                catch (Exception ex)
                {
                    return(Json(new { isSuccess = false, msg = string.Format("Failed!<br/>" + ex.Message.ToString()), url = "/" }, JsonRequestBehavior.AllowGet));
                }
            }
            else
            {
                return(RedirectPermanent("/"));
            }
        }
Example #9
0
        public ActionResult NewGroupShift(int BranchID = 0)
        {
            HttpCookie myCookie = new HttpCookie("UInfo");

            myCookie = Request.Cookies["UInfo"];
            if (myCookie != null)
            {
                try {
                    objTools = new Utility();
                    DataModel.DMUsersLoginDetails DL = objTools.GetClientLoginDetails(myCookie.Value.ToString());
                    List <DMGroupShiftDetails>    ChaceGroupShift = HttpContext.Cache["ChaceGroupShift"] as List <DMGroupShiftDetails>;


                    DMGroupShiftInsert         AddNew            = new DMGroupShiftInsert();
                    List <DMNewWorkingHour>    TimeGroup         = new List <DMNewWorkingHour>();
                    List <DMGroupShiftDetails> GroupShiftDetails = new List <DMGroupShiftDetails>();
                    DMGroupShiftHeader         GroupShiftHeader  = new DMGroupShiftHeader();
                    DataTable Dt  = new DataTable();
                    Hashtable hst = new Hashtable();
                    DBA = new DBClass();

                    hst.Add("@ClientID", Convert.ToInt16(DL.ClientID));
                    hst.Add("@BranchID", Convert.ToInt16(DL.BranchID));
                    Dt        = DBA.GetDataTables("[SP_AttendanceTimeGroupToCombo]", hst);
                    TimeGroup = Dt.DataTableToList <DMNewWorkingHour>();
                    HttpContext.Cache.Insert("ChaceGroupShift", GroupShiftDetails, null, Cache.NoAbsoluteExpiration, new TimeSpan(0, 30, 0));
                    GroupShiftDetails.Add(new DMGroupShiftDetails {
                        OffDay = 0, WorkingDay = 0, WorkingHourID = 0, ID = 1
                    });
                    HttpContext.Cache.Insert("ChaceGroupShift", GroupShiftDetails, null, Cache.NoAbsoluteExpiration, new TimeSpan(0, 30, 0));
                    AddNew.TimeGroup         = TimeGroup;
                    AddNew.GroupShiftDetails = GroupShiftDetails;

                    if (BranchID == 0)
                    {
                        GroupShiftHeader.BranchName = "All Branch";
                    }
                    GroupShiftHeader.BranchID = BranchID;
                    AddNew.GroupShiftHeader   = GroupShiftHeader;
                    return(PartialView("_GroupShiftNew", AddNew));
                } catch {
                    return(PartialView("_GroupShiftNew"));
                }
            }
            else
            {
                return(RedirectPermanent("/"));
            }
        }
Example #10
0
        public ActionResult NewClient()
        {
            HttpCookie myCookie = new HttpCookie("UInfo");

            myCookie = Request.Cookies["UInfo"];
            if (myCookie != null)
            {
                Hashtable hst = new Hashtable();
                DBA      = new DBClass();
                objTools = new Utility();
                DataModel.DMLoginDetails DL = objTools.GetLoginDetails(myCookie.Value.ToString());
                hst.Add("@RoleID", Convert.ToInt16(DL.RoleID));
                ViewBag.TxtMenu = objTools.CreateMenu(hst, "[SP_T_SuperAdmin_Menu_Load]");

                ViewBag.Foto       = DL.Foto;
                ViewBag.UserName   = DL.FullName;
                ViewBag.Department = DL.DepartmentName;
                ViewBag.RolesName  = DL.RolesName;
                ViewBag.LastLogin  = Convert.ToDateTime(DL.LastLogin).ToString("dd MMM yyyy hh:mm:ss");

                hst.Clear();
                DataModel.DMInsertNewClient DNC          = new DataModel.DMInsertNewClient();
                List <DataModel.DMEnum>     DE           = objTools.GetEnum("Types of business");
                List <DataModel.DMEnum>     EMPSize      = objTools.GetEnum("Employee Size");
                List <DataModel.DMEnum>     IDType       = objTools.GetEnum("ID Type");
                List <DataModel.DMEnum>     BillingCycle = objTools.GetEnum("Billing Cycle");
                List <DataModel.DMEnum>     Products     = objTools.GetProducts();

                DNC.TOB          = DE;
                DNC.EMPSize      = EMPSize;
                DNC.IDType       = IDType;
                DNC.BillingCylce = BillingCycle;
                DNC.Products     = Products;



                return(View(DNC));
            }
            else
            {
                return(RedirectPermanent("/SuperAdmin/Default/"));
            }
        }
Example #11
0
        public ActionResult SaveNewWorkingHour(DMNewWorkingHour data)
        {
            HttpCookie myCookie = new HttpCookie("UInfo");

            myCookie = Request.Cookies["UInfo"];
            if (myCookie != null)
            {
                try
                {
                    DBA      = new DBClass();
                    objTools = new Utility();
                    Hashtable hst = new Hashtable();
                    DataModel.DMUsersLoginDetails DL = objTools.GetClientLoginDetails(myCookie.Value.ToString());


                    hst.Add("@ClientID", Convert.ToInt16(DL.ClientID));
                    hst.Add("@BranchID", data.Branch);
                    hst.Add("@TimeGroupName", data.TimeGroupName);
                    hst.Add("@CurrentIn", data.CurrentIn);
                    hst.Add("@MaxIn", data.MaxIn);
                    hst.Add("@MinIn", data.MinIn);
                    hst.Add("@CurrentOut", data.CurrentOut);
                    hst.Add("@MaxOut", data.MaxOut);
                    hst.Add("@MinOut", data.MinOut);
                    hst.Add("@UserName", DL.FullName);

                    DBA.ExecSP("[SP_AttendanceTimeGroup_Insert]", hst);
                    return(Json(new { isSuccess = true, msg = string.Format("Save") }, JsonRequestBehavior.AllowGet));
                }
                catch (Exception ex)
                {
                    return(Json(new { isSuccess = false, msg = string.Format("Failed!" + ex.Message.ToString()), url = "/" }, JsonRequestBehavior.AllowGet));
                }
            }
            else
            {
                return(RedirectPermanent("/"));
            }
        }
Example #12
0
        public ActionResult CustomerSearch(DataModel.DMSearchField data)
        {
            HttpCookie myCookie = new HttpCookie("UInfo");

            myCookie = Request.Cookies["UInfo"];
            if (myCookie != null)
            {
                objTools = new Utility();
                DBA      = new DBClass();
                DataModel.DMUsersLoginDetails DL = objTools.GetClientLoginDetails(myCookie.Value.ToString());


                List <DataModel.DMUserCustomerList> CList = new List <DataModel.DMUserCustomerList>();
                DataTable Dt  = new DataTable();
                Hashtable hst = new Hashtable();
                hst.Add("@Key", data.Searching.Key);
                hst.Add("@ClientID", DL.ClientID);
                //hst.Add("@Month", data.Month);
                //hst.Add("@Years", data.Year);
                Dt = DBA.GetDataTables("[SP_UsersCustomerLoad]", hst);
                if (Dt.Rows.Count > 0)
                {
                    CList = Dt.DataTableToList <DataModel.DMUserCustomerList>();

                    return(PartialView("_CustomerList", CList));
                }
                else
                {
                    return(Json(new { isSuccess = false, msg = string.Format("No Record(s) found") }, JsonRequestBehavior.AllowGet));
                }
            }
            else
            {
                return(RedirectPermanent("/"));
            }
        }
Example #13
0
        public ActionResult AddNewCustomer(DataModel.DMUserNewCustomerInsert data, HttpPostedFileBase npwpimg, HttpPostedFileBase idimage)
        {
            HttpCookie myCookie = new HttpCookie("UInfo");

            myCookie = Request.Cookies["UInfo"];
            DBA      = new DBClass();
            objTools = new Utility();


            if (myCookie != null)
            {
                try
                {
                    if (ModelState.IsValid == false)
                    {
                        return(Json(new { isSuccess = false, msg = string.Format("Please Fill Out All Data") }, JsonRequestBehavior.AllowGet));
                    }
                    DataModel.DMUsersLoginDetails DL = objTools.GetClientLoginDetails(myCookie.Value.ToString());


                    Hashtable hst = new Hashtable();
                    hst.Add("@CompanyName", data.NewCustomer.CompanyName);
                    hst.Add("@Address", data.NewCustomer.Address);
                    hst.Add("@City", data.NewCustomer.City);
                    hst.Add("@Province", data.NewCustomer.Province);
                    hst.Add("@Country", string.Empty);
                    hst.Add("@Phone", data.NewCustomer.Phone);
                    hst.Add("@ZIP", data.NewCustomer.ZIP);
                    // hst.Add("@Fax", data.DC.FAX);
                    hst.Add("@NPWP", data.NewCustomer.NPWP);


                    hst.Add("@ContactPerson", data.NewCustomer.ContactPerson);
                    hst.Add("@CAddress", data.NewCustomer.CAddress);
                    hst.Add("@CCity", data.NewCustomer.CCity);
                    hst.Add("@CProvince", data.NewCustomer.CProvince);
                    hst.Add("@CZIP", data.NewCustomer.CZip);
                    hst.Add("@IDType", data.NewCustomer.IDType);
                    hst.Add("@IDNumber", data.NewCustomer.IDNumber);
                    hst.Add("@MobilePhone", data.NewCustomer.MobilePhone);
                    hst.Add("@EMail", data.NewCustomer.Email);
                    hst.Add("@UserName", DL.FullName);
                    hst.Add("@ClientID", DL.ClientID);

                    //string CID = objTools.SaveClient(hst, ST, SC);
                    bool exists = System.IO.Directory.Exists(Server.MapPath("~/Users-Documents/" + DL.ClientID + "/"));
                    if (!exists)
                    {
                        System.IO.Directory.CreateDirectory(Server.MapPath("~/Users-Documents/" + DL.ClientID + "/"));
                    }


                    if (npwpimg != null && npwpimg.ContentLength > 0)
                    {
                        var fileName = Path.GetFileName(npwpimg.FileName);
                        var path     = Path.Combine(Server.MapPath("~/Users-Documents/" + DL.ClientID + "/"), fileName);
                        npwpimg.SaveAs(path);
                        hst.Add("@NPWPPic", fileName);
                    }
                    else
                    {
                        hst.Add("@NPWPPic", string.Empty);
                    }
                    if (idimage != null && idimage.ContentLength > 0)
                    {
                        var fileName = Path.GetFileName(idimage.FileName);
                        var path     = Path.Combine(Server.MapPath("~/Users-Documents/" + DL.ClientID + "/"), fileName);
                        idimage.SaveAs(path);
                        hst.Add("@CustIDPIC", fileName);
                    }
                    else
                    {
                        hst.Add("@CustIDPIC", string.Empty);
                    }

                    DBA.ExecSP("[SP_UsersCustomerInsert]", hst);
                    DBA.CommitTransaction();



                    return(Json(new { isSuccess = true, url = "/Users/Customer/" }, JsonRequestBehavior.AllowGet));
                }
                catch (Exception ex)
                {
                    DBA.RollBackTransaction();
                    return(Json(new { isSuccess = false, msg = string.Format(ex.Message.ToString()) }, JsonRequestBehavior.AllowGet));
                }
            }
            else
            {
                return(RedirectPermanent("/"));
            }
        }
Example #14
0
        public ActionResult AddGroupShiftRow(DMGroupShiftInsert data, string submitButton)
        {
            HttpCookie myCookie = new HttpCookie("UInfo");

            myCookie = Request.Cookies["UInfo"];
            List <DMGroupShiftDetails> ChaceGroupShift  = HttpContext.Cache["ChaceGroupShift"] as List <DMGroupShiftDetails>;
            DMGroupShiftDetails        GroupShift       = new DMGroupShiftDetails();
            DMGroupShiftHeader         GroupShiftHeader = new DMGroupShiftHeader();
            DMGroupShiftInsert         GroupShiftInsert = new DMGroupShiftInsert();
            List <DMNewWorkingHour>    TimeGroup        = new List <DMNewWorkingHour>();

            DBA = new DBClass();

            DataTable Dt  = new DataTable();
            Hashtable hst = new Hashtable();

            if (myCookie != null)
            {
                switch (submitButton)
                {
                case "AddRow":

                    bool Addrow = false;
                    objTools = new Utility();
                    DMUsersLoginDetails DL = objTools.GetClientLoginDetails(myCookie.Value.ToString());

                    ViewBag.BranchID   = data.GroupShiftHeader.BranchID;
                    ViewBag.BranchName = data.GroupShiftHeader.BranchName;
                    hst.Add("@ClientID", Convert.ToInt16(DL.ClientID));
                    hst.Add("@BranchID", Convert.ToInt16(DL.BranchID));
                    Dt        = DBA.GetDataTables("[SP_AttendanceTimeGroupToCombo]", hst);
                    TimeGroup = Dt.DataTableToList <DMNewWorkingHour>();

                    GroupShiftInsert.TimeGroup = TimeGroup;

                    GroupShiftHeader.BranchName    = data.GroupShiftHeader.BranchName;
                    GroupShiftHeader.BranchID      = data.GroupShiftHeader.BranchID;
                    GroupShiftHeader.ClientID      = data.GroupShiftHeader.ClientID;
                    GroupShiftHeader.EffectiveDate = data.GroupShiftHeader.EffectiveDate;
                    GroupShiftHeader.ID            = data.GroupShiftHeader.ID;
                    GroupShiftHeader.ShiftName     = data.GroupShiftHeader.ShiftName;

                    foreach (DMGroupShiftDetails DI in data.GroupShiftDetails)
                    {
                        Addrow = false;
                        if (DI.ID != 0 && DI.WorkingHourID != 0)
                        {
                            Addrow = true;
                            var CI = ChaceGroupShift.FirstOrDefault(x => x.ID == DI.ID);
                            CI.WorkingHourID = DI.WorkingHourID;
                            CI.WorkingDay    = DI.WorkingDay;
                            CI.OffDay        = DI.OffDay;
                        }
                    }

                    if (Addrow == true)
                    {
                        DMGroupShiftDetails ShiftDetails = new DMGroupShiftDetails();
                        ShiftDetails.ID            = ChaceGroupShift.Count() + 1;
                        ShiftDetails.WorkingHourID = 0;
                        ShiftDetails.WorkingDay    = 0;
                        ShiftDetails.OffDay        = 0;
                        ChaceGroupShift.Add(ShiftDetails);
                    }

                    GroupShiftInsert.GroupShiftDetails = ChaceGroupShift;
                    GroupShiftInsert.GroupShiftHeader  = GroupShiftHeader;
                    HttpContext.Cache.Insert("ChaceGroupShift", ChaceGroupShift, null, Cache.NoAbsoluteExpiration, new TimeSpan(0, 30, 0));
                    return(PartialView("_GroupShiftNew", GroupShiftInsert));

                case "Save":
                    objTools = new Utility();
                    DBA      = new DBClass();
                    DMUsersLoginDetails DLD = objTools.GetClientLoginDetails(myCookie.Value.ToString());
                    hst.Clear();
                    hst.Add("@ClientID", Convert.ToInt16(DLD.ClientID));
                    hst.Add("@BranchID", Convert.ToInt16(DLD.BranchID));
                    hst.Add("@ShiftName", data.GroupShiftHeader.ShiftName);
                    hst.Add("@EfectiveDate", data.GroupShiftHeader.EffectiveDate);
                    hst.Add("@UserName", DLD.FullName);
                    string NewID = "0";
                    NewID = DBA.GetVals("[SP_AttendanceShiftGroup_Insert]", hst);
                    foreach (DMGroupShiftDetails DD in data.GroupShiftDetails)
                    {
                        hst.Clear();
                        hst.Add("@ShiftID", Convert.ToInt64(NewID));
                        hst.Add("@WorkingTimeID", DD.WorkingHourID);
                        hst.Add("@WorkingDays", DD.WorkingDay);
                        hst.Add("@OffDays", DD.OffDay);
                        DBA.ExecSP("[SP_AttendanceShiftGroupDetails_Insert]", hst);
                    }
                    return(RedirectPermanent("/Users/HR/GroupShift"));
                }
                return(View());
            }
            else
            {
                return(RedirectPermanent("/"));
            }
        }