//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());
}
