Exemple #1
0
        public JsonResult GetAllTicket(string BranchID, int?Role, int RowsPerPage, int PageNumber
                                       , string TicketID, string FromDate, string ToDate, int?StatusIDF, string OrderByColumnName, string OrderBy, int ReasonIDF)
        {
            MEMBERS.PagingResponse data = new ADMHeaderLogic().ADMHeader_Dashboard(BranchID
                                                                                   , Role
                                                                                   , RowsPerPage
                                                                                   , PageNumber
                                                                                   , TicketID
                                                                                   , FromDate
                                                                                   , ToDate
                                                                                   , StatusIDF
                                                                                   , OrderByColumnName
                                                                                   , OrderBy
                                                                                   , ReasonIDF);

            /*Call Again For Excel*/
            MEMBERS.PagingResponse AuditData = new ADMHeaderLogic().ADMHeader_Dashboard(BranchID
                                                                                        , Role
                                                                                        , 0
                                                                                        , 0
                                                                                        , TicketID
                                                                                        , FromDate
                                                                                        , ToDate
                                                                                        , StatusIDF
                                                                                        , OrderByColumnName
                                                                                        , OrderBy
                                                                                        , ReasonIDF);

            HttpContext.Cache["TicketResponse"] = AuditData.Data;
            HttpContext.Cache["Role"]           = Role;

            return(Json(data, JsonRequestBehavior.AllowGet));
        }
