public ActionResult CreateItem(ItemVM item)
{
using (LIVEEntities db = new LIVEEntities())
{
FrdItem nw = new FrdItem();
nw.ItemNo = item.ItemNo;
nw.ItemCode = item.ItemCode;
nw.ItemName = item.ItemName;
nw.ItemDescription = item.ItemDescription;
nw.ItemType = item.ItemType;
nw.ItemTypeCode = item.ItemTypeCode;
nw.ItemUnitCode = item.ItemUnitCode;
nw.PlantCode = item.PlantCode;
nw.ItemMachineCode = item.ItemMachineCode;
nw.UnitPrice = item.UnitPrice;
nw.TaxFlag = item.TaxFlag;
nw.ConvertValue = item.ConvertValue;
nw.UseFor = item.UseFor;
nw.Show = item.Show;
nw.CreateBy = Session["Name"].ToString();
nw.CreateDate = DateTime.Now;
db.FrdItems.Add(nw);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public JsonResult CreateItem(ItemVM item, ItemVMInfo iteminf)
{
bool status = false;
string mes = "";
if (ModelState.IsValid)
{
using (LIVEEntities db = new LIVEEntities())
{
FrdItem nw = new FrdItem();
nw.ItemNo = item.ItemNo;
nw.ItemCode = item.ItemCode;
nw.ItemName = item.ItemName;
nw.ItemDescription = item.ItemDescription;
nw.ItemType = item.ItemType;
nw.ItemTypeCode = item.ItemTypeCode;
nw.ItemUnitCode = item.ItemUnitCode;
nw.PlantCode = item.PlantCode;
nw.ItemMachineCode = item.ItemMachineCode;
nw.UnitPrice = item.UnitPrice;
nw.TaxFlag = "Y";
nw.ConvertValue = item.ConvertValue;
nw.UseFor = "User recomended";
nw.Show = "N";
nw.CreateBy = Session["Name"].ToString();
nw.CreateDate = DateTime.Now;
db.FrdItems.Add(nw);
db.SaveChanges();
FrdItemInfo inf = new FrdItemInfo();
inf.PlantID = item.PlantCode;
inf.ItemID = item.ItemNo;
inf.ItemCode = item.ItemTypeCode.ToString();
inf.ItemType = item.ItemType;
//inf.ItemUse = iteminf.ItemUse;
inf.MachineID = item.ItemMachineCode;
inf.AlmariCode = iteminf.AlmariCode;
inf.AlmariDesc = "Emptynit";
inf.ItemSize = "size";
inf.RowID = iteminf.RowID;
inf.RacID = iteminf.RacID;
inf.BinID = iteminf.BinID;
inf.Location = item.Location;
db.FrdItemInfoes.Add(inf);
db.SaveChanges();
status = true;
}
}
else
{
status = false;
}
return(new JsonResult {
Data = new { status = status, mes = mes }
});
}
public ActionResult SaveData(RequestVM D)
{
bool status = false;
string mes = "";
var w = (from y in databaseManager.sUsers
where y.UserID.ToString() == User.Identity.Name
select new { y.PlantNo }).FirstOrDefault();
var wn = databaseManager.sPlants.Where(x => x.PlantNo == w.PlantNo).FirstOrDefault();
string s1 = w.PlantNo.ToString();
string s2 = string.Concat(s1 + "1000000");
int reqno = Convert.ToInt32(s2);
var maxreqno = (from n in databaseManager.FrdRequestMasters where n.PlantID == w.PlantNo select n.ReqID).DefaultIfEmpty(reqno).Max();
var maxrNo = maxreqno + 1;
int v = maxrNo;
using (LIVEEntities ddd = new LIVEEntities())
{
FrdRequestMaster dbo = new FrdRequestMaster();
{
dbo.ReqID = maxrNo;
dbo.PlantID = D.PlantID;
dbo.DeptID = D.DeptID;
dbo.ReqDate = DateTime.Today;
dbo.CustomerID = Convert.ToInt32(User.Identity.Name);
dbo.RefNo = D.RefNo;
dbo.Remarks = D.Remarks;
dbo.Status = "I";
dbo.CreateDate = DateTime.Now;
dbo.CreateBy = User.Identity.Name;
};
ddd.FrdRequestMasters.Add(dbo);
foreach (var i in D.reqdtl)
{
FrdRequestDetail obd = new FrdRequestDetail();
{
obd.PlantID = D.PlantID;
obd.ReqID = maxrNo;
obd.ItemID = i.ItemID;
obd.Quantity = i.Quantity;
obd.UnitPrice = 0;
obd.TotalAmt = 0;
ddd.FrdRequestDetails.Add(obd);
}
}
ddd.SaveChanges();
status = true;
ddd.Dispose();
ModelState.Clear();
}
return(new JsonResult {
Data = new { status = status, mes = mes, v = v }
});
}
public ActionResult UserRight()
{
LIVEEntities db = new LIVEEntities();
ViewBag.UserID = new SelectList(db.sUsers, "UserID", "UserName");
//ViewBag.PageType = new SelectList(db.sPageNames, "PageType", "PageType");
var tCode = new SelectList(
new[]
{
new { ID = 2, Name = "Reports" },
new { ID = 1, Name = "Forms" },
},
"ID",
"Name"
);
ViewBag.PageType = tCode;
return(View("UserRight"));
}
public ActionResult Create(FrdSupplier frdSupplier)
{
LIVEEntities db = new LIVEEntities();
try
{
if (ModelState.IsValid)
{
FrdSupplier sp = new FrdSupplier();
sp.SupplierID = frdSupplier.SupplierID;
sp.SupplierCode = frdSupplier.SupplierCode;
sp.SupplierName = frdSupplier.SupplierName;
sp.SupplierAddress = frdSupplier.SupplierAddress;
sp.PhoneNumber = frdSupplier.PhoneNumber;
sp.MobileNumber = frdSupplier.MobileNumber;
sp.EmailAddress = frdSupplier.EmailAddress;
sp.ZoneCode = frdSupplier.ZoneCode;
sp.BranchCode = frdSupplier.BranchCode;
sp.Remarks = frdSupplier.Remarks;
sp.VATRegNo = "222";
sp.Status = "ACT";
db.FrdSuppliers.Add(sp);
db.SaveChanges();
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
return(RedirectToAction("Index"));
}
public JsonResult GetMenuList(int inType)
{
using (LIVEEntities db = new LIVEEntities())
{
try
{
var MenuData = db.sPageNames.Where(x => x.PageType == inType).ToList();
//var xv = MenuData.Count();
return(new JsonResult {
Data = MenuData, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
catch (Exception ex)
{
return(Json(new { status = "error", message = "Not Assign" }));
throw ex;
}
}
}
public JsonResult GetProductData(int itemno)
{
string IDesc;
try
{
using (LIVEEntities data = new LIVEEntities())
{
var ii = (from x in data.FrdItems where x.ItemNo == itemno select x).FirstOrDefault();
IDesc = ii.ItemDescription;
}
return(new JsonResult {
Data = IDesc, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
catch (Exception ex)
{
return(Json(new { status = "error", message = "ItemNot Found" }));
throw ex;
}
}
public ActionResult CreateUser(UserReqVM user)
{
using (LIVEEntities db = new LIVEEntities())
{
sUser nw = new sUser();
nw.UserID = user.UserID;
nw.UserName = user.UserName;
nw.UserPass = user.UserPass;
nw.UserPin = user.UserPin;
nw.RoleId = user.RoleId;
nw.MobileNo = user.MobileNo;
nw.PlantNo = user.PlantNo;
nw.Email = user.Email;
nw.UserStatus = "ACT";
nw.LoginType = "A";
nw.ActiveSession = 0;
nw.CreateBy = User.Identity.Name;
nw.CreateDate = DateTime.Now;
db.sUsers.Add(nw);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
// GET: UserManage
public ActionResult Index()
{
LIVEEntities db = new LIVEEntities();
List <sRole> role = db.sRoles.ToList();
ViewBag.RoleID = new SelectList(db.sRoles, "RoleID", "RoleName");
var data = db.sPlants.Select(s => new
{
Text = s.PlantNo + "---" + s.PlantCode + " --- " + s.PlantName,
Value = s.PlantNo
}).ToList();
ViewBag.PlantNo = new SelectList(data, "Value", "Text");
int value = db.sUsers.Max(a => a.UserID);
int num = value;
sUser usr = new sUser
{
UserID = (num + 1),
};
return(View(usr));
}
public ActionResult Login(LoginVM model, string returnUrl)
{
try
{
if (ModelState.IsValid)
{
var loginInfo = this.databaseManager.spUserLoginToApplication(model.UserID, model.UserPass, 0.ToString()).ToList();
if (loginInfo != null && loginInfo.Count() > 0)
{
// Initialization.
var logindetails = loginInfo.First();
// Login In.
// var sid = logindetails.UserName;
var sid = logindetails.userId;
this.SignInUser(sid.ToString(), false);
// Info.
// return this.RedirectToLocal(returnUrl);
// for menu
bool isExist = false;
using (LIVEEntities dc = new LIVEEntities())
{
isExist = dc.sUsers.Where(x => x.UserID == model.UserID).Any();
if (isExist)
{
LoginData loginCredentials = dc.sUsers.Where(x => x.UserID == model.UserID).Select(x => new LoginData
{
UserName = x.UserName,
RoleId = x.RoleId,
UserID = x.UserID
}).FirstOrDefault();
List <MenuData> menus = dc.sUserPages.Where(x => x.RoleID == loginCredentials.RoleId && x.UserID == loginCredentials.UserID && x.Status == "ACT").Select(x => new MenuData
{
MenuID = x.sMenu.MenuID,
MenuName = x.sMenu.MenuName,
PageCode = x.PageCode,
PageDescription = x.PageDescription,
ContName = x.ContName,
PageName = x.PageName,
RoleId = x.RoleID,
UserID = x.UserID,
RoleName = x.sRole.RoleName
}).ToList();
FormsAuthentication.SetAuthCookie(loginCredentials.UserID.ToString(), false);
Session["LoginCredentials"] = loginCredentials;
Session["MenuMaster"] = menus;
Session["Name"] = loginCredentials.UserID;
return(this.RedirectToLocal(returnUrl));
}
else
{
ViewBag.ErrorMsg = "Please enter the valid credentials!...";
return(View("Index"));
}
}
}
else
{
// Setting.
ModelState.AddModelError(string.Empty, "Invalid UserName or Password..Please check");
}
}
}
catch (Exception ex)
{
// Info
Console.Write(ex);
}
return(this.View(model));
}
