public string GetUserName(ProofReading pr)
{
try
{
clsParameterCollection clsParaCollection = new clsParameterCollection();
clsParaCollection.ProcedureName = Constants.sp_GetUserName;
clsParaCollection.Add(new clsParameter("@TrnId", pr.PTran_ID));
dt.Reset();
dt = DataAccess.ExecuteSpAndGetDataTable(clsParaCollection);
return dt.Rows[0][0].ToString();
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult ProofReadingNew(ProofReading pr, FormCollection form, string Command, string PageIndex)
{
if (Command == "Submit")
{
CtrlProofReading.ListLang = LoadLanguageDropDown();
CtrlProofReading.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);
//string FileText = System.IO.File.ReadAllText(Server.MapPath(Constants.strUploadFileIntialPath) + "//" + User.Identity.Name + "//" + Constants.strRequest + "//" + FilePathToUpload);
////FileText = FileText.Replace(" ", "");
//FileText = FileText.Replace("&", "");
//FileText = FileText.Replace("\0", "");
//StreamReader sr = new StreamReader(Server.MapPath(Constants.strUploadFileIntialPath) + "//" + User.Identity.Name + "//" + Constants.strRequest + "//" + FilePathToUpload);
//string str2 = sr.ReadToEnd();
//sr.Close();
//str2 = str2.Replace(" ", "");
////str2 = str2.Replace("&", "");
//str2 = str2.Replace("\0", "");
//string[] strLength = str2.Split(' ');
CtrlProofReading.RequestFilePath = FilePathToUpload;
CtrlProofReading.UserID = UserId;
CtrlProofReading.Language = form["ddlLang"];
CtrlProofReading.WordsCount = "1000";
CtrlProofReading.EstimatedAmt = "1000";
CtrlProofReading.RequestDate = DateTime.Now.ToShortDateString();
CtrlProofReading.Status = "1";
BussinessLayerObject.InsertProofReadingRequest(CtrlProofReading);
ViewBag.StatusMessage = "Request submited successfuly";
ViewBag.StatusMessageClass = "text-success bg-success";
SendMail("mail", int.Parse(CtrlProofReading.WordsCount), int.Parse(CtrlProofReading.EstimatedAmt));
}
else
{
ViewBag.StatusMessage = "Only document and PDF file allowed!";
ViewBag.StatusMessageClass = "text-danger bg-danger";
}
}
else
{
////////////////Edit button Functionality code Admin
var uploadedFile = Request.Files[1];
var fileName1 = Path.GetFileName(uploadedFile.FileName);
CtrlProofReading.Status = form["ddlStatus"];
CtrlProofReading.PTran_ID = form["lblTrnID"];
string UserName = BussinessLayerObject.GetUserName(CtrlProofReading);
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);
CtrlProofReading.ResponseFilePath = fileName1;
}
CtrlProofReading.ResponseDate = DateTime.Now.ToShortDateString();
BussinessLayerObject.UpdateProofReadingData(CtrlProofReading);
ViewBag.StatusMessage = "Saved successfuly";
ViewBag.StatusMessageClass = "text-success bg-success";
}
getDisplayData(ref CtrlProofReading);
return View(CtrlProofReading);
}
public ActionResult ProofReadingNew()
{
var model = new ProofReading();
getDisplayData(ref model);
return View(model);
}
/// <summary>
/// This method is used to load model to display grid data.
/// </summary>
/// <param name="model"></param>
private void getDisplayData(ref ProofReading model)
{
model.ListLang = LoadLanguageDropDown();
model.ListStatus = LoadStatusDropDown();
MembershipUser MemberUser = Membership.GetUser(User.Identity.Name);
string UserId = MemberUser.ProviderUserKey.ToString();
DataTable dtData = new DataTable();
dtData = BussinessLayerObject.GetProofReadingUserData(UserId);
List<ProofReading> listData = new List<ProofReading>();
foreach (DataRow dr in dtData.Rows)
{
listData.Add(new ProofReading
{
PTran_ID = dr["Trn_ID"].ToString(),
UserName = dr["UserName"].ToString(),
Language = dr["Lang_Name"].ToString(),
WordsCount = dr["WordsCount"].ToString(),
RequestFilePath = dr["RequestFilePath"].ToString(),
ResponseFilePath = 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;
}
private System.Data.DataTable retrieve_Data()
{
var model = new ProofReading();
if (User.IsInRole("Admin"))
{
// DataTable = BussinessLayerObject.get_ProofReadingData_Admin();
}
else
{
model.UserID = User.Identity.Name;
// DataTable = BussinessLayerObject.GetProofReadingUserData(model);
}
return DataTable;
}
public void InsertProofReadingRequest(ProofReading ProofReadingRef)
{
try
{
clsParameterCollection clsParaCollection = new clsParameterCollection();
clsParaCollection.ProcedureName = Constants.sp_InsertProofReadingRequest;
clsParaCollection.Add(new clsParameter("@UserID", ProofReadingRef.UserID));
clsParaCollection.Add(new clsParameter("@LangID", ProofReadingRef.Language));
clsParaCollection.Add(new clsParameter("@RequestFilePath", ProofReadingRef.RequestFilePath));
clsParaCollection.Add(new clsParameter("@StatusID", ProofReadingRef.Status));
clsParaCollection.Add(new clsParameter("@RequestDate", ProofReadingRef.RequestDate));
clsParaCollection.Add(new clsParameter("@EstimatedAmt", ProofReadingRef.EstimatedAmt));
clsParaCollection.Add(new clsParameter("@WordsCount", ProofReadingRef.WordsCount));
DataAccess.ExecuteNonQuerySp(clsParaCollection);
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateProofReadingData(ProofReading pr)
{
try
{
clsParameterCollection clsParaCollection = new clsParameterCollection();
clsParaCollection.Add(new clsParameter("@TrnID", pr.PTran_ID));
clsParaCollection.Add(new clsParameter("@Status", pr.Status));
clsParaCollection.Add(new clsParameter("@ResponseDate", pr.ResponseDate));
if (pr.ResponseFilePath != null)
{
clsParaCollection.Add(new clsParameter("@ResponseFilePath", pr.ResponseFilePath));
clsParaCollection.ProcedureName = Constants.sp_UpdateProofReadingResponse;
}
else
{
clsParaCollection.ProcedureName = Constants.sp_UpdateProofReadingStatus;
}
DataAccess.ExecuteNonQuerySp(clsParaCollection);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// This method is used to load model to display Webgrid data.
/// </summary>
/// <param name="model"></param>
private void getDisplayData(ref ProofReading model)
{
model.ListLang = LoadLanguageDropDown();
model.ListStatus = LoadStatusDropDown();
//MembershipUser MemberUser = Membership.GetUser(HttpContext.User.Identity.Name);
//string UserId = MemberUser.ProviderUserKey.ToString();
string UserId = Convert.ToString(Common.GetUserId(HttpContext.User.Identity.Name));
DataTable dtData = new DataTable();
//if (Request.IsAjaxRequest())
//{
// dtData = BussinessLayerObject.GetFilteredProofReadingData((string)TempData["SearchUser"]);
//}
//if (!string.isnullorempty((string)tempdata["searchuser"]))
//{
// dtData = BussinessLayerObject.GetFilteredProofReadingData((string)TempData["SearchUser"]);
//}
//else
//{
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.GetFilteredProofReadingDataByBoth(model.UserName, model.StartIndex, model.EndIndex, model.sort, model.sortdir, model.StartDate, model.EndDate);
}
else if (!string.IsNullOrEmpty(model.StartDate))
{
dtData = BLObj.GetFilteredProofReadingDataByDates(UserId, model.StartIndex, model.EndIndex, model.sort, model.sortdir, model.StartDate, model.EndDate);
}
else if (!string.IsNullOrEmpty(model.UserName))
{
dtData = BLObj.GetFilteredProofReadingData(model.UserName, model.StartIndex, model.EndIndex, model.sort, model.sortdir);
}
else
{
dtData = BLObj.GetProofReadingUserData(UserId, model.StartIndex, model.EndIndex, model.sort, model.sortdir);
}
//}
List<ProofReading> listData = new List<ProofReading>();
foreach (DataRow dr in dtData.Rows)
{
listData.Add(new ProofReading
{
SrNo = Convert.ToInt32(dr["row"]),
Trn_ID = dr["Trn_ID"].ToString(),
OrderID = dr["OrderID"].ToString(),
UserName = dr["UserName"].ToString(),
Language = dr["Lang_Name"].ToString(),
WordsCount = dr["WordsCount"].ToString(),
RequestFilePath = dr["RequestFilePath"].ToString(),
ResponseFilePath = 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;
}
public ActionResult ProofReadingNew(ProofReading pr, FormCollection form, string Command, string PageIndex)
{
if (Command == "Submit")
{
if (HttpContext.Session["upfID"] != null)
{
pr.upfID = Convert.ToInt32(HttpContext.Session["upfID"]);
}
else
{
pr.upfID = 0;
}
pr.ListLang = LoadLanguageDropDown();
pr.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")
{
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" || strFileExtension == ".doc")
{
wordtext = ReadAllTextFromDocx(Server.MapPath(Constants.strUploadFileIntialPath) + "//" + User.Identity.Name + "//" + Constants.strRequest + "//" + FilePathToUpload);
MatchCollection collection = Regex.Matches(wordtext, @"[\S]+");
WordCount = collection.Count;
}
pr.OrderID = VishwaPress.BusinessLayer.Utilities.Common.GetUniqueKey(User.Identity.Name, pr.serviceChar);
pr.RequestFilePath = FilePathToUpload;
pr.UserID = UserId;
pr.Language = form["ddlLang"];
pr.WordsCount = WordCount.ToString();
//pr.EstimatedAmt = BLObj.CalculateEstimateAmt(WordCount);
//harshad Changes Start
DataTable GetPrice = BLObj.GetPricesInformation();
DataTable Get_Service_tax = BLObj.GetServiceTax();
string price = Convert.ToString((System.Math.Round(Convert.ToDouble(WordCount * Convert.ToDouble(GetPrice.Rows[0][0])))));
string priceafterservicetax = (Convert.ToDouble(price) * (Convert.ToDouble(Get_Service_tax.Rows[0][0]) / 100)).ToString();
pr.EstimatedAmt = Convert.ToInt32((Convert.ToDouble(price) + Convert.ToDouble(priceafterservicetax))).ToString();
//harshad Chnages End
pr.RequestDate = DateTime.Now.ToShortDateString();
pr.Status = "1";
BLObj.InsertProofReadingRequest(pr);
if (pr.upfID != 0)
{
BL_Account bl = new BL_Account();
bl.UpdateCountAndisDone(pr.upfID);
HttpContext.Session["upfID"] = "";
}
//ViewBag.StatusMessage = "Request submited successfuly";
//ViewBag.StatusMessageClass = "text-success bg-success";
dt = BLObj.GetUserMailID(UserId);
htmlFilePath = Server.MapPath(Constants.PREmailHTMLTemplate);
SendMail(User.Identity.Name, dt.Rows[0][0].ToString(), int.Parse(pr.WordsCount), int.Parse(pr.EstimatedAmt), pr.OrderID, htmlFilePath);
}
else
{
TempData["StatusMessage"] = "File is empty, please select another file";
TempData["StatusMessageClass"] = "text-danger bg-danger";
return RedirectToAction("ProofReadingNew");
}
}
else
{
//ViewBag.StatusMessage = "Only document and PDF file allowed!";
//ViewBag.StatusMessageClass = "text-danger bg-danger";
TempData["StatusMessage"] = "Only .doc and .docx file allowed!";
TempData["StatusMessageClass"] = "text-danger bg-danger";
return RedirectToAction("ProofReadingNew");
}
}
else if (Command == "Save")
{
////////////////Edit button Functionality code Admin
var uploadedFile = Request.Files[0];
var fileName1 = Path.GetFileName(uploadedFile.FileName);
pr.Status = form["ddlStatus"];
pr.Trn_ID = form["lblTrnID"];
string UserName = BLObj.GetUserName(pr);
//MembershipUser MemberUser = Membership.GetUser(User.Identity.Name);
//string UserId = MemberUser.ProviderUserKey.ToString();
string UserId = Convert.ToString(Common.GetUserId(HttpContext.User.Identity.Name));
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);
pr.ResponseFilePath = fileName1;
}
pr.ResponseDate = DateTime.Now.ToShortDateString();
BLObj.UpdateProofReadingData(pr);
//ViewBag.StatusMessage = "Saved successfuly";
//ViewBag.StatusMessageClass = "text-success bg-success";
TempData["StatusMessage"] = "Saved successfuly";
TempData["StatusMessageClass"] = "text-success bg-success";
dt.Clear();
dt = BLObj.getUserIDFromTrnID(form["lblTrnID"]);
uid = Convert.ToString(dt.Rows[0]["UserId"]);
OId = Convert.ToString(dt.Rows[0]["OrderID"]);
dt.Clear();
dt = BLObj.GetUserMailID(uid);
statusHtmlFilePath = Server.MapPath(Constants.StatusChangeHTMLTemplate);
SendMailOnStatusChange(UserName, dt.Rows[0][0].ToString(), form["ddlStatus"], OId, statusHtmlFilePath);
return RedirectToAction("ProofReadingNew");
}
else if (Command == "Search User")
{
//TempData["searchUser"] = pr.txtFilterUserName;
return RedirectToAction("ProofReadingNew", new { UserName = pr.txtFilterUserName });
}
else if (Command == "Search")
{
return RedirectToAction("ProofReadingNew", new { StartDate = pr.StartDate, EndDate = pr.EndDate, UserName = pr.txtFilterUserName });
}
//getDisplayData(ref CtrlProofReading);
//return View(CtrlProofReading);
return RedirectToAction("RequestSuccess");
}
/// <summary>
/// This Action executes for loading proofReading view.
/// </summary>
/// <returns></returns>
//[Authorize(Roles = "Admin,Customer,ProofReading")]
public ActionResult ProofReadingNew(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 ProofReading();
model.PagingRange = Constants.PagingRange;
if (!string.IsNullOrEmpty(UserName))
{
model.txtFilterUserName = UserName;
}
//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;
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("_WebgridProofReading", model); }
}
if (!string.IsNullOrEmpty(sort) && page != null)
{
return PartialView("_WebgridProofReading", model);
}
return View(model);
}