//public string UpdateCustomerPrice(TMRC_CSP.Models.GridPriceList gpl) //{ // try // { // var db = new TMRC_CSP.ViewModel.Context.ConnectionStringsContext(); // if (db.ResellerCustomersPrice.Any(m => m.PriceId == gpl.Id && m.ResellerId == Account.Login._r.Id)) // { // var rcp = db.ResellerCustomersPrice.Where(m => m.PriceId == gpl.Id && m.ResellerId == Account.Login._r.Id).SingleOrDefault(); // rcp.CustomerPrice = gpl.CustomerPrice; // } // else // { // Models.ResellerCustomersPrice rcp = new Models.ResellerCustomersPrice() // { // CustomerPrice = gpl.CustomerPrice, // PriceId = gpl.Id, // ResellerId = Account.Login._r.Id, // }; // db.ResellerCustomersPrice.Add(rcp); // } // db.SaveChanges(); // return "Successfully Saved"; // } // catch(Exception ex) // { // return "Unknown error occur, Please try again."; // } //} //For Admin Only public string UpdateCustomerAndResellerPrice(TMRC_CSP.Models.GridPriceList gpl) { try { var db = new TMRC_CSP.ViewModel.Context.ConnectionStringsContext(); if (db.ResellerCustomersPrice.Any(m => m.PriceId == gpl.Id && m.ResellerId == 0)) { var rcp = db.ResellerCustomersPrice.Where(m => m.PriceId == gpl.Id && m.ResellerId == 0).SingleOrDefault(); rcp.CustomerPrice = gpl.CustomerPrice; rcp.ResellerPrice = gpl.ResellerPrice; } else { Models.ResellerCustomersPrice rcp = new Models.ResellerCustomersPrice() { CustomerPrice = gpl.CustomerPrice, PriceId = gpl.Id, ResellerPrice = gpl.ResellerPrice, ResellerId = 0, }; db.ResellerCustomersPrice.Add(rcp); } db.SaveChanges(); return("Successfully Saved"); } catch (Exception ex) { return("Unknown error occur, Please try again."); } }
public string IsValid(TMRC_CSP.Areas.Reseller.Models.ResellerLogin r) { try { if (r.Email != "" && r.Password != "") { var db = new TMRC_CSP.ViewModel.Context.ConnectionStringsContext(); if (db.Resellers.Any(m => m.Email == r.Email && m.Password == r.Password)) { TMRC_CSP.Models.Reseller res = db.Resellers.Where(m => m.Email == r.Email && m.Password == r.Password).SingleOrDefault(); HttpContext.Current.Session["Reseller"] = res; if (res.Is1stTimePassChg == false) { return("../Home/ChangePassword"); } return("../Home/Index"); } else { return("Invalid login, Please try again."); } } return("Invalid login, Please try again."); } catch (Exception ex) { return("Invalid login, Please try again."); } }
//For Reseller Only public void Save(int ResellerId, GridPriceList priceList) { try { var db = new TMRC_CSP.ViewModel.Context.ConnectionStringsContext(); //if (db.CustomerPrice.Any(m => m.PriceId == priceList.Id && m.ResellerId == ResellerId && m.Status == true)) //{ // var rcp = db.CustomerPrice.Where(m => m.PriceId == priceList.Id && m.ResellerId == ResellerId).SingleOrDefault(); // rcp.Price = priceList.CustomerPrice; //} //else //{ TMRC_CSP.Models.CustomerPrice rcp = new TMRC_CSP.Models.CustomerPrice() { PriceId = priceList.Id, Price = priceList.CustomerPrice, ResellerId = ResellerId, Status = true, }; db.CustomerPrice.Add(rcp); //} db.SaveChanges(); } catch { } }
public string Save(TMRC_CSP.Models.Reseller r) { try { var db = new TMRC_CSP.ViewModel.Context.ConnectionStringsContext(); var res = db.Resellers.Where(m => m.Email == Account.Login._r.Email && m.Password == Account.Login._r.Password).SingleOrDefault(); res.FirstName = r.FirstName; res.LastName = r.LastName; res.Address = r.Address; db.SaveChanges(); return("Successfully updated."); } catch (Exception ex) { return("Unknown error occur, Please try again."); } }
public string SavePassword(Models.ChangePassword c) { try { var db = new TMRC_CSP.ViewModel.Context.ConnectionStringsContext(); if (Login._r.Password == c.OldPassword) //Confirmation is it valid user { var res = db.Resellers.Where(m => m.Email == Login._r.Email).SingleOrDefault(); res.Password = c.NewPassword; res.Is1stTimePassChg = true; db.SaveChanges(); ViewModel.Account.Login login = new ViewModel.Account.Login(); login.SignOut(); return("Successfully Password Changed."); } return("Unknown error ocuur, Please try again."); } catch (Exception ex) { return("Unknown error ocuur, Please try again."); } }
public override TMRC_CSP.Models.TermsConditions GetTermsAndConditions() { var db = new TMRC_CSP.ViewModel.Context.ConnectionStringsContext(); return(db.TermsConditions.Where(m => m.Role == (int)TMRC_CSP.Models.Roles.Users && m.ResellerId == ViewModel.Account.Login._r.Id).SingleOrDefault()); }
public override TMRC_CSP.Models.DefaultMargin GetDefaultMargin() { var db = new TMRC_CSP.ViewModel.Context.ConnectionStringsContext(); return(db.DefaultMargin.Where(m => m.Role == (int)TMRC_CSP.Models.Roles.Users && m.ResellerId == Account.Login._r.Id).SingleOrDefault()); }