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 JsonResult UpdateGarmentStatus(int id)
{
tblTempOrder tb = _db.tblTempOrders.Where(k => k.TempOrderId == id).FirstOrDefault();
if (tb != null)
{
tb.ItemState = "Completed";
_db.SaveChanges();
}
return(Json(1, JsonRequestBehavior.AllowGet));
}
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 JsonResult InsertClosing(tblClosing tb)
{
tb.ClosingDateTime = DateTime.Now;
db.tblClosings.Add(tb);
db.SaveChanges();
return(Json(1, JsonRequestBehavior.AllowGet));
}
public ActionResult ChangePassword(ChangePasswordViewModel ch)
{
string username = Session["username"].ToString();
string password = Utilities.Base64Encode(ch.OldPassword);
tblUser us = _db.tblUsers.Where(u => u.Username == username && u.Password == password).FirstOrDefault();
if (us != null)
{
string newpassword = Utilities.Base64Encode(ch.NewPassword);
us.Password = newpassword;
_db.SaveChanges();
ViewBag.Message = "Change Password Successfully";
ModelState.Clear();
}
else
{
ViewBag.Message = "Wrong Old Password";
}
return(View());
}
public JsonResult InsertInvoice(tblInvoice tb)
{
tblInvoice tbl = _db.tblInvoices.OrderByDescending(ti => ti.InvoiceId).Take(1).FirstOrDefault();
tblSetting tbs = _db.tblSettings.OrderByDescending(s => s.SettingId).Take(1).FirstOrDefault();
tblInvoice t = new tblInvoice();
if (tbl != null)
{
t.InvoiceId = tbl.InvoiceId;
}
else
{
t.InvoiceId = 1;
}
t.OrderId = tb.OrderId;
decimal taxamount = Convert.ToDecimal(tb.GrossAmount * 15 / 100);
decimal grossamount = Convert.ToDecimal(tb.GrossAmount + taxamount);
decimal discountamount = Convert.ToDecimal(tbs.DiscountRate / 100 * grossamount);
t.DiscountAmount = discountamount;
t.TaxAmount = taxamount;
t.GrossAmount = tb.GrossAmount;
t.NetAmount = tb.GrossAmount + taxamount - discountamount;
t.InvoiceDate = DateTime.Today;
t.UserId = Convert.ToInt32(Session["userid"]);
t.BranchId = Convert.ToInt32(Session["branchid"]);
_db.tblInvoices.Add(t);
_db.SaveChanges();
return(Json(1, JsonRequestBehavior.AllowGet));
}
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());
}
}