public ActionResult AddOrEdit(GarmentViewModel sm)
{
using (ELaundryDBEntities db = new ELaundryDBEntities())
{
if (sm.GarmentId == 0)
{
tblGarment tb = new tblGarment();
tb.CategoryId = sm.CategoryId;
tb.GarmentName = sm.GarmentName;
tb.UnitPrice = sm.UnitPrice;
db.tblGarments.Add(tb);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
tblGarment tbm = db.tblGarments.Where(m => m.GarmentId == sm.GarmentId).FirstOrDefault();
tbm.CategoryId = sm.CategoryId;
tbm.GarmentName = sm.GarmentName;
tbm.UnitPrice = sm.UnitPrice;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult AddOrEdit(SettingViewModel sm)
{
using (ELaundryDBEntities db = new ELaundryDBEntities())
{
if (sm.SettingId == 0)
{
tblSetting tb = new tblSetting();
tb.DiscountRate = sm.DiscountRate;
tb.Description = sm.Description;
tb.IsActive = sm.IsActive;
db.tblSettings.Add(tb);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
tblSetting tbm = db.tblSettings.Where(m => m.SettingId == sm.SettingId).FirstOrDefault();
tbm.DiscountRate = sm.DiscountRate;
tbm.Description = sm.Description;
tbm.IsActive = sm.IsActive;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult AddOrEdit(UserViewModel sm)
{
using (ELaundryDBEntities db = new ELaundryDBEntities())
{
tblUser tb = new tblUser();
string password = Utilities.Base64Encode(sm.Password);
tb.Username = sm.Username;
tb.Password = password;
tb.Fullname = sm.Fullname;
db.tblUsers.Add(tb);
db.SaveChanges();
tblUserRole tu = new tblUserRole();
tu.RoleId = sm.RoleId;
tu.UserId = tb.UserId;
db.tblUserRoles.Add(tu);
db.SaveChanges();
tblUserBranch br = new tblUserBranch();
br.UserId = tb.UserId;
br.BranchId = sm.BranchId;
db.tblUserBranches.Add(br);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(int id = 0)
{
if (id == 0)
{
using (ELaundryDBEntities db = new ELaundryDBEntities())
{
ViewBag.Categories = db.tblCategories.ToList();
return(View(new GarmentViewModel()));
}
}
else
{
using (ELaundryDBEntities db = new ELaundryDBEntities())
{
ViewBag.Categories = db.tblCategories.ToList();
GarmentViewModel sub = new GarmentViewModel();
var menu = db.tblGarments.Where(x => x.GarmentId == id).FirstOrDefault();
sub.GarmentId = menu.GarmentId;
sub.GarmentName = menu.GarmentName;
sub.UnitPrice = menu.UnitPrice;
sub.CategoryId = menu.tblCategory.CategoryId;
return(View(sub));
}
}
}
public JsonResult GetData()
{
using (ELaundryDBEntities db = new ELaundryDBEntities())
{
MyRoleProvider mr = new MyRoleProvider();
db.Configuration.LazyLoadingEnabled = false;
List <UserViewModel> lstuser = new List <UserViewModel>();
var lst = db.tblUsers.ToList();
string[] str = new string[] { };
foreach (var item in lst)
{
string roles = "";
str = mr.GetRolesForUser(item.Username);
if (str.Length > 0)
{
foreach (var r in str)
{
roles += r.ToString() + ",";
}
roles = roles.Remove(roles.IndexOf(','));
}
tblUserBranch tbub = db.tblUserBranches.Where(u => u.UserId == item.UserId).FirstOrDefault();
tblBranch br = db.tblBranches.Where(u => u.BranchId == tbub.BranchId).FirstOrDefault();
lstuser.Add(new UserViewModel()
{
UserId = item.UserId, Username = item.Username, Fullname = item.Fullname, RoleName = roles, BranchName = br.BranchName
});
}
return(Json(new { data = lstuser }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Login(LoginViewModel l, string ReturnUrl = "")
{
using (ELaundryDBEntities db = new ELaundryDBEntities())
{
string password = Utilities.Base64Encode(l.Password);
var users = db.tblUsers.Where(a => a.Username == l.Username && a.Password == password).FirstOrDefault();
if (users != null)
{
tblUserBranch ubra = db.tblUserBranches.Where(u => u.UserId == users.UserId).FirstOrDefault();
Session.Add("branchid", ubra.BranchId);
tblBranch br = db.tblBranches.Where(b => b.BranchId == ubra.BranchId).FirstOrDefault();
Session.Add("branchname", br.BranchName);
Session.Add("username", users.Username);
Session.Add("fullname", users.Fullname);
FormsAuthentication.SetAuthCookie(l.Username, true);
if (Url.IsLocalUrl(ReturnUrl))
{
return(Redirect(ReturnUrl));
}
else
{
Session.Add("userid", users.UserId);
return(RedirectToAction("DashBoard", "Admin"));
}
}
else
{
ModelState.AddModelError("", "Invalid User");
}
}
return(View());
}
public ActionResult Delete(int id)
{
using (ELaundryDBEntities db = new ELaundryDBEntities())
{
tblSetting sm = db.tblSettings.Where(x => x.SettingId == id).FirstOrDefault();
db.tblSettings.Remove(sm);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit()
{
using (ELaundryDBEntities db = new ELaundryDBEntities())
{
ViewBag.Roles = db.tblRoles.ToList();
ViewBag.Branches = db.tblBranches.ToList();
return(View());
}
}
/// <summary>Gets the data.</summary>
/// <returns>JsonResult.</returns>
public JsonResult GetData()
{
using (ELaundryDBEntities db = new ELaundryDBEntities())
{
db.Configuration.LazyLoadingEnabled = false;
List <SettingViewModel> lst = new List <SettingViewModel>();
var empList = db.tblSettings.ToList();
foreach (var x in empList)
{
lst.Add(new SettingViewModel()
{
SettingId = x.SettingId, DiscountRate = x.DiscountRate, Description = x.Description, IsActive = x.IsActive
});
}
return(Json(new { data = lst }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetData()
{
using (ELaundryDBEntities db = new ELaundryDBEntities())
{
db.Configuration.LazyLoadingEnabled = false;
List <GarmentViewModel> lstitem = new List <GarmentViewModel>();
var lst = db.tblGarments.Include("tblCategory").ToList();
foreach (var item in lst)
{
lstitem.Add(new GarmentViewModel()
{
GarmentId = item.GarmentId, CategoryName = item.tblCategory.CategoryName, GarmentName = item.GarmentName, UnitPrice = item.UnitPrice
});
}
return(Json(new { data = lstitem }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetData()
{
using (ELaundryDBEntities db = new ELaundryDBEntities())
{
db.Configuration.LazyLoadingEnabled = false;
List <CategoryViewModel> lst = new List <CategoryViewModel>();
var empList = db.tblCategories.Select(x => new { CategoryId = x.CategoryId, CategoryName = x.CategoryName }).ToList();
foreach (var item in empList)
{
lst.Add(new CategoryViewModel()
{
CategoryId = item.CategoryId, CategoryName = item.CategoryName
});
}
return(Json(new { data = lst }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(int id = 0)
{
if (id == 0)
{
using (ELaundryDBEntities db = new ELaundryDBEntities())
{
return(View(new CategoryViewModel()));
}
}
else
{
using (ELaundryDBEntities db = new ELaundryDBEntities())
{
CategoryViewModel sub = new CategoryViewModel();
var menu = db.tblCategories.Where(x => x.CategoryId == id).FirstOrDefault();
sub.CategoryId = menu.CategoryId;
sub.CategoryName = menu.CategoryName;
return(View(sub));
}
}
}
public ActionResult AddOrEdit(int id = 0)
{
if (id == 0)
{
using (ELaundryDBEntities db = new ELaundryDBEntities())
{
return(View(new SettingViewModel()));
}
}
else
{
using (ELaundryDBEntities db = new ELaundryDBEntities())
{
SettingViewModel sub = new SettingViewModel();
var menu = db.tblSettings.Where(x => x.SettingId == id).FirstOrDefault();
sub.SettingId = menu.SettingId;
sub.DiscountRate = menu.DiscountRate;
sub.Description = menu.Description;
sub.IsActive = menu.IsActive;
return(View(sub));
}
}
}
public ActionResult SchedulePickUp(FormCollection collection)
{
try
{
// TODO: Add insert logic here
ELaundryDBEntities _db = new ELaundryDBEntities();
//Creating variable to get the value
string TimeSlot = collection["TimeSlot"];
string FullName = collection["FullName"];
string Phone = collection["Phone"];
string Email = collection["Email"];
string Address = collection["Address"];
string SecondaryAddress = collection["SecondaryAddress"];
string PickupDate = collection["PickupDate"];
string DeliveryDate = collection["DeliveryDate"];
tblSchedulePickup obj = new tblSchedulePickup();
obj.FullName = FullName;
obj.Phone = Phone;
obj.Email = Email;
obj.Address = Address;
obj.SecondaryAddress = SecondaryAddress;
obj.PickupDate = PickupDate;
obj.DeliveryDate = DeliveryDate;
obj.TimeSlot = TimeSlot;
obj.Userid = 5;
_db.tblSchedulePickups.Add(obj);
_db.SaveChanges();
return(RedirectToAction("Thankyou"));
}
catch
{
return(View());
}
}
