public ActionResult FormattingNew() { var model = new Formatting(); getDisplayData(ref model); return View(model); }
public string GetUserName(Formatting fr) { try { clsParameterCollection clsParaCollection = new clsParameterCollection(); clsParaCollection.ProcedureName = Constants.sp_GetFRUserName; clsParaCollection.Add(new clsParameter("@TrnID", fr.Trn_ID)); dt.Reset(); dt = DataAccess.ExecuteSpAndGetDataTable(clsParaCollection); return dt.Rows[0][0].ToString(); } catch (Exception ex) { throw ex; } }
public void InsertFormattingRequest(Formatting FormattingRef) { try { clsParameterCollection clsParaCollection = new clsParameterCollection(); clsParaCollection.ProcedureName = Constants.sp_InsertFormattingRequest; clsParaCollection.Add(new clsParameter("@UserID",FormattingRef.UserID)); clsParaCollection.Add(new clsParameter("@SizeID", FormattingRef.BookSize)); clsParaCollection.Add(new clsParameter("@RequestFilePath", FormattingRef.RequestFileName)); clsParaCollection.Add(new clsParameter("@FullPageIMGCount", FormattingRef.FullPageIMGCount)); clsParaCollection.Add(new clsParameter("@HalfPageIMGCount", FormattingRef.HalfPageIMGCount)); clsParaCollection.Add(new clsParameter("@QuaterPageIMGCount", FormattingRef.QuarterPageIMGCount)); clsParaCollection.Add(new clsParameter("@Temp_ID",FormattingRef.TemplateID)); clsParaCollection.Add(new clsParameter("@StatusID",FormattingRef.Status)); clsParaCollection.Add(new clsParameter("@RequestDate",FormattingRef.RequestDate)); clsParaCollection.Add(new clsParameter("@EstimatedAmt",FormattingRef.EstimatedAmt)); DataAccess.ExecuteNonQuerySp(clsParaCollection); } catch (Exception ex) { throw ex; } }
public void UpdateFormattingData(Formatting fr) { try { clsParameterCollection clsParaCollection = new clsParameterCollection(); clsParaCollection.Add(new clsParameter("@TrnID", fr.Trn_ID)); clsParaCollection.Add(new clsParameter("@Status", fr.Status)); clsParaCollection.Add(new clsParameter("@ResponseDate", fr.ResponseDate)); if (fr.ReponseFileName != null) { clsParaCollection.Add(new clsParameter("@ResponseFilePath", fr.ReponseFileName)); clsParaCollection.ProcedureName = Constants.sp_UpadateFormattingResponse; } else { clsParaCollection.ProcedureName = Constants.sp_UpdateFormattingStatus; } DataAccess.ExecuteNonQuerySp(clsParaCollection); } catch (Exception ex) { throw ex; } }
public ActionResult FormattingNew(Formatting pr, FormCollection form, string Command, string PageIndex) { if (Command == "Submit") { CtrlFormatting.ListSize = LoadBookSizeDropDown(); CtrlFormatting.ListStatus = LoadStatusDropDown(); MembershipUser MemberUser = Membership.GetUser(User.Identity.Name); string UserId = MemberUser.ProviderUserKey.ToString(); var uploadedFile = Request.Files[0]; string strFileExtension = Path.GetExtension(uploadedFile.FileName); if (strFileExtension == ".doc" || strFileExtension == ".docx" || strFileExtension == ".pdf") { string FilePathToUpload = ""; FilePathToUpload = User.Identity.Name + "_" + Constants.strRequest + "_" + DateTime.Now.Date.ToShortDateString() + "_" + (Path.GetFileName(uploadedFile.FileName)); if (!Directory.Exists(Server.MapPath(Constants.strUploadFileIntialPath) + "//" + User.Identity.Name + "//" + Constants.strRequest)) { Directory.CreateDirectory(Server.MapPath(Constants.strUploadFileIntialPath) + "//" + User.Identity.Name + "//" + Constants.strRequest); } uploadedFile.SaveAs(Server.MapPath(Constants.strUploadFileIntialPath) + "//" + User.Identity.Name + "//" + Constants.strRequest + "//" + FilePathToUpload); CtrlFormatting.RequestFileName = FilePathToUpload; CtrlFormatting.UserID = UserId; CtrlFormatting.BookSize = form["ddlSize"]; CtrlFormatting.EstimatedAmt = "1000"; CtrlFormatting.RequestDate = DateTime.Now.ToShortDateString(); CtrlFormatting.Status = "1"; CtrlFormatting.FullPageIMGCount = Session["fullPImg"].ToString(); CtrlFormatting.HalfPageIMGCount = Session["halfPImg"].ToString(); CtrlFormatting.QuarterPageIMGCount = Session["quaterPImg"].ToString(); CtrlFormatting.TemplateID = Session["tempID"].ToString(); BussinessLayerObject.InsertFormattingRequest(CtrlFormatting); ViewBag.StatusMessage = "Request submited successfuly"; ViewBag.StatusMessageClass = "text-success bg-success"; SendMail("mail", int.Parse(CtrlFormatting.FullPageIMGCount),int.Parse(CtrlFormatting.HalfPageIMGCount),int.Parse(CtrlFormatting.QuarterPageIMGCount), int.Parse(CtrlFormatting.EstimatedAmt)); } else { ViewBag.StatusMessage = "Only document and PDF file allowed!"; ViewBag.StatusMessageClass = "text-danger bg-danger"; } getDisplayData(ref CtrlFormatting); return View(CtrlFormatting); } else { ////////////////Edit button Functionality code Admin var uploadedFile = Request.Files[1]; var fileName1 = Path.GetFileName(uploadedFile.FileName); CtrlFormatting.Status = form["ddlStatus"]; CtrlFormatting.Trn_ID = form["lblTrnID"]; string UserName = BussinessLayerObject.GetUserName(CtrlFormatting); MembershipUser MemberUser = Membership.GetUser(User.Identity.Name); string UserId = MemberUser.ProviderUserKey.ToString(); if (fileName1 != String.Empty) { fileName1 = UserName + "_" + Constants.strResponse + "_" + DateTime.Now.Date.ToShortDateString() + "_" + fileName1; if (!Directory.Exists(Server.MapPath(Constants.strUploadFileIntialPath) + "//" + UserName + "//" + Constants.strResponse)) { Directory.CreateDirectory(Server.MapPath(Constants.strUploadFileIntialPath) + "//" + UserName + "//" + Constants.strResponse); } var fileSavePath = Server.MapPath(Constants.strUploadFileIntialPath + "//" + UserName + "//" + Constants.strResponse + "//" + fileName1); uploadedFile.SaveAs(fileSavePath); CtrlFormatting.ReponseFileName = fileName1; } CtrlFormatting.ResponseDate = DateTime.Now.ToShortDateString(); BussinessLayerObject.UpdateFormattingData(CtrlFormatting); ViewBag.StatusMessage = "Saved successfuly"; ViewBag.StatusMessageClass = "text-success bg-success"; } getDisplayData(ref CtrlFormatting); return View(CtrlFormatting); }
//[Authorize(Roles = "Admin,Customer")] //public ActionResult formatting() //{ // load_ddlBookSize(); // load_ddlStatus(); // var model = new Formatting(); // DataTable.Reset(); // DataTable = retrieve_Data(); // foreach (DataRow dr in DataTable.Rows) // { // model.Data_List.Add(new Formatting { pTrn_ID = dr[0].ToString(), UserID = dr[1].ToString(),book_Size = dr[2].ToString(),no_fullP_images=dr[3].ToString(),no_halfP_images=dr[4].ToString(),no_quaterP_images=dr[5].ToString(),template_ID=dr[6].ToString(), estimated_Amt = dr[7].ToString(), request_FileName = dr[8].ToString(), reponse_FileName = dr[9].ToString(), request_Date = dr[10].ToString(), response_Date = dr[11].ToString(), status = dr[12].ToString() }); // } // DataTable.Reset(); // DataTable = BussinessLayerObject.get_Templates(); // //foreach (DataRow dr in dt.Rows) // //{ // // model.temp_urls.Add(dr["temp_Name"].ToString()); // //} // foreach (DataRow dr in DataTable.Rows) // { // model.temp_urls.Add(dr); // } // model.templates_Count = model.temp_urls.Count.ToString(); // return View(model); //} //[HttpPost] //[AcceptVerbs(HttpVerbs.Post)] //public ActionResult Formatting(Formatting fr,FormCollection form,string Command) //{ // if (Command == "Submit") // { // load_ddlBookSize(); // load_ddlStatus(); // var model = new Formatting(); // var fileSavePath = ""; // var uploadedFile = Request.Files[0]; // fileName1 = Path.GetFileName(uploadedFile.FileName); // fileName1 = User.Identity.Name + "_" + fr.strRequest + "_" + DateTime.Now.Date.ToShortDateString() + "_" + fileName1; // if (!Directory.Exists(Server.MapPath(fr.FilePath1) + fr.FilePath2)) // { // Directory.CreateDirectory(Server.MapPath(fr.FilePath1) + fr.FilePath2); // } // if (!Directory.Exists(Server.MapPath(fr.FilePath3) + "//" + User.Identity.Name)) // { // Directory.CreateDirectory(Server.MapPath(fr.FilePath3) + "//" + User.Identity.Name); // } // if (!Directory.Exists(Server.MapPath(fr.FilePath3) + "//" + User.Identity.Name + "//" + fr.strRequest)) // { // Directory.CreateDirectory(Server.MapPath(fr.FilePath3) + "//" + User.Identity.Name + "//" + fr.strRequest); // } // fileSavePath = Server.MapPath(fr.FilePath3 + "//" + User.Identity.Name + "//" + fr.strRequest + "//" + fileName1); // uploadedFile.SaveAs(fileSavePath); // fr.request_FileName = fileName1; // fr.UserID = User.Identity.Name; // fr.book_Size = form["ddlBSizes"]; // fr.no_fullP_images = Session["fullPImg"].ToString(); // fr.no_halfP_images = Session["halfPImg"].ToString(); // fr.no_quaterP_images = Session["quaterPImg"].ToString(); // fr.template_ID = Session["tempID"].ToString(); // ////getWordCount(fileSavePath); // //int nw = 100; // //pr.no_of_words = nw.ToString(); // //fr.estimated_amt = bl.cal_Estimate_Amt(nw); // fr.request_Date = DateTime.Now.ToShortDateString(); // fr.status = "1"; // fr.estimated_Amt = "100"; // BussinessLayerObject.insert_FormattingData(fr); // int result = 1; // if (result > 0) // { // ViewData["result"] = result; // } // else // { // ViewData["Error"] = 1; // } // DataTable.Reset(); // DataTable = retrieve_Data(); // foreach (DataRow dr in DataTable.Rows) // { // model.Data_List.Add(new Formatting { pTrn_ID = dr[0].ToString(), UserID = dr[1].ToString(), book_Size = dr[2].ToString(), no_fullP_images = dr[3].ToString(), no_halfP_images = dr[4].ToString(), no_quaterP_images = dr[5].ToString(), template_ID = dr[6].ToString(), estimated_Amt = dr[7].ToString(), request_FileName = dr[8].ToString(), reponse_FileName = dr[9].ToString(), request_Date = dr[10].ToString(), response_Date = dr[11].ToString(), status = dr[12].ToString() }); // } // Session["fullPImg"]=null; // Session["halfPImg"]=null; // Session["quaterPImg"] = null; // Session["tempID"] = null; // return View(model); // } // else // { // var uploadedFile = Request.Files[0]; // var fileName1 = Path.GetFileName(uploadedFile.FileName); // fr.status = form["ddlStatus"]; // fr.pTrn_ID = form["lblTrnID"]; // string uName = BussinessLayerObject.get_UserName(fr); // if (fileName1 != String.Empty) // { // fileName1 = uName + "_" + fr.strResponse + "_" + DateTime.Now.Date.ToShortDateString() + "_" + fileName1; // if (!Directory.Exists(Server.MapPath(fr.FilePath3) + "//" + uName + "//" + fr.strResponse)) // { // Directory.CreateDirectory(Server.MapPath(fr.FilePath3) + "//" + uName + "//" + fr.strResponse); // } // var fileSavePath = Server.MapPath(fr.FilePath3 + "//" + uName + "//" + fr.strResponse + "//" + fileName1); // uploadedFile.SaveAs(fileSavePath); // fr.reponse_FileName = fileName1; // } // fr.response_Date = DateTime.Now.ToShortDateString(); // BussinessLayerObject.update_FormattingData(fr); // int i = 1; // if (i > 0) // { // ViewData["Saved"] = 1; // } // else // ViewData["Saved"] = null; // load_ddlStatus(); // var model = new Formatting(); // DataTable = retrieve_Data(); // foreach (DataRow dr in DataTable.Rows) // { // model.Data_List.Add(new Formatting { pTrn_ID = dr[0].ToString(), UserID = dr[1].ToString(), book_Size = dr[2].ToString(), no_fullP_images = dr[3].ToString(), no_halfP_images = dr[4].ToString(), no_quaterP_images = dr[5].ToString(), template_ID = dr[6].ToString(), estimated_Amt = dr[7].ToString(), request_FileName = dr[8].ToString(), reponse_FileName = dr[9].ToString(), request_Date = dr[10].ToString(), response_Date = dr[11].ToString(), status = dr[12].ToString() }); // } // return View(model); // } //} private DataTable retrieve_Data() { var model = new Formatting(); if (User.IsInRole("Admin")) { // DataTable = BussinessLayerObject.get_FormattingData_Admin(); } else { model.UserID = User.Identity.Name; // DataTable = BussinessLayerObject.get_FormattingData_User(model); } return DataTable; }
/// <summary> /// This method is used to load model to display grid data. /// </summary> /// <param name="model"></param> private void getDisplayData(ref Formatting model) { model.ListSize = LoadBookSizeDropDown(); model.ListStatus = LoadStatusDropDown(); MembershipUser MemberUser = Membership.GetUser(User.Identity.Name); string UserId = MemberUser.ProviderUserKey.ToString(); DataTable dtData = new DataTable(); dtData = BussinessLayerObject.GetFormattingUserData(UserId); List<Formatting> listData = new List<Formatting>(); foreach (DataRow dr in dtData.Rows) { listData.Add(new Formatting { Trn_ID = dr["Trn_ID"].ToString(), UserName = dr["UserName"].ToString(), BookSize = dr["size_Name"].ToString(), FullPageIMGCount = dr["FullPageIMGCount"].ToString(), HalfPageIMGCount = dr["HalfPageIMGCount"].ToString(), QuarterPageIMGCount = dr["QuaterPageIMGCount"].ToString(), TemplateID= dr["temp_Name"].ToString(), RequestFileName = dr["RequestFilePath"].ToString(), ReponseFileName = dr["ResponseFilePath"].ToString(), Status = dr["status_Name"].ToString(), EstimatedAmt = dr["EstimatedAmt"].ToString(), isPaymentRelesed = dr["IsPaymentReleased"].ToString(), RequestDate = dr["RequestDate"].ToString(), ResponseDate = dr["ResponseDate"].ToString() }); } model.ModelList = listData; DataTable = BussinessLayerObject.GetTemplates(); foreach (DataRow dr in DataTable.Rows) { model.Temp_Urls.Add(dr); } model.TemplatesCount = model.Temp_Urls.Count.ToString(); }
/// <summary> /// This method is used to load model to display grid data. /// </summary> /// <param name="model"></param> private void getDisplayData(ref Formatting model) { model.ListSize = LoadBookSizeDropDown(); model.ListStatus = LoadStatusDropDown(); string UserId = Convert.ToString(Common.GetUserId(HttpContext.User.Identity.Name)); //MembershipUser MemberUser = Membership.GetUser(User.Identity.Name); //string UserId = MemberUser.ProviderUserKey.ToString(); DataTable dtData = new DataTable(); dtData = BLObj.getRowsCount(Convert.ToString(model.UserName), UserId, model.StartDate, model.EndDate); model.Pages = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(dtData.Rows[0][0].ToString()) / Convert.ToDouble((model.RecordsPerPage == 0) ? 5.00 : model.RecordsPerPage))); dtData.Clear(); if (!string.IsNullOrEmpty(model.StartDate) && !string.IsNullOrEmpty(model.UserName)) { dtData = BLObj.GetFilteredFormattingDataByBoth(model.UserName, model.StartIndex, model.EndIndex, model.sort, model.sortdir, model.StartDate, model.EndDate); } else if (!string.IsNullOrEmpty(model.StartDate)) { dtData = BLObj.GetFilteredFormattingDataByDates(UserId, model.StartIndex, model.EndIndex, model.sort, model.sortdir, model.StartDate, model.EndDate); } else if (!string.IsNullOrEmpty(model.UserName)) { dtData = BLObj.GetFilteredFormattingData(model.UserName, model.StartIndex, model.EndIndex, model.sort, model.sortdir); } else { dtData = BLObj.GetFormattingUserData(UserId, model.StartIndex, model.EndIndex, model.sort, model.sortdir); } List<Formatting> listData = new List<Formatting>(); foreach (DataRow dr in dtData.Rows) { listData.Add(new Formatting { SrNo = Convert.ToInt32(dr["row"]), Trn_ID = dr["Trn_ID"].ToString(), OrderID = dr["OrderID"].ToString(), UserName = dr["UserName"].ToString(), BookSize = dr["size_Name"].ToString(), FullPageIMGCount = dr["FullPageIMGCount"].ToString(), HalfPageIMGCount = dr["HalfPageIMGCount"].ToString(), QuarterPageIMGCount = dr["QuaterPageIMGCount"].ToString(), TemplateID = dr["temp_Name"].ToString(), RequestFileName = dr["RequestFilePath"].ToString(), ReponseFileName = dr["ResponseFilePath"].ToString(), Status = dr["status_Name"].ToString(), EstimatedAmt = dr["EstimatedAmt"].ToString(), isPaymentRelesed = dr["IsPaymentReleased"].ToString(), RequestDate = dr["RequestDate"].ToString(), ResponseDate = dr["ResponseDate"].ToString() }); } model.ModelList = listData; DataTable = BLObj.GetTemplates(); foreach (DataRow dr in DataTable.Rows) { model.Temp_Urls.Add(dr); } model.TemplatesCount = model.Temp_Urls.Count.ToString(); }
public ActionResult FormattingNew(Formatting pr, FormCollection form, string Command, string PageIndex) { if (Command == "Submit") { if (HttpContext.Session["upfID"] != null) { CtrlFormatting.upfID = Convert.ToInt32(HttpContext.Session["upfID"]); } else { CtrlFormatting.upfID = 0; } CtrlFormatting.ListSize = LoadBookSizeDropDown(); CtrlFormatting.ListStatus = LoadStatusDropDown(); //MembershipUser MemberUser = Membership.GetUser(User.Identity.Name); //string UserId = MemberUser.ProviderUserKey.ToString(); string UserId = Convert.ToString(Common.GetUserId(HttpContext.User.Identity.Name)); var uploadedFile = Request.Files[0]; string strFileExtension = Path.GetExtension(uploadedFile.FileName); if (strFileExtension == ".docx" || strFileExtension == ".doc") //|| strFileExtension == ".pdf") { if (uploadedFile.ContentLength > 0) { string FilePathToUpload = ""; FilePathToUpload = User.Identity.Name + "_" + Constants.strRequest + "_" + DateTime.Today.ToString("dd-MM-yyyy") + "_" + (Path.GetFileName(uploadedFile.FileName)); if (!Directory.Exists(Server.MapPath(Constants.strUploadFileIntialPath) + "//" + User.Identity.Name + "//" + Constants.strRequest)) { Directory.CreateDirectory(Server.MapPath(Constants.strUploadFileIntialPath) + "//" + User.Identity.Name + "//" + Constants.strRequest); } uploadedFile.SaveAs(Server.MapPath(Constants.strUploadFileIntialPath) + "//" + User.Identity.Name + "//" + Constants.strRequest + "//" + FilePathToUpload); if (strFileExtension == ".docx") { NumberOfPages = CountPagesFromDocx(Server.MapPath(Constants.strUploadFileIntialPath) + "//" + User.Identity.Name + "//" + Constants.strRequest + "//" + FilePathToUpload); } else { NumberOfPages = CountPagesFromPdf(Server.MapPath(Constants.strUploadFileIntialPath) + "//" + User.Identity.Name + "//" + Constants.strRequest + "//" + FilePathToUpload); } CtrlFormatting.RequestFileName = FilePathToUpload; CtrlFormatting.UserID = UserId; CtrlFormatting.BookSize = form["ddlSize"]; DataTable GetPriceforFormatting = BLObj.GetPriceForFormatting(); DataTable GetServiceTax = BLObj.GetServiceTax(); string getprice = Convert.ToString(Convert.ToInt32(NumberOfPages) * Convert.ToInt32(GetPriceforFormatting.Rows[0]["FormattingPricing"])); CtrlFormatting.EstimatedAmt = (Convert.ToDouble(getprice) + (Convert.ToDouble(GetServiceTax.Rows[0][0]) / 100)).ToString(); CtrlFormatting.RequestDate = DateTime.Now.ToShortDateString(); CtrlFormatting.Status = "1"; CtrlFormatting.FullPageIMGCount = Session["fullPImg"].ToString(); CtrlFormatting.HalfPageIMGCount = Session["halfPImg"].ToString(); CtrlFormatting.QuarterPageIMGCount = Session["quaterPImg"].ToString(); CtrlFormatting.TemplateID = Session["tempID"].ToString(); CtrlFormatting.OrderID = VishwaPress.BusinessLayer.Utilities.Common.GetUniqueKey(User.Identity.Name, CtrlFormatting.serviceChar); BLObj.InsertFormattingRequest(CtrlFormatting); Session["fullPImg"] = null; Session["halfPImg"] = null; Session["quaterPImg"] = null; Session["tempID"] = null; if (CtrlFormatting.upfID != 0) { BL_Account bl = new BL_Account(); bl.UpdateCountAndisDone(CtrlFormatting.upfID); HttpContext.Session["upfID"] = ""; } //ViewBag.StatusMessage = "Request submited successfuly"; //ViewBag.StatusMessageClass = "text-success bg-success"; DataTable = BLObj.GetUserMailID(UserId); htmlFilePath = Server.MapPath(Constants.FREmailHTMLTemplate); SendMail(User.Identity.Name, DataTable.Rows[0][0].ToString(), int.Parse(CtrlFormatting.FullPageIMGCount), int.Parse(CtrlFormatting.HalfPageIMGCount), int.Parse(CtrlFormatting.QuarterPageIMGCount), CtrlFormatting.EstimatedAmt, CtrlFormatting.OrderID, htmlFilePath); } else { TempData["StatusMessage"] = "File is empty, please select another file"; TempData["StatusMessageClass"] = "text-danger bg-danger"; return RedirectToAction("FormattingNew"); } } else { //ViewBag.StatusMessage = "Only document and PDF file allowed!"; //ViewBag.StatusMessageClass = "text-danger bg-danger"; TempData["StatusMessage"] = "Only document allowed!"; TempData["StatusMessageClass"] = "text-danger bg-danger"; return RedirectToAction("FormattingNew"); } //getDisplayData(ref CtrlFormatting); //return View(CtrlFormatting); } else if (Command == "Save") { ////////////////Edit button Functionality code Admin var uploadedFile = Request.Files[0]; var fileName1 = Path.GetFileName(uploadedFile.FileName); CtrlFormatting.Status = form["ddlStatus"]; CtrlFormatting.Trn_ID = form["lblTrnID"]; string UserName = BLObj.GetUserName(CtrlFormatting); string UserId = Convert.ToString(Common.GetUserId(HttpContext.User.Identity.Name)); //MembershipUser MemberUser = Membership.GetUser(User.Identity.Name); //string UserId = MemberUser.ProviderUserKey.ToString(); if (fileName1 != String.Empty) { fileName1 = UserName + "_" + Constants.strResponse + "_" + DateTime.Today.ToString("dd-MM-yyyy") + "_" + fileName1; if (!Directory.Exists(Server.MapPath(Constants.strUploadFileIntialPath) + "//" + UserName + "//" + Constants.strResponse)) { Directory.CreateDirectory(Server.MapPath(Constants.strUploadFileIntialPath) + "//" + UserName + "//" + Constants.strResponse); } var fileSavePath = Server.MapPath(Constants.strUploadFileIntialPath + "//" + UserName + "//" + Constants.strResponse + "//" + fileName1); uploadedFile.SaveAs(fileSavePath); CtrlFormatting.ReponseFileName = fileName1; } CtrlFormatting.ResponseDate = DateTime.Now.ToShortDateString(); BLObj.UpdateFormattingData(CtrlFormatting); //ViewBag.StatusMessage = "Saved successfuly"; //ViewBag.StatusMessageClass = "text-success bg-success"; TempData["StatusMessage"] = "Saved successfuly"; TempData["StatusMessageClass"] = "text-success bg-success"; DataTable.Clear(); DataTable = BLObj.getUserIDFromTrnID(form["lblTrnID"]); string uid = DataTable.Rows[0]["UserId"].ToString(); string OId = DataTable.Rows[0]["OrderID"].ToString(); DataTable.Clear(); DataTable = BLObj.GetUserMailID(uid); statusHtmlFilePath = Server.MapPath(Constants.StatusChangeHTMLTemplate); SendMailOnStatusChange(UserName, DataTable.Rows[0][0].ToString(), form["ddlStatus"], OId, statusHtmlFilePath); return RedirectToAction("FormattingNew"); } else if (Command == "SearchUser") { //TempData["searchUser"] = pr.txtFilterUserName; return RedirectToAction("FormattingNew", new { UserName = pr.txtFilterUserName }); } else if (Command == "Search") { return RedirectToAction("FormattingNew", new { StartDate = pr.StartDate, EndDate = pr.EndDate, UserName = pr.txtFilterUserName }); } //getDisplayData(ref CtrlFormatting); //return View(CtrlFormatting); return RedirectToAction("RequestSuccess"); }
//[Authorize(Roles = "Admin,Customer,Formatting")] public ActionResult FormattingNew(int? page, string sort, string sortdir, string UserName, string StartDate, string EndDate, int? RecordsPerPage, string upfID) { if (upfID != "") { HttpContext.Session["upfID"] = upfID; } var model = new Formatting(); //Check whether package is taken or not, 0 for not taken and 1 for taken DataTable dt = BLObj.GetPackageInfobyuserid(Convert.ToString(Common.GetUserId(HttpContext.User.Identity.Name))); if (dt.Rows.Count > 0) model.IsPackageTaken = 1; else model.IsPackageTaken = 0; model.PagingRange = Constants.PagingRange; if (!string.IsNullOrEmpty(UserName)) { model.txtFilterUserName = UserName; } if (!string.IsNullOrEmpty(StartDate)) { model.StartDate = StartDate; model.EndDate = EndDate; } if (page != null) { model.CurrentPage = Convert.ToInt32(page); if (RecordsPerPage == null) { model.StartIndex = (Convert.ToInt32(page) * 5) - 4; model.EndIndex = Convert.ToInt32(page) * 5; } else { model.RecordsPerPage = Convert.ToInt32(RecordsPerPage); model.StartIndex = (Convert.ToInt32(page) * model.RecordsPerPage) - (model.RecordsPerPage - 1); model.EndIndex = Convert.ToInt32(page) * model.RecordsPerPage; } if (!string.IsNullOrEmpty(sort)) { model.sort = sort; model.sortdir = sortdir; } else { //if (!string.IsNullOrEmpty(Convert.ToString(TempData["sort"]))) //{ // model.sort = TempData["sort"].ToString(); // model.sortdir = TempData["sortdir"].ToString(); // TempData["sort"] = model.sort; // TempData["sortdir"] = model.sortdir; //} //else //{ model.sort = "Trn_ID"; model.sortdir = "Desc"; //} } } else { model.CurrentPage = 1; if (RecordsPerPage == null) { model.StartIndex = 1; model.EndIndex = 5; } else { model.RecordsPerPage = Convert.ToInt32(RecordsPerPage); model.StartIndex = 1; model.EndIndex = model.RecordsPerPage; } if (!string.IsNullOrEmpty(sort)) { model.sort = sort; model.sortdir = sortdir; } else { model.sort = "Trn_ID"; model.sortdir = "Desc"; } } model.UserName = UserName; getDisplayData(ref model); model.LastPageIndex = model.Pages; if (string.IsNullOrEmpty(sort)) { if (Request.IsAjaxRequest()) { return PartialView("_WebgridFormating", model); } } if (!string.IsNullOrEmpty(sort) && page != null) { return PartialView("_WebgridFormating", model); } return View(model); }