public ActionResult Index(Point model, FormCollection form)
{
try
{
if (ModelState.IsValid)
{
string statusDDLValue = form["Statusddl"].ToString();
//var clientId= entity.InsertUpdateSelectAdmin(0, model.name, model.Address, model.MobileNo, model.EmailId, genderDDLValue, model.dob, model.countryId, model.stateId, model.cityId, 1, );
using (var context = new LoyaltyManagementSystemEntities())
{
var points = new LMS_Datas.Point()
{
Points = model.Points,
Amount = model.Amount,
Active = Boolean.Parse(statusDDLValue)
};
context.Points.Add(points);
//context.ClientDetails.Add(clientDetails);
//etc add your other classes
context.SaveChanges();
}
ViewBag.alert = "Success";
return(View());
}
ViewBag.alert = "Error";
return(View(model));
}
catch (Exception e1)
{
ViewBag.alert = "Error";
return(View());
}
}
public ActionResult Index(Card1 model, FormCollection form)
{
try
{
ViewBag.Packages = new SelectList(entity.Packages.Where(models => models.Active == true), "PackagesId", "PackageName");
string statusDDLValue = form["Statusddl"].ToString();
string packageDDLValue = form["PackagesId"].ToString();
if (ModelState.IsValid)
{
using (var context = new LoyaltyManagementSystemEntities())
{
var addCard = new LMS_Datas.Card1()
{
CardName = model.CardName,
persons = model.persons,
discountPer = model.discountPer,
ValidFrom = model.ValidFrom,
ValidTo = model.ValidTo,
Activate = Boolean.Parse(statusDDLValue),
PackagesId = Convert.ToInt32(packageDDLValue)
};
context.Card1.Add(addCard);
context.SaveChanges();
ViewBag.alert = "Success";
}
}
return(View());
}
catch (Exception e1)
{
ViewBag.alert = "Error";
return(View());
}
}
public ActionResult Index(PayMode model)
{
try
{
if (ModelState.IsValid)
{
using (var context = new LoyaltyManagementSystemEntities())
{
var payMode = new LMS_Datas.PayMode()
{
PayMode1 = model.PayMode1,
Active = true
};
context.PayModes.Add(payMode);
context.SaveChanges();
}
}
ViewBag.alert = "Success";
return(View());
}
catch (Exception e1)
{
ViewBag.alert = "Error";
return(View());
}
}
public ActionResult Index(Discountper model, FormCollection form)
{
try
{
if (ModelState.IsValid)
{
string statusDDLValue = form["Statusddl"].ToString();
//var clientId= entity.InsertUpdateSelectAdmin(0, model.name, model.Address, model.MobileNo, model.EmailId, genderDDLValue, model.dob, model.countryId, model.stateId, model.cityId, 1, );
using (var context = new LoyaltyManagementSystemEntities())
{
var discountper = new LMS_Datas.Discountper()
{
Persons = model.Persons,
DiscountRate = model.DiscountRate,
Activate = Boolean.Parse(statusDDLValue)
};
context.Discountpers.Add(discountper);
context.SaveChanges();
}
ViewBag.alert = "Success";
return(View());
}
ViewBag.alert = "Error";
return(View(model));
}
catch (Exception e1)
{
ViewBag.alert = "Error";
return(View());
}
}
public ActionResult Index(CustomerViewModel model, FormCollection form, HttpPostedFileBase files)
{
try
{
if (ModelState.IsValid)
{
string statusDDLValue = form["Statusddl"].ToString();
string genderDDLValue = form["genderddl"].ToString();
using (var context = new LoyaltyManagementSystemEntities())
{
var customer = new LMS_Datas.Customer()
{
Name = model.CustomerName,
Address = model.Address,
dob = model.dob,
EmailId = model.EmailId,
MobileNo = model.MobileNo,
gender = genderDDLValue,
countryId = model.countryId,
stateId = model.stateId,
cityId = model.cityId,
Active = Boolean.Parse(statusDDLValue)
};
context.Customers.Add(customer);
context.SaveChanges();
customer.CustomerId = customer.CustomerId;
var CustomerLogin = new LMS_Datas.Login()
{
UserId = customer.CustomerId,
UserName = model.UserName,
Password = model.Password,
Activate = "true",
Role = "Customer"
};
context.Logins.Add(CustomerLogin);
context.SaveChanges();
if (files.FileName != null)
{
var ext = Path.GetExtension(files.FileName);
string myfile = customer.CustomerId + ext;
var path = Path.Combine(Server.MapPath("~/Images/CustomerProfile"), myfile);
files.SaveAs(path);
}
}
}
ViewBag.CountryDd = new SelectList(entity.countries.Where(models => models.Active == true), "countryId", "countryName");
ViewBag.alert = "Success";
return(View());
}
catch (Exception e1)
{
ViewBag.CountryDd = new SelectList(entity.countries.Where(models => models.Active == true), "countryId", "countryName");
ViewBag.alert = "Error";
return(View());
}
}
public JsonResult GetStateDdl(string countryId)
{
//List<city> lstcity = new List<city>();
int id = Convert.ToInt32(countryId);
using (LoyaltyManagementSystemEntities db = new LoyaltyManagementSystemEntities())
{
IEnumerable lststate = (db.states.Where(x => x.countryId == id)).Select(o => new
{
Stateid = o.stateId,
StateName = o.stateName
}).ToList();
return(Json(lststate, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Index(CustomerVoucher model, FormCollection form)
{
try
{
if (ModelState.IsValid)
{
string customerName = (from e in entity.Customers where e.CustomerId == model.CustomerId select e.Name).First().ToString();
string mobileNumber = (from e in entity.Customers where e.CustomerId == model.CustomerId select e.MobileNo).First().ToString();
mobileNumber = mobileNumber.Replace("(", String.Empty);
mobileNumber = mobileNumber.Replace(")", String.Empty);
mobileNumber = mobileNumber.Replace("-", String.Empty);
mobileNumber = mobileNumber.Replace(" ", String.Empty);
string vouchername = (from e in entity.Vouchers where e.VoucherId == model.VoucherId select e.VoucherName).First().ToString();
string mailId = (from e in entity.Customers where e.CustomerId == model.CustomerId select e.EmailId).First().ToString();
using (var context = new LoyaltyManagementSystemEntities())
{
var addCustomerVoucher = new LMS_Datas.CustomerVoucher()
{
CustomerId = model.CustomerId,
VoucherId = model.VoucherId,
AssignNo = model.AssignNo,
AssignOn = DateTime.Now,
Active = true
};
context.CustomerVouchers.Add(addCustomerVoucher);
//context.ClientDetails.Add(clientDetails);
//etc add your other classes
context.SaveChanges();
}
ViewBag.CustomerId = new SelectList(entity.Customers.Where(models => models.Active == true), "CustomerId", "Name");
ViewBag.VoucherId = new SelectList(entity.Vouchers.Where(models => models.Activate == true), "VoucherId", "VoucherName");
ViewBag.alert = "Success";
builder.Append("Hello " + customerName + ",").AppendLine();
builder.Append("Voucher " + vouchername + " is assigned to you. Use Voucher No. " + model.AssignNo + " for further references.").AppendLine();
builder.Append("Thanks");
//sms.send(mobileNumber, builder);
sms.send("8285601519", builder);
Mail.send(builder, "*****@*****.**", "*****@*****.**", "Voucher Assigned");
}
}
catch (Exception e1)
{
ViewBag.alert = "Error";
}
return(View());
}
public ActionResult Index(TransferVoucher model)
{
try
{
ViewBag.TransferTo = new SelectList(entity.Customers.Where(models => models.Active == true), "CustomerId", "Name");
ViewBag.TransferFrom = new SelectList(entity.Customers.Where(models => models.Active == true), "CustomerId", "Name");
ViewBag.VoucherDd = new SelectList(entity.Vouchers.Where(models => models.Activate == true), "VoucherId", "VoucherName");
if (ModelState.IsValid)
{
using (var context = new LoyaltyManagementSystemEntities())
{
var transferVoucher = new LMS_Datas.TransferVoucher()
{
TransferFromCustomerID = model.TransferFromCustomerID,
TransferToCustomerID = model.TransferToCustomerID,
VoucherID = model.VoucherID,
TranferDate = DateTime.Now
};
context.TransferVouchers.Add(transferVoucher);
context.SaveChanges();
ViewBag.alert = "Success";
string TransferFrom = (from e in entity.Customers where e.CustomerId == model.TransferFromCustomerID select e.Name).First().ToString();
string TransferTo = (from e in entity.Customers where e.CustomerId == model.TransferToCustomerID select e.Name).First().ToString();
string vouchername = (from e in entity.Vouchers where e.VoucherId == model.VoucherID select e.VoucherName).First().ToString();
string voucherno = (from e in entity.CustomerVouchers where e.VoucherId == model.VoucherID select e.AssignNo).First().ToString();
string mobileNumber = (from e in entity.Customers where e.CustomerId == model.TransferToCustomerID select e.MobileNo).First().ToString();
mobileNumber = mobileNumber.Replace(")", String.Empty);
mobileNumber = mobileNumber.Replace("-", String.Empty);
mobileNumber = mobileNumber.Replace(" ", String.Empty);
builder.Append("Hello " + TransferTo + ",").AppendLine();
builder.Append("Voucher " + vouchername + " is Transferred to you by " + TransferFrom + ". Use Voucher No. " + voucherno + " for further references.").AppendLine();
builder.Append("Thanks");
//sms.send(mobileNumber, builder);
sms.send("8285601519", builder);
Mail.send(builder, "*****@*****.**", "*****@*****.**", "Voucher Assigned");
}
}
return(View());
}
catch (Exception e1)
{
ViewBag.alert = "Error";
return(View());
}
}
public ActionResult Index(LMS_Datas.Desk model, FormCollection form, HttpPostedFileBase files)
{
try
{
if (ModelState.IsValid)
{
using (var context = new LoyaltyManagementSystemEntities())
{
var addDesk = new LMS_Datas.Desk()
{
DeskName = model.DeskName,
Password = model.Password,
DeskNo = model.DeskNo,
Active = model.Active,
UserName = model.UserName
};
context.Desks.Add(addDesk);
context.SaveChanges();
if (files.FileName != null)
{
var ext = Path.GetExtension(files.FileName);
string myfile = addDesk.DeskId + ext;
var path = Path.Combine(Server.MapPath("~/Images/DeskProfile"), myfile);
files.SaveAs(path);
}
}
ViewBag.alert = "Success";
return(View());
}
ViewBag.alert = "Error";
return(View(model));
}
catch (Exception e1)
{
ViewBag.alert = "Error";
return(View());
}
}
public ActionResult Index(Voucher model, FormCollection form)
{
try
{
if (ModelState.IsValid)
{
string statusDDLValue = form["Statusddl"].ToString();
using (var context = new LoyaltyManagementSystemEntities())
{
var addVoucher = new LMS_Datas.Voucher()
{
Activate = true,
description = model.description,
Discountper = model.Discountper,
ValidFrom = model.ValidFrom,
ValidTo = model.ValidTo,
VoucherName = model.VoucherName,
PackagesId = model.PackagesId,
persons = model.persons
};
context.Vouchers.Add(addVoucher);
//context.ClientDetails.Add(clientDetails);
//etc add your other classes
context.SaveChanges();
}
ViewBag.PackageDd = new SelectList(entity.Packages.Where(models => models.Active == true), "PackagesId", "PackageName");
ViewBag.alert = "Success";
}
}
catch (Exception e1)
{
ViewBag.alert = "Error";
}
return(View());
}
public static Login GetUserDetails(User user)
{
LoyaltyManagementSystemEntities entity = new LoyaltyManagementSystemEntities();
return((entity.Logins.Where(u => u.UserName.ToLower() == user.UserName.ToLower() && u.Password == user.Password)).FirstOrDefault());
}
public ActionResult Index(AdminViewModel model, FormCollection form, HttpPostedFileBase files)
{
try
{
if (ModelState.IsValid)
{
string statusDDLValue = form["Statusddl"].ToString();
string genderDDLValue = form["genderddl"].ToString();
//var clientId= entity.InsertUpdateSelectAdmin(0, model.name, model.Address, model.MobileNo, model.EmailId, genderDDLValue, model.dob, model.countryId, model.stateId, model.cityId, 1, );
using (var context = new LoyaltyManagementSystemEntities())
{
// Client is Admin
var admin = new LMS_Datas.Admin()
{
Name = model.ClientName,
Address = model.Address,
dob = model.dob,
EmailId = model.EmailId,
MobileNo = model.MobileNo,
gender = genderDDLValue,
countryId = model.countryId,
stateId = model.stateId,
cityId = model.cityId,
Active = Boolean.Parse(statusDDLValue)
};
context.Admins.Add(admin);
//context.ClientDetails.Add(clientDetails);
//etc add your other classes
context.SaveChanges();
admin.AdminId = admin.AdminId;
var adminLogin = new LMS_Datas.Login()
{
LoginId = admin.AdminId,
UserName = model.UserName,
Role = "Client",
Password = model.Password
};
context.Logins.Add(adminLogin);
context.SaveChanges();
if (files.FileName != null)
{
var ext = Path.GetExtension(files.FileName);
string myfile = admin.AdminId + ext;
var path = Path.Combine(Server.MapPath("~/Images/ClientProfile"), myfile);
files.SaveAs(path);
}
}
ViewBag.CountryDd = new SelectList(entity.countries.Where(models => models.Active == true), "countryId", "countryName");
ViewBag.alert = "Success";
return(View());
}
ViewBag.CountryDd = new SelectList(entity.countries.Where(models => models.Active == true), "countryId", "countryName");
ViewBag.alert = "Error";
return(View(model));
}
catch (Exception e1)
{
ViewBag.CountryDd = new SelectList(entity.countries.Where(models => models.Active == true), "countryId", "countryName");
ViewBag.alert = "Error";
return(View());
}
}
