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 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 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 JsonResult LineChart()
{
DateTime dt = Convert.ToDateTime(DateTime.Today);
List <ClosingDisplay> lstclose = new List <ClosingDisplay>();
List <tblUserRole> lstur = _db.tblUserRoles.Where(u => u.RoleId == 2).ToList();
foreach (var ur in lstur)
{
tblUser tb = _db.tblUsers.Where(u => u.UserId == ur.UserId).FirstOrDefault();
tblUserBranch tub = _db.tblUserBranches.Where(u => u.UserId == ur.UserId).FirstOrDefault();
tblBranch tbbra = _db.tblBranches.Where(b => b.BranchId == tub.BranchId).FirstOrDefault();
decimal amount = 0M;
List <tblInvoice> lst = _db.tblInvoices.Where(t => t.InvoiceDate == dt).Where(u => u.UserId == ur.UserId).ToList();
if (lst.Count > 0)
{
foreach (var item in lst)
{
amount += Convert.ToDecimal(item.NetAmount);
}
ClosingDisplay cd = new ClosingDisplay();
cd.UserId = ur.UserId;
cd.TotalAmount = amount;
cd.Username = tb.Username;
cd.BranchName = tbbra.BranchName;
cd.BranchId = tbbra.BranchId;
lstclose.Add(cd);
}
}
List <object> iData = new List <object>();
//Creating sample data
DataTable dtt = new DataTable();
dtt.Columns.Add("Username", System.Type.GetType("System.String"));
dtt.Columns.Add("TotalAmount", System.Type.GetType("System.Decimal"));
foreach (var item in lstclose)
{
DataRow dr = dtt.NewRow();
dr["Username"] = item.Username;
dr["TotalAmount"] = item.TotalAmount;
dtt.Rows.Add(dr);
}
//Looping and extracting each DataColumn to List<Object>
foreach (DataColumn dc in dtt.Columns)
{
List <object> x = new List <object>();
x = (from DataRow drr in dtt.Rows select drr[dc.ColumnName]).ToList();
iData.Add(x);
}
//Source data returned as JSON
return(Json(iData, JsonRequestBehavior.AllowGet));
}
public ActionResult MakeClosing()
{
DateTime dt = Convert.ToDateTime(DateTime.Today);
List <ClosingDisplay> lstclose = new List <ClosingDisplay>();
List <tblUserRole> lstur = db.tblUserRoles.Where(u => u.RoleId == 2).ToList();
foreach (var ur in lstur)
{
tblUser tb = db.tblUsers.Where(u => u.UserId == ur.UserId).FirstOrDefault();
bool i = cdb.CheckClosingDate(tb.UserId);
if (!i)
{
tblUserBranch tub = db.tblUserBranches.Where(u => u.UserId == ur.UserId).FirstOrDefault();
tblBranch tbbra = db.tblBranches.Where(b => b.BranchId == tub.BranchId).FirstOrDefault();
decimal amount = 0M;
List <tblInvoice> lst = db.tblInvoices.Where(t => t.InvoiceDate == dt).Where(u => u.UserId == ur.UserId).ToList();
if (lst.Count > 0)
{
foreach (var item in lst)
{
amount += Convert.ToDecimal(item.NetAmount);
}
ClosingDisplay cd = new ClosingDisplay();
cd.UserId = ur.UserId;
cd.TotalAmount = amount;
cd.Username = tb.Username;
cd.BranchName = tbbra.BranchName;
cd.BranchId = tbbra.BranchId;
lstclose.Add(cd);
}
ViewBag.Records = lstclose;
}
}
return(View());
}
