public ActionResult ManagePricingForServices(FormCollection form)
{
BusinessLayer.BLControllers.BL_Account bl = new BusinessLayer.BLControllers.BL_Account();
string ServiceTax = form["txtServiceTax"].ToString();
//for service tax update
if (form["txtServiceTax"].ToString().Length > 0)
BLObj.UpdateServiceTaxPricing(form["txtServiceTax"].ToString());
//for Proofreading Pricing with Service Tax
if (form["txtProofReading"].ToString().Length > 0)
{
//double addingServiceTaxwithProofReadingpricing = Convert.ToDouble(form["txtProofReading"].ToString()) * (Convert.ToDouble(ServiceTax)) / 100;
//double ProofReadingPricing = Convert.ToDouble(form["txtProofReading"].ToString()) + addingServiceTaxwithProofReadingpricing;
BLObj.InsertProofReadingPricing(form["txtProofReading"].ToString());
}
//for Formatting Pricing with Service Tax
if (form["txtFormatting"].ToString().Length > 0)
{
//double addingServiceTaxwithFormattingpricing = Convert.ToDouble(form["txtFormatting"].ToString()) * (Convert.ToDouble(ServiceTax)) / 100;
//double FormattingPricing = Convert.ToDouble(form["txtFormatting"].ToString()) + addingServiceTaxwithFormattingpricing;
BLObj.InsertFormatingPricing(form["txtFormatting"].ToString());
}
//for Illustration Pricing with Service Tax
if (form["txtIllustrationPrice"].ToString().Length > 0 && form["ddlIllType"].ToString().Length > 0 && form["ddlColor"].ToString().Length > 0)
{
//double addingServiceTaxwithIllustrationpricing = Convert.ToDouble(form["txtIllustrationPrice"].ToString()) * (Convert.ToDouble(ServiceTax)) / 100;
//double IllustrationPricing = Convert.ToDouble(form["txtIllustrationPrice"].ToString()) + addingServiceTaxwithIllustrationpricing;
int illtype = Convert.ToInt32(form["ddlIllType"].ToString());
int illcolor = Convert.ToInt32(form["ddlColor"].ToString());
BLObj.UpdateIllustrationPricing(illtype, illcolor, form["txtIllustrationPrice"].ToString());
}
//for CoverDesign Pricing with Service Tax
if (form["txtCoverDesingForGraphics"].ToString().Length > 0 || form["txtCoverDesingForIllustrative"].ToString().Length > 0)
{
//double addingServiceTaxwithCoverDesingpricing = 0.00,CoverDesingPricing = 0.00;
if (form["txtCoverDesingForGraphics"].ToString().Length > 0)
{
//addingServiceTaxwithCoverDesingpricing = Convert.ToDouble(form["txtCoverDesingForGraphics"].ToString()) * (Convert.ToDouble(ServiceTax)) / 100;
//CoverDesingPricing = Convert.ToDouble(form["txtCoverDesingForGraphics"].ToString()) + addingServiceTaxwithCoverDesingpricing;
BLObj.UpdateCoverDesingPricing(form["txtCoverDesingForGraphics"].ToString(), "Graphical");
}
else
{
//addingServiceTaxwithCoverDesingpricing = Convert.ToDouble(form["txtCoverDesingForIllustrative"].ToString()) * (Convert.ToDouble(ServiceTax)) / 100;
//CoverDesingPricing = Convert.ToDouble(form["txtCoverDesingForIllustrative"].ToString()) + addingServiceTaxwithCoverDesingpricing;
BLObj.UpdateCoverDesingPricing(form["txtCoverDesingForIllustrative"].ToString(), "Illustative");
}
}
ServicePricing model = new ServicePricing();
model.ListColor = LoadColorDropDown();
model.ListIllustrationType = LoadIllTypeDropDown();
ViewBag.ClassName = "bg-success text-success";
ViewBag.ResultMessage = "Prices are changed sucessfully";
return View(model);
}
private List<Packages> LoadListofPackages()
{
System.Data.DataTable dt = new System.Data.DataTable();
BusinessLayer.BLControllers.BL_Account bl = new BusinessLayer.BLControllers.BL_Account();
dt = bl.load_ddlPackageName();
List<Packages> packages = new List<Packages>();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
packages.Add(new Packages
{
PackageId = Convert.ToInt32(dr[0]),
PackageName = dr[1].ToString(),
Amount = dr[2].ToString()
});
}
}
return packages;
}
private List<SelectListItem> LoadPackageNameDropDown()
{
System.Data.DataTable dt = new System.Data.DataTable();
BusinessLayer.BLControllers.BL_Account bl = new BusinessLayer.BLControllers.BL_Account();
dt = bl.load_ddlPackageName();
return BuildDropDownListData(dt);
}
public ActionResult UserIsActive()
{
var model = new UserIsActive();
VishwaPress.BusinessLayer.BLControllers.BL_Account bl = new BusinessLayer.BLControllers.BL_Account();
System.Data.DataTable dt = new System.Data.DataTable();
List<System.Data.DataRow> ListAllUsers = new List<System.Data.DataRow>();
dt = bl.getAllUsers();
foreach (System.Data.DataRow dr in dt.Rows)
{
ListAllUsers.Add(dr);
}
model.ListTable = ListAllUsers;
List<UserIsActive> list = new List<UserIsActive>();
foreach (System.Data.DataRow dr in dt.Rows)
{
list.Add(new UserIsActive {
UserId=int.Parse(dr[0].ToString()),
UserName= dr[1].ToString(),
Role = dr[2].ToString(),
IsActive = int.Parse(dr[3].ToString())
});
}
model.ModelList = list;
if (Request.IsAjaxRequest())
{
return PartialView("_AllUsersWebgrid", model);
}
return View(model);
}
private int CheckUserActiveORNOT(string UserName)
{
VishwaPress.BusinessLayer.BLControllers.BL_Account bl = new BusinessLayer.BLControllers.BL_Account();
System.Data.DataTable dt = new System.Data.DataTable();
dt=bl.CheckUserActiveORNOT(UserName);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0][0].ToString() == "1")
{
return 1;
}
else
return 0;
}
else
{
return 2;
}
}
public void UpdateIsActiveStatus(int UserId,int IsActive)
{
VishwaPress.BusinessLayer.BLControllers.BL_Account bl = new BusinessLayer.BLControllers.BL_Account();
System.Data.DataTable dt = new System.Data.DataTable();
bl.updateStatus(UserId, IsActive);
}
public ActionResult ForgotPassword(ForgotPassword model)
{
//var mod = new ForgotPassword();
if (model.UserName == null)
{
ModelState.AddModelError("", "User Name Required");
}
else
{
if (WebSecurity.UserExists(model.UserName))
{
System.Data.DataTable dt = new System.Data.DataTable();
VishwaPress.BusinessLayer.BLControllers.BL_Account bl = new BusinessLayer.BLControllers.BL_Account();
dt = bl.GetEmailId(model.UserName);
if (dt.Rows.Count == 1)
{
string EmailID = dt.Rows[0][0].ToString();
var token = WebSecurity.GeneratePasswordResetToken(model.UserName,5);
bl.SendMail(EmailID, model.UserName, token);
ViewBag.Success = "Your Token has been mail on your Email Account.Use it to reset password,follow provided link in mail to go to reset password page";
}
else
{
ModelState.AddModelError("", "No EmailId");
}
}
else
{
ModelState.AddModelError("", "invalid User Name !!");
}
}
return View(model);
}
public ActionResult GetActiveFeatures(int PackageID)
{
Packages p = new Packages();
BusinessLayer.BLControllers.BL_Account bl = new BusinessLayer.BLControllers.BL_Account();
p.PkgData = bl.GET_ACTIVE_Features_ByPackageID(PackageID);
return PartialView("_WebgridFeaturesOfPackage", p);
}
public ActionResult PaymentDone()
{
//Payment response
string[] payment_information = null;
int packageid = 0;
string packageamount = "";
string serviceinfo = "";
string[] requestinfo = null;
string amount = "";
//request information
if (TempData["RequestInfo"] != null)
{
requestinfo = TempData["RequestInfo"].ToString().Split(' ');
packageid = Convert.ToInt32(requestinfo[1]);
serviceinfo = requestinfo[0].ToString();
amount = requestinfo[2].ToString();
}
string UserId = Convert.ToString(Common.GetUserId(HttpContext.User.Identity.Name));
BusinessLayer.BLControllers.BL_Account bl = new BusinessLayer.BLControllers.BL_Account();
DataTable email_username = bl.GetEmailId(UserId);
// string htmlFilePath = Server.MapPath(Constants.ResetPasswordHTMLTemplate);
if (serviceinfo == "Package")
{
string htmlFilePathforpackage = Server.MapPath(Constants.PackageHTMLTemplate);
if (TempData["PaymentInformationforPackage"] != null)
{
payment_information = TempData["PaymentInformationforPackage"].ToString().Split(' ');
packageid = Convert.ToInt32(payment_information[0]);
packageamount = payment_information[1];
}
strPGResponse = Request["msg"].ToString();
Packages p = new Packages();
if (strPGResponse != "" || strPGResponse != null)
{
RequestURL objRequestURL = new RequestURL();
string strDecryptedVal = objRequestURL.VerifyPGResponse(strPGResponse, ConfigurationSettings.AppSettings["FilePath"]);
if (strDecryptedVal.StartsWith("ERROR"))
{
ViewBag.ResultMessage = strDecryptedVal;
}
else
{
strSplitDecryptedResponse = strDecryptedVal.Split('|');
GetPGRespnseData(strSplitDecryptedResponse);
if (strPG_TxnStatus == "0300")
{
p.PkgData = bl.GET_ACTIVE_Features_ByPackageID(packageid);
p.AmountAfterTransaction = packageamount;
Guid OrderID = new Guid(TempData["OrderID"].ToString());
bl.UpdateOrder(OrderID,strPG_TPSLTxnID);
DataTable dt = bl.getPackageDetails(Convert.ToInt32(UserId));
if (dt.Rows.Count > 0)
{
bl.UpdatePackageStatus(packageid, Convert.ToInt32(UserId));
bl.UpdatePayStatus(packageid, Convert.ToInt32(UserId));
}
else
{
bl.insertUserPackage(packageid, Convert.ToInt32(UserId));
bl.UpdatePayStatus(packageid, Convert.ToInt32(UserId));
}
bl.SendMailAfterPaymentDoneForPackage(email_username.Rows[0][1].ToString(), email_username.Rows[0][0].ToString(), p.PackageName, Convert.ToInt32(p.AmountAfterTransaction), htmlFilePathforpackage);
}
else
ViewBag.ResultMessage = "Transaction Fail ";
}
}
return View(p);
}
else
{
string htmlFilePathforService = Server.MapPath(Constants.ServiceHTMLTemplate);
strPGResponse = Request["msg"].ToString();
if (strPGResponse != "" || strPGResponse != null)
{
RequestURL objRequestURL = new RequestURL();
string strDecryptedVal = objRequestURL.VerifyPGResponse(strPGResponse, ConfigurationSettings.AppSettings["FilePath"]);
if (strDecryptedVal.StartsWith("ERROR"))
{
ViewBag.ResultMessage = strDecryptedVal;
}
else
{
strSplitDecryptedResponse = strDecryptedVal.Split('|');
GetPGRespnseData(strSplitDecryptedResponse);
if (strPG_TxnStatus == "0300")
{
Guid OrderID = new Guid(TempData["OrderID"].ToString());
bl.UpdateOrder(OrderID,strPG_TPSLTxnID);
if (serviceinfo == "ProofReading")
{
BusinessLayer.BLControllers.BL_ProofReading proofreading = new BusinessLayer.BLControllers.BL_ProofReading();
proofreading.UpdateProofReadingByTrxnID(packageid, serviceinfo);
bl.SendMailAfterPaymentDoenForServices(email_username.Rows[0][1].ToString(), email_username.Rows[0][0].ToString(), serviceinfo, Convert.ToDouble(amount), htmlFilePathforService);
}
if (serviceinfo == "Formatting")
{
BusinessLayer.BLControllers.BL_Formatting formating = new BusinessLayer.BLControllers.BL_Formatting();
formating.UpdateProofReadingByTrxnID(packageid, serviceinfo);
bl.SendMailAfterPaymentDoenForServices(email_username.Rows[0][1].ToString(), email_username.Rows[0][0].ToString(), serviceinfo, Convert.ToDouble(amount), htmlFilePathforService);
}
if (serviceinfo == "Illustation")
{
BusinessLayer.BLControllers.BL_Illustration Illustration = new BusinessLayer.BLControllers.BL_Illustration();
Illustration.UpdateProofReadingByTrxnID(packageid, serviceinfo);
bl.SendMailAfterPaymentDoenForServices(email_username.Rows[0][1].ToString(), email_username.Rows[0][0].ToString(), serviceinfo, Convert.ToDouble(amount), htmlFilePathforService);
}
if (serviceinfo == "CoverDesign")
{
BusinessLayer.BLControllers.BL_CoverDesign CoverDesing = new BusinessLayer.BLControllers.BL_CoverDesign();
CoverDesing.UpdateProofReadingByTrxnID(packageid, serviceinfo);
bl.SendMailAfterPaymentDoenForServices(email_username.Rows[0][1].ToString(), email_username.Rows[0][0].ToString(), serviceinfo, Convert.ToDouble(amount), htmlFilePathforService);
//return View(CoverDesign);
}
ViewBag.Message = requestinfo;
}
else
{
ViewBag.ResultMessage = "Transaction Fail ";
//ViewBag.ResultMessage = "Transaction Fail :: <br/>" + "Response :: <br/>"+ strDecryptedVal;
}
}
}
return View();
}
}
//[Authorize]
public ActionResult Packages(string message)
{
ViewBag.Message = "Packages";
ViewBag.Error = message;
Packages p = new Packages();
string UserId = "0";
try
{
UserId = Convert.ToString(Common.GetUserId(HttpContext.User.Identity.Name));
}
catch (Exception ex)
{
UserId = "0";
}
BusinessLayer.BLControllers.BL_Account bl = new BusinessLayer.BLControllers.BL_Account();
p.PkgData = bl.GetPackagesDetails(Convert.ToInt32(UserId));
return View(p);
}
