//-----------------------------Populate clients on the table----------------------------
public ActionResult Index()
{
LaunSysDBEntities db = new LaunSysDBEntities();
List <tb_Titles> TitleList = db.tb_Titles.ToList();
ViewBag.VTitleLists = new SelectList(TitleList, "TitleID", "Title");
List <tb_Gender> GenderList = db.tb_Gender.ToList();
ViewBag.VGenderLists = new SelectList(GenderList, "GenderID", "Gendername");
List <ClientsViewModel> ClientsList = db.tb_Customers.Where(x => x.IsNotActive == false).Select(x => new ClientsViewModel
{
Title = x.tb_Titles.Title,
SurName = x.SurName,
OtherNames = x.OtherNames,
Gendername = x.tb_Gender.Gendername,
Cust_Address = x.Cust_Address,
Phone = x.Phone,
Email = x.Email,
CreatedDate = x.CreatedDate,
CustID = x.CustID
}).ToList();
ViewBag.ListOfClients = ClientsList;
return(View());
}
//-----------------------------to view client details individually----------------------------
public ActionResult ViewClient(int CustID)
{
LaunSysDBEntities db = new LaunSysDBEntities();
List <ClientsViewModel> ClientDetail = db.tb_Customers.Where
(x => x.IsNotActive == false && x.CustID == CustID)
.Select(x => new ClientsViewModel
{
Title = x.tb_Titles.Title,
SurName = x.SurName,
OtherNames = x.OtherNames,
Gendername = x.tb_Gender.Gendername,
Cust_Address = x.Cust_Address,
Phone = x.Phone,
Email = x.Email,
CreatedDate = x.CreatedDate,
CustID = x.CustID
}).ToList();
ViewBag.SingleClientDetail = ClientDetail;
return(PartialView("SingleClientView"));
}
//-----------------------------Add Edit----------------------------
public ActionResult AddEdit(int CustID)
{
LaunSysDBEntities db = new LaunSysDBEntities();
List <tb_Titles> TitleList = db.tb_Titles.ToList();
ViewBag.VTitleLists = new SelectList(TitleList, "TitleID", "Title");
List <tb_Gender> GenderList = db.tb_Gender.ToList();
ViewBag.VGenderLists = new SelectList(GenderList, "GenderID", "Gendername");
ClientsViewModel Model = new ClientsViewModel();
if (CustID > 0)
{
tb_Customers Cust = db.tb_Customers.SingleOrDefault(x => x.CustID == CustID && x.IsNotActive == false);
Model.CustID = Cust.CustID;
Model.TitleID = Cust.TitleID;
Model.SurName = Cust.SurName;
Model.OtherNames = Cust.OtherNames;
Model.GenderID = Cust.GenderID;
Model.Cust_Address = Cust.Cust_Address;
Model.Phone = Cust.Phone;
Model.Email = Cust.Email;
Model.CreatedDate = Cust.CreatedDate;
}
return(PartialView("AddEditViewPartialView", Model));
}
//-----------------------------Add Edit----------------------------
public ActionResult AddEdit(int Id)
{
LaunSysDBEntities db = new LaunSysDBEntities();
List <tb_Branch> BranchList = db.tb_Branch.ToList();
ViewBag.VBranchLists = new SelectList(BranchList, "BranchId", "Branchname");
List <tb_Status> StatusList = db.tb_Status.ToList();
ViewBag.VStatusLists = new SelectList(StatusList, "StatusId", "Status");
//initialize the View model responsible for the Editing
//To get the record that is to be edited
IncomesViewModel Model = new IncomesViewModel();
if (Id > 0)
{
tb_Income Income = db.tb_Income.SingleOrDefault(x => x.Id == Id && x.tb_Status.Status == true);
Model.Id = Income.Id;
Model.Date = Income.Date;
Model.Inc_SN = Income.Inc_SN;
Model.Description = Income.Description;
Model.Inv_No = Income.Inv_No;
Model.Amount = Income.Amount;
Model.BranchId = Income.BranchId;
Model.StatusId = Income.StatusId;
}
return(PartialView("AddEditViewPartialView", Model));
}
// to activate Authorization = [AuthorizeRoles(admin,accountant)]
// to add default route = [Route("x/x/{parameter 1}/{parameter 2}")]
// to pass parameter by exception = public ActionResult Index( string Id, ClientsViewModel Model)
public ActionResult Index(ClientsViewModel Model)
{
try
{
//if (ModelState.IsValid == true)
//{
LaunSysDBEntities db = new LaunSysDBEntities();
//------------------------To populate the drop down lists---------------------------
List <tb_Titles> TitleList = db.tb_Titles.ToList();
ViewBag.VTitleLists = new SelectList(TitleList, "TitleID", "Title");
List <tb_Gender> GenderList = db.tb_Gender.ToList();
ViewBag.VGenderLists = new SelectList(GenderList, "GenderID", "Gendername");
//----------------------------------------------------------------------------------
if (Model.CustID > 0)
{
//UPDATE EXISTING RECORD
tb_Customers Clients = db.tb_Customers.SingleOrDefault(x => x.CustID == Model.CustID && x.IsNotActive == false);
Clients.TitleID = Model.TitleID;
Clients.SurName = Model.SurName;
Clients.OtherNames = Model.OtherNames;
Clients.GenderID = Model.GenderID;
Clients.Cust_Address = Model.Cust_Address;
Clients.Phone = Model.Phone;
Clients.Email = Model.Email;
Clients.CreatedDate = Model.CreatedDate;
db.SaveChanges();
}
else
{
//INSERT NEW RECORD
tb_Customers Clients = new tb_Customers();
Clients.TitleID = Model.TitleID;
Clients.SurName = Model.SurName;
Clients.OtherNames = Model.OtherNames;
Clients.GenderID = Model.GenderID;
Clients.Cust_Address = Model.Cust_Address;
Clients.Phone = Model.Phone;
Clients.Email = Model.Email;
Clients.CreatedDate = Model.CreatedDate;
Clients.IsNotActive = false;
db.tb_Customers.Add(Clients);
db.SaveChanges();
}
return(View(Model));
//}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult GetData()
{
using (LaunSysDBEntities db = new LaunSysDBEntities())
{
List <tb_Incoming_Fabrics> incFab = db.tb_Incoming_Fabrics.ToList <tb_Incoming_Fabrics>();
return(Json(new { data = incFab }, JsonRequestBehavior.AllowGet));
}
}
//-----------------------------to view User details individually----------------------------
public ActionResult ViewUser(int UserId)
{
LaunSysDBEntities db = new LaunSysDBEntities();
List <UsersViewModel> UserDetail = db.tb_Users.Where(x => x.tb_Status.Status == true && x.UserId == UserId).Select(x => new UsersViewModel {
Email = x.Email, Password = x.Password, Rolename = x.tb_Role.Rolename, Divisionname = x.tb_Division.Divisionname, Status = x.tb_Status.Status, Branchname = x.tb_Branch.Branchname, Deptname = x.tb_Department.Deptname, UserId = x.UserId
}).ToList();
ViewBag.SingleUserDetail = UserDetail;
return(PartialView("SingleUserView"));
}
//-----------------------------Delete client----------------------------
public JsonResult DeleteClient(int CustID)
{
LaunSysDBEntities db = new LaunSysDBEntities();
bool result = false;
tb_Customers Cust = db.tb_Customers.SingleOrDefault(x => x.IsNotActive == false && x.CustID == CustID);
if (Cust != null)
{
//set the customer id to true, there fore hide it from the table\
Cust.IsNotActive = true;
db.SaveChanges();
result = true;
}
//FlashMessage.Info("Invalid Login Details");
return(Json(result, JsonRequestBehavior.AllowGet));
}
//-----------------------------Delete User----------------------------
public JsonResult DeleteUser(int UserId)
{
LaunSysDBEntities db = new LaunSysDBEntities();
bool result = false;
tb_Users User = db.tb_Users.SingleOrDefault(x => x.StatusId == 1 && x.UserId == UserId);
/// tb_Users User = db.tb_Users.SingleOrDefault(x => x.tb_Status.Status == true && x.UserId == UserId);
if (User != null)
{
//set the customer id to true, there fore hide it from the table\
//User.tb_Status.Status = false;
User.StatusId = 2;
db.SaveChanges();
result = true;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
//-----------------------------Delete Income----------------------------
public JsonResult DeleteIncome(int Id)
{
LaunSysDBEntities db = new LaunSysDBEntities();
bool result = false;
//tb_Income Income = db.tb_Income.SingleOrDefault(x => x.StatusId == 1 && x.Id == Id);
tb_Income Income = db.tb_Income.SingleOrDefault
(x => x.tb_Status.Status == true && x.Id == Id);
if (Income != null)
{
//set the customer id to true, there fore hide it from the table\
// Income.tb_Status.Status = false;
Income.StatusId = 2;
db.SaveChanges();
result = true;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
//-----------------------------Add/Edit----------------------------
public ActionResult AddEdit(int UserId)
{
LaunSysDBEntities db = new LaunSysDBEntities();
List <tb_Role> RoleList = db.tb_Role.ToList();
ViewBag.VRoleLists = new SelectList(RoleList, "RoleId", "Rolename");
List <tb_Division> DivisionList = db.tb_Division.ToList();
ViewBag.VDivisionLists = new SelectList(DivisionList, "DivisionId", "Divisionname");
List <tb_Branch> BranchList = db.tb_Branch.ToList();
ViewBag.VBranchLists = new SelectList(BranchList, "BranchId", "Branchname");
List <tb_Department> DeptList = db.tb_Department.ToList();
ViewBag.VDeptLists = new SelectList(DeptList, "DeptId", "Deptname");
List <tb_Status> StatusList = db.tb_Status.ToList();
ViewBag.VStatusLists = new SelectList(StatusList, "StatusId", "Status");
UsersViewModel Model = new UsersViewModel();
if (UserId > 0)
{
tb_Users Users = db.tb_Users.SingleOrDefault(x => x.UserId == UserId && x.tb_Status.Status == true);
Model.UserId = Users.UserId;
Model.Email = Users.Email;
Model.Password = Users.Password;
Model.RoleId = Users.RoleId;
Model.DivisionId = Users.DivisionId;
Model.BranchId = Users.BranchId;
Model.DeptId = Users.DeptId;
Model.StatusId = Users.StatusId;
}
return(PartialView("AddEditViewPartialView", Model));
}
//-----------------------------Populate clients on the table----------------------------
// GET: Users
public ActionResult Index()
{
LaunSysDBEntities db = new LaunSysDBEntities();
List <tb_Role> RoleList = db.tb_Role.ToList();
ViewBag.VRoleLists = new SelectList(RoleList, "RoleId", "Rolename");
List <tb_Division> DivisionList = db.tb_Division.ToList();
ViewBag.VDivisionLists = new SelectList(DivisionList, "DivisionId", "Divisionname");
List <tb_Branch> BranchList = db.tb_Branch.ToList();
ViewBag.VBranchLists = new SelectList(BranchList, "BranchId", "Branchname");
List <tb_Department> DeptList = db.tb_Department.ToList();
ViewBag.VDeptLists = new SelectList(DeptList, "DeptId", "Deptname");
List <tb_Status> StatusList = db.tb_Status.ToList();
ViewBag.VStatusLists = new SelectList(StatusList, "StatusId", "Status");
List <UsersViewModel> UsersList = db.tb_Users.Where(x => x.tb_Status.Status == true).Select(
x => new UsersViewModel {
Email = x.Email,
Password = x.Password,
Rolename = x.tb_Role.Rolename,
Divisionname = x.tb_Division.Divisionname,
Status = x.tb_Status.Status,
Branchname = x.tb_Branch.Branchname,
Deptname = x.tb_Department.Deptname,
UserId = x.UserId
}).ToList();
ViewBag.ListOfUsers = UsersList;
return(View());
}
//-----------------------------to view Income details individually----------------------------
public ActionResult ViewIncome(int Id)
{
LaunSysDBEntities db = new LaunSysDBEntities();
List <IncomesViewModel> IncomeDetail = db.tb_Income.Where(x => x.tb_Status.Status == true && x.Id == Id).Select(
x => new IncomesViewModel
{
Date = x.Date,
Inc_SN = x.Inc_SN,
Description = x.Description,
Inv_No = x.Inv_No,
Amount = x.Amount,
Branchname = x.tb_Branch.Branchname,
Id = x.Id,
Status = x.tb_Status.Status
}).ToList();
ViewBag.SingleIncomeDetail = IncomeDetail;
return(PartialView("SingleIncomeView"));
}
public ActionResult LoginUser(UsersViewModel Model)
{
if (ModelState.IsValid)
{
string result = "fail";
if (Model.Email == "*****@*****.**" && Model.Password == "admin")
{
Session["Email"] = "*****@*****.**";
Session["Password"] = "******";
Session["UserDepartment"] = "Default";
Session["UserRole"] = "Admin";
result = "Admin";
return(RedirectToAction("Index", "Clients"));
}
else
{
LaunSysDBEntities db = new LaunSysDBEntities();
var pass = System.Text.Encoding.UTF8.GetBytes(Model.Password);
var encpass = Convert.ToBase64String(pass);
tb_Users User = db.tb_Users.SingleOrDefault(x => x.Email == Model.Email && x.Password == encpass);
//tb_Users User = db.tb_Users.SingleOrDefault(x => x.Email == Model.Email && x.Password == Model.Password);
if (User != null)
{
Session["Email"] = User.Email;
Session["Password"] = User.Password;
if (User.tb_Department.Deptname != null)
{
Session["UserDepartment"] = User.tb_Department.Deptname;
}
Session["UserRole"] = User.tb_Role.Rolename;
if (User.RoleId == 1)
{
result = "Admin";
return(RedirectToAction("Index", "Clients"));
}
else if (User.RoleId == 2)
{
result = "Manager";
return(RedirectToAction("Index", "Home"));
}
}
else
{
//FlashMessage.Info("Your informational message");
//FlashMessage.Confirmation("Your confirmation message");
//FlashMessage.Warning("Your warning message");
//FlashMessage.Danger("Your danger alert");
//FlashMessage.Danger("Message title", "Your danger alert");
FlashMessage.Confirmation("Invalid Login Details");
return(RedirectToAction("Login", "Access"));
// return RedirectToAction("Index", "Users");
}
if (result == "fail")
{
FlashMessage.Confirmation("Invalid Login failed");
return(RedirectToAction("Login", "Access"));
///return RedirectToAction("Index", "Users");
}
//if (result == "Admin")
//{
// return RedirectToAction("Index", "Clients");
//}
//if (result == "Manager")
//{
//}
//return Json(result, JsonRequestBehavior.AllowGet);
}
}
return(View());
}
public JsonResult SaveIncomingfabric(IncomingFabricsViewModel IncfabricData)
{
bool status = false;
//if (ModelState.IsValid)
//{
//------------------alternatively--------------
//tb_Incoming_Fabrics incFab = new tb_Incoming_Fabrics();
//incFab.BranchId = IncfabricData.BranchId;
//incFab.Branch_Name = IncfabricData.Branchname;
//incFab.CustomerId = IncfabricData.CustomerId;
//incFab.Customer_Name = IncfabricData.Customer_Name;
//incFab.Date_Recorded = DateTime.Now;
//incFab.Receipt_No = IncfabricData.Receipt_No;
//incFab.Total_Amt = IncfabricData.Total_Amt;
//incFab.Recorded_By = Session["Email"].ToString();
//db.tb_Incoming_Fabrics.Add(incFab);
//foreach (var IndFab in IncfabricData.Incoming_Fabric_Desc)
//{
// IndFab.IncFabId = incFab.IncFabId;
// incFab.tb_Incoming_Fabric_Desc.Add(IndFab);
//}
//db.tb_Incoming_Fabrics.Add(incFab);
//db.SaveChanges();
//status = true;
//------------------end of alternatively--------------
using (LaunSysDBEntities IncFabDetail = new LaunSysDBEntities())
{
tb_Incoming_Fabrics FabInfo = new tb_Incoming_Fabrics
{
BranchId = IncfabricData.BranchId,
//Branch_Name = IncfabricData.Branch_Name,
CustomerId = IncfabricData.CustomerId,
//Customer_Name = IncfabricData.Customer_Name,
Date_Recorded = DateTime.Now,
Receipt_No = IncfabricData.Receipt_No,
Total_Amt = IncfabricData.Total_Amt,
Recorded_By = Session["Email"].ToString(),
};
//tb_Incoming_Fabrics FabInfo = new tb_Incoming_Fabrics
//{
// CustomerId = 990
//};
IncFabDetail.tb_Incoming_Fabrics.Add(FabInfo);
IncFabDetail.SaveChanges();
foreach (var IndfabDetail in IncfabricData.Incoming_Fabric_Desc)
{
//FabInfo.tb_Incoming_Fabric_Desc.Add(IndfabDetail);
IndfabDetail.IncFabId = FabInfo.IncFabId;
IncFabDetail.tb_Incoming_Fabric_Desc.Add(IndfabDetail);
}
//IncFabDetail.tb_Incoming_Fabrics.Add(FabInfo);
//tb_Incoming_Fabric_Desc FabDescription = new tb_Incoming_Fabric_Desc()
//{
// Description = IncfabricData.Incoming_Fabric_Desc.
//};
//IncFabDetail.tb_Incoming_Fabric_Desc.Add()
//IncFabDetail.tb_Incoming_Fabrics.Add(FabInfo);
IncFabDetail.SaveChanges();
status = true;
}
//----------------------------------------------------------
//using (LaunSysDBEntities IncFabDetail = new LaunSysDBEntities())
// {
// tb_Incoming_Fabrics FabInfo = new tb_Incoming_Fabrics
// {
// BranchId = IncfabricData.BranchId,
// Branch_Name = IncfabricData.Branch_Name,
// CustomerId = IncfabricData.CustomerId,
// Customer_Name = IncfabricData.Customer_Name,
// Date_Recorded = DateTime.Now,
// Receipt_No = IncfabricData.Receipt_No,
// Total_Amt = IncfabricData.Total_Amt,
// Recorded_By = Session["Email"].ToString(),
// };
// IncFabDetail.tb_Incoming_Fabrics.Add(FabInfo);
// IncFabDetail.SaveChanges();
// int X = FabInfo.IncFabId;
// foreach(var IndfabDetail in IncfabricData.Incoming_Fabric_Desc)
// {
// IndfabDetail.IncFabId = X;
// FabInfo.tb_Incoming_Fabric_Desc.Add(IndfabDetail);
// IncFabDetail.SaveChanges();
// };
// status = true;
// }
//-----------------------------------------------another---------------------
//}
//else
//{
// status = false;
//}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult Index(UsersViewModel Model)
{
try
{
//if (ModelState.IsValid == true)
//{
LaunSysDBEntities db = new LaunSysDBEntities();
//------------------------To populate the drop down lists---------------------------
List <tb_Role> RoleList = db.tb_Role.ToList();
ViewBag.VRoleLists = new SelectList(RoleList, "RoleId", "Rolename");
List <tb_Division> DivisionList = db.tb_Division.ToList();
ViewBag.VDivisionLists = new SelectList(DivisionList, "DivisionId", "Divisionname");
List <tb_Branch> BranchList = db.tb_Branch.ToList();
ViewBag.VBranchLists = new SelectList(BranchList, "BranchId", "Branchname");
List <tb_Department> DeptList = db.tb_Department.ToList();
ViewBag.VDeptLists = new SelectList(DeptList, "DeptId", "Deptname");
List <tb_Status> StatusList = db.tb_Status.ToList();
ViewBag.VStatusLists = new SelectList(StatusList, "StatusId", "Status");
//----------------------------------------------------------------------------------
if (Model.UserId > 0)
{
//UPDATE EXISTING RECORD
tb_Users Users = db.tb_Users.SingleOrDefault(x => x.UserId == Model.UserId && x.tb_Status.Status == true);
Users.UserId = Model.UserId;
Users.Email = Model.Email;
Users.Password = Model.Password;
Users.RoleId = Model.RoleId;
Users.DivisionId = Model.DivisionId;
Users.BranchId = Model.BranchId;
Users.DeptId = Model.DeptId;
Users.StatusId = Model.StatusId;
db.SaveChanges();
}
else
{
//INSERT NEW RECORD
tb_Users Users = new tb_Users();
Users.UserId = Model.UserId;
Users.Email = Model.Email;
var pass = System.Text.Encoding.UTF8.GetBytes(Model.Password);
Users.Password = Convert.ToBase64String(pass);
// Users.Password = Model.Password;
Users.RoleId = Model.RoleId;
Users.DivisionId = Model.DivisionId;
Users.BranchId = Model.BranchId;
Users.DeptId = Model.DeptId;
Users.StatusId = Model.StatusId;
db.tb_Users.Add(Users);
db.SaveChanges();
}
return(View(Model));
//}
}
catch (Exception ex)
{
throw ex;
}
}