Exemple #2
0
        public JsonResult UpdateACMDetail(long ADMIDP, string ACMNumber, float ACMAmount, int StatusIDF)
        {
            MEMBERS.SQLReturnValue mRes = new ADMHeaderLogic().ADMHeader_UpdateACMDetail(ADMIDP, ACMNumber, ACMAmount
                                                                                         , StatusIDF, GeneralClass.GetIntValue(GeneralClass.EmployeeID), GeneralClass.EmployeeName);

            return(Json(mRes.Outval, JsonRequestBehavior.AllowGet));
        }
        public JsonResult GeneralAction(long id, int ActionType)
        {
            MEMBERS.SQLReturnValue mRes = new ADMHeaderLogic().ADMHeader_GeneralAction(id
                                                                                       , ActionType
                                                                                       , GeneralClass.GetIntValue(GeneralClass.EmployeeID)
                                                                                       , GeneralClass.EmployeeName);

            return(Json(mRes.Outval, JsonRequestBehavior.AllowGet));
        }
        public JsonResult Save()
        {
            string Response = string.Empty;

            if (Request.Files.Count > 0)
            {
                try
                {
                    //  Get all files from Request object
                    HttpFileCollectionBase files = Request.Files;

                    for (int i = 0; i < files.Count; i++)
                    {
                        HttpPostedFileBase file = files[i];
                        string             FileName;

                        // Checking for Internet Explorer
                        if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
                        {
                            string[] testfiles = file.FileName.Split(new char[] { '\\' });
                            FileName = testfiles[testfiles.Length - 1];
                        }
                        else
                        {
                            FileName = file.FileName;
                        }

                        string FileExtension = System.IO.Path.GetExtension(Request.Files[i].FileName);
                        string NewFileName   = DateTime.Now.ToString("ddMMyyyyHHmmss") + FileExtension;
                        string SaveFilePath  = System.IO.Path.Combine(Server.MapPath("~/ADMFiles/"), NewFileName);
                        file.SaveAs(SaveFilePath);

                        ADMHeaderClass obj = new ADMHeaderClass();

                        long.TryParse(Request.Form["ADMIDP"].ToString(), out long ADMIDP);
                        float.TryParse(Request.Form["ADMAmount"].ToString(), out float ADMAmount);
                        float.TryParse(Request.Form["TicketAmount"].ToString(), out float TicketAmount);
                        int.TryParse(Request.Form["ReasonIDF"].ToString(), out int ReasonIDF);
                        //DateTime.TryParse(Request.Form["IATAADMDate"].ToString(), out DateTime IATAADMDate);

                        obj.ADMIDP              = ADMIDP;
                        obj.IATANumber          = Request.Form["IATANumber"].ToString();
                        obj.ADMNumber           = Request.Form["ADMNumber"].ToString();
                        obj.ADMAmount           = ADMAmount;
                        obj.TicketID            = Request.Form["TicketID"].ToString();
                        obj.OfficeID            = Request.Form["OfficeID"].ToString();
                        obj.BranchID            = Request.Form["BranchID"].ToString();
                        obj.TicketIssueBranchID = Request.Form["TicketIssueBranchID"].ToString();
                        obj.TicketAmount        = (TicketAmount > 0 && string.IsNullOrEmpty(Request.Form["TicketID"].ToString()) ? 0 : TicketAmount);
                        obj.ReasonIDF           = ReasonIDF;
                        obj.Remarks             = Request.Form["Remarks"].ToString();
                        obj.StatusIDF           = 1;
                        obj.UserID              = GeneralClass.GetIntValue(GeneralClass.EmployeeID);
                        obj.UserName            = GeneralClass.EmployeeName;
                        obj.ADMFileName         = NewFileName;
                        obj.IATAADMDate         = Request.Form["IATAADMDate"].ToString();

                        MEMBERS.SQLReturnValue mRes = new ADMHeaderLogic().ADMHeader_Insert_Update(obj);

                        Response = mRes.Outval.ToString();
                    }
                }
                catch (Exception ex)
                {
                    Response = "Error : " + ex.Message;
                }
            }
            else
            {
                try
                {
                    ADMHeaderClass obj = new ADMHeaderClass();

                    long.TryParse(Request.Form["ADMIDP"].ToString(), out long ADMIDP);
                    float.TryParse(Request.Form["ADMAmount"].ToString(), out float ADMAmount);
                    float.TryParse(Request.Form["TicketAmount"].ToString(), out float TicketAmount);
                    int.TryParse(Request.Form["ReasonIDF"].ToString(), out int ReasonIDF);
                    //DateTime.TryParse(Request.Form["IATAADMDate"].ToString(), out DateTime IATAADMDate);

                    //DateTime IATAADMDate = Convert.ToDateTime(Request.Form["IATAADMDate"].ToString());

                    obj.ADMIDP              = ADMIDP;
                    obj.IATANumber          = Request.Form["IATANumber"].ToString();
                    obj.ADMNumber           = Request.Form["ADMNumber"].ToString();
                    obj.ADMAmount           = ADMAmount;
                    obj.TicketID            = Request.Form["TicketID"].ToString();
                    obj.OfficeID            = Request.Form["OfficeID"].ToString();
                    obj.BranchID            = Request.Form["BranchID"].ToString();
                    obj.TicketIssueBranchID = Request.Form["TicketIssueBranchID"].ToString();
                    obj.TicketAmount        = (TicketAmount > 0 && string.IsNullOrEmpty(Request.Form["TicketID"].ToString()) ? 0 : TicketAmount);
                    obj.ReasonIDF           = ReasonIDF;
                    obj.Remarks             = Request.Form["Remarks"].ToString();
                    obj.StatusIDF           = 1;
                    obj.UserID              = GeneralClass.GetIntValue(GeneralClass.EmployeeID);
                    obj.UserName            = GeneralClass.EmployeeName;
                    obj.ADMFileName         = Request.Form["OldFileName"].ToString();
                    obj.IATAADMDate         = Request.Form["IATAADMDate"].ToString();

                    MEMBERS.SQLReturnValue mRes = new ADMHeaderLogic().ADMHeader_Insert_Update(obj);

                    Response = mRes.Outval.ToString();
                }
                catch (Exception ee)
                {
                    Response = "Error : " + ee.Message;
                }
            }

            /*Send Email*/
            if (Request.Form["ADMIDP"].ToString() == "0" && (Response != "Ticket already added in ADM." && Response != "ADM already raised.")) // NEW ADM RAISED
            {
                string SubjectBody = string.Empty;

                if (string.IsNullOrEmpty(Request.Form["TicketID"].ToString()) && !string.IsNullOrEmpty(Request.Form["ADMNumber"].ToString()))
                {
                    SubjectBody = "New ADM Raised - AMD Number is " + Request.Form["ADMNumber"].ToString();
                }
                else if (!string.IsNullOrEmpty(Request.Form["TicketID"].ToString()))
                {
                    SubjectBody = "New ADM Raised - Ticket id is " + Request.Form["TicketID"].ToString();
                }

                DataTable dt = new BranchEmailMasterLogic().BranchEmailMaster_GetEmailByBranchID(Request.Form["BranchID"].ToString());

                if (dt.Rows.Count > 0)
                {
                    new EmailLogic().SendEmail(SubjectBody
                                               , SubjectBody
                                               , dt.Rows[0]["ToEmailID"].ToString()
                                               , dt.Rows[0]["CCEmailID"].ToString());

                    Response = Response + " and ADM raised email send successfully.";
                }
                else
                {
                    Response = Response + " and ADM email not found.";
                }
            }

            return(Json(Response, JsonRequestBehavior.AllowGet));
        }
        public JsonResult GetTicketDetail(string TicketID, string IATANumber, int FetchID)
        {
            object data = new ADMHeaderLogic().ADM_GetTicketDetail_DSR_ERP_ByTicketID(TicketID, IATANumber, FetchID);

            return(Json(data, JsonRequestBehavior.AllowGet));
        }
        public JsonResult GetAllPaging(int RowsPerPage, int PageNumber)
        {
            object data = new ADMHeaderLogic().ADMHeader_GetAllPaging(RowsPerPage, PageNumber);

            return(Json(data, JsonRequestBehavior.AllowGet));
        }
        public JsonResult Get_GetAll(long id)
        {
            object data = new ADMHeaderLogic().ADMHeader_Get_GetAll(id, null);

            return(Json(data, JsonRequestBehavior.AllowGet));
        }