示例#1
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("/"));
            }
        }
示例#2
0
        public ActionResult Invoice()
        {
            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]");

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

                return(View(DY));
            }
            else
            {
                return(RedirectPermanent("/"));
            }
        }
示例#3
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("/"));
            }
        }
示例#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("/"));
            }
        }
示例#5
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("/"));
            }
        }
示例#6
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("/"));
            }
        }
示例#7
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("/"));
            }
        }
示例#8
0
        public ActionResult InvoiceSearch(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.DMInvoiceList> InvList = new List <DMInvoiceList>();
                DataTable Dt  = new DataTable();
                Hashtable hst = new Hashtable();
                hst.Add("@Key", data.Searching.Key);
                hst.Add("@ClientID", DL.ClientID);
                hst.Add("@Month", data.Searching.Month);
                hst.Add("@Years", data.Searching.Year);
                Dt = DBA.GetDataTables("[SP_UsersInvoiceLoad]", hst);
                if (Dt.Rows.Count > 0)
                {
                    InvList = Dt.DataTableToList <DMInvoiceList>();

                    return(PartialView("_InvoiceList", InvList));
                }
                else
                {
                    return(Json(new { isSuccess = false, msg = string.Format("No Record(s) found") }, JsonRequestBehavior.AllowGet));
                }
            }
            else
            {
                return(RedirectPermanent("/"));
            }
        }
示例#9
0
        public ActionResult NewInvoice(int CustID = 0, string InvNo = "")
        {
            DMClientCustomerToInvoice DC = new DMClientCustomerToInvoice();

            List <DataModel.DMNewInvoice> ChaceInvoice = new List <DataModel.DMNewInvoice>();

            HttpContext.Cache.Insert("ChaceInvoice", ChaceInvoice, null, Cache.NoAbsoluteExpiration, new TimeSpan(0, 0, 0));

            DMCreateNewInvoice DCI = new DMCreateNewInvoice();

            DataModel.DMNewInvoice INV      = new DMNewInvoice();
            List <DMNewInvoice>    DI       = new List <DMNewInvoice>();
            HttpCookie             myCookie = new HttpCookie("UInfo");

            myCookie = Request.Cookies["UInfo"];
            if (myCookie != null)
            {
                INV.NoID  = 1;
                INV.Qty   = 1;
                INV.Price = 0;
                INV.Total = 0;
                DI.Add(INV);
                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]");

                var t = AddItemInvoice(DI);
                ViewBag.Total = CountTotal(t);
                DCI.ListDI    = DI;

                if (CustID > 0)
                {
                    DataTable dt = new DataTable();


                    DBA = new DBClass();
                    hst.Add("@ClientID", DL.ClientID);
                    hst.Add("@ID", CustID);
                    dt = DBA.GetDataTables("[SP_UsersCustomerDetails]", hst);
                    for (var i = 0; i <= dt.Rows.Count - 1; i++)
                    {
                        DC.ClientID      = DL.ClientID;
                        DC.ContactPerson = dt.Rows[i]["ContactPerson"].ToString();
                        DCI.NC           = DC;
                    }
                }
                else
                {
                    DCI.NC = DC;
                }

                return(View(DCI));
            }
            else
            {
                return(RedirectPermanent("/"));
            }
        }