public ActionResult Delete(int id)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
int UserID = Convert.ToInt32(Session["UserId"]);
//ViewBag.IsConfigMenu = 0;
tbllossescode tlc = db.tbllossescodes.Find(id);
tlc.IsDeleted = 1;
tlc.ModifiedBy = UserID;
tlc.ModifiedOn = System.DateTime.Now;
//start Logging
String Username = Session["Username"].ToString();
//string CompleteModificationdetail = "Deleted Parts/Item";
//ActiveLogStorage Obj = new ActiveLogStorage();
//Obj.SaveActiveLog(Action, Controller, Username, UserID, CompleteModificationdetail);
//End
db.Entry(tlc).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public tbllossescode GettbloeelossDet3(string settingString)
{
tbllossescode ddldet = new tbllossescode();
Repository <tbllossescode> lista = new Repository <tbllossescode>();
try
{
string query = "SELECT * from [" + ConnectionFactory.DB + "].[" + ConnectionFactory.Schema + "].tbllossescode WHERE IsDeleted =0 and MessageType like '%" + settingString + "%'";
ddldet = lista.GetFirstOrDefault(query, _connectionFactory.GetConnection);
}
catch (Exception ex)
{
// MessageBox.Show(ex.ToString());
}
return(ddldet);
}
public tbllossescode GetLossCodeDetails1(string MessageType)
{
tbllossescode user = new tbllossescode();
try
{
Repository <tbllossescode> lista = new Repository <tbllossescode>();
string qry = "SELECT * FROM [" + ConnectionFactory.DB + "].[" + ConnectionFactory.Schema + "].[tbllossescode] WHERE IsDeleted = 0 and LossCodesLevel1ID = 1 and MessageType ='" + MessageType + "'";
user = lista.GetFirstOrDefault(qry, _connectionFactory.GetConnection);
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString());
}
return(user);
}
public tbllossescode GetLossCodeDetails(int LossCodeID)
{
tbllossescode user = new tbllossescode();
try
{
Repository <tbllossescode> lista = new Repository <tbllossescode>();
string qry = "SELECT * FROM [" + ConnectionFactory.DB + "].[" + ConnectionFactory.Schema + "].[tbllossescode] WHERE LossCodeID =" + LossCodeID + "";
user = lista.GetFirstOrDefault(qry, _connectionFactory.GetConnection);
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString());
}
return(user);
}
public ActionResult Edit(int id)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
String Username = Session["Username"].ToString();
tbllossescode lossdata = db.tbllossescodes.Find(id);
ViewData["Level1"] = new SelectList(db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCodesLevel == 1 && m.MessageType == "BREAKDOWN" && m.LossCodeID != 9999), "LossCodeID", "LossCode", lossdata.LossCodesLevel1ID);
ViewData["Level2"] = new SelectList(db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCodesLevel == 2 && m.MessageType == "BREAKDOWN"), "LossCodeID", "LossCode", lossdata.LossCodesLevel2ID);
ViewBag.radioselected = lossdata.LossCodesLevel;
ViewData["ContributeTo"] = lossdata.ContributeTo;
return(View(lossdata));
}
public ActionResult Index()
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.UserName = Session["Username"];
ViewBag.roleid = Session["RoleID"];
String Username = Session["Username"].ToString();
ViewData["Level1"] = new SelectList(db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCodesLevel == 1 && m.MessageType != "PM"), "LossCodeID", "LossCodeDesc"); /*&& m.MessageType != "BREAKDOWN"*/
ViewData["Level2"] = new SelectList(db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCodesLevel == 29 && m.MessageType != "PM"), "LossCodeID", "LossCodeDesc");
ViewData["Level3"] = new SelectList(db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCodesLevel == 9 && m.MessageType != "PM"), "LossCodeID", "LossCodeDesc");
ProductionLossModel pa = new ProductionLossModel();
tbllossescode pe = new tbllossescode();
pa.ProductionLoss = pe;
pa.ProductionLossList = db.tbllossescodes.Where(m => m.IsDeleted == 0).ToList();//Dont take Any Loss to view, as we will display data based on Department and Category.
var query = db.tbllossescodes.Where(M => M.IsDeleted == 0).ToList();
pa.ProductionLossList = query.ToList();
return(View(pa));
}
public ActionResult Create(tbllossescode tlc, int Level1 = 0, int Level2 = 0)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
int UserID = Convert.ToInt32(Session["UserId"]);
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
tlc.CreatedBy = UserID;
tlc.CreatedOn = DateTime.Now;
tlc.IsDeleted = 0;
tlc.MessageType = "BREAKDOWN";
if (Convert.ToInt16(tlc.LossCodesLevel) == 2)
{
tlc.LossCodesLevel1ID = Level1;
var duplosscode = db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCode == tlc.LossCode && m.LossCodesLevel1ID == tlc.LossCodesLevel1ID).ToList();
if (duplosscode.Count() == 0)
{
//Here check if Level1 code is used in tbllossofentry, if so then create new copy of it with Different LossID.
var lossOfEntryData = db.tbllossofentries.Where(m => m.MessageCodeID == Level1).ToList();
if (lossOfEntryData.Count() > 0)
{
var lossPrvData = db.tbllossescodes.Where(m => m.LossCodeID == Level1 && m.IsDeleted == 0).FirstOrDefault();
tbllossescode tlcNewPrvLevel = new tbllossescode();
tlcNewPrvLevel.ContributeTo = lossPrvData.ContributeTo;
tlcNewPrvLevel.CreatedBy = lossPrvData.CreatedBy;
tlcNewPrvLevel.CreatedOn = lossPrvData.CreatedOn;
tlcNewPrvLevel.IsDeleted = 0;
tlcNewPrvLevel.LossCode = lossPrvData.LossCode;
tlcNewPrvLevel.LossCodeDesc = lossPrvData.LossCodeDesc;
tlcNewPrvLevel.LossCodesLevel = lossPrvData.LossCodesLevel;
tlcNewPrvLevel.LossCodesLevel1ID = lossPrvData.LossCodesLevel1ID;
tlcNewPrvLevel.LossCodesLevel2ID = lossPrvData.LossCodesLevel2ID;
tlcNewPrvLevel.MessageType = lossPrvData.MessageType;
tlcNewPrvLevel.ModifiedBy = lossPrvData.ModifiedBy;
tlcNewPrvLevel.ModifiedOn = lossPrvData.ModifiedOn;
db.tbllossescodes.Add(tlcNewPrvLevel);
db.SaveChanges();
//Delete the Old one.
lossPrvData.IsDeleted = 1;
lossPrvData.ModifiedOn = DateTime.Now;
lossPrvData.ModifiedBy = UserID;
db.Entry(lossPrvData).State = EntityState.Modified;
db.SaveChanges();
//Give new Level1 LossCodeID to 2nd level code.
int Level1LossCodeID = tlcNewPrvLevel.LossCodeID;
tlc.LossCodesLevel1ID = Level1LossCodeID;
}
db.tbllossescodes.Add(tlc);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
Session["Error"] = "Breakdown code already Exist.";
ViewData["Level1"] = new SelectList(db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCodesLevel == 1 && m.MessageType == "BREAKDOWN" && m.LossCodeID != 9999), "LossCodeID", "LossCode");
ViewData["Level2"] = new SelectList(db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCodesLevel == 2 && m.MessageType == "BREAKDOWN"), "LossCodeID", "LossCode");
return(View(tlc));
}
}
if (Convert.ToInt16(tlc.LossCodesLevel) == 3)
{
tlc.LossCodesLevel1ID = Level1;
tlc.LossCodesLevel2ID = Level2;
var duplosscode = db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCode == tlc.LossCode && m.LossCodesLevel1ID == tlc.LossCodesLevel1ID && m.LossCodesLevel2ID == tlc.LossCodesLevel2ID).ToList();
if (duplosscode.Count() == 0)
{
//Here check if Level1 code is used in tbllossofentry, if so then create new copy of it with Different LossID.
var lossOfEntryData = db.tbllossofentries.Where(m => m.MessageCodeID == Level2).ToList();
if (lossOfEntryData.Count() > 0)
{
var lossPrvData = db.tbllossescodes.Where(m => m.LossCodeID == Level2 && m.IsDeleted == 0).FirstOrDefault();
tbllossescode tlcNewPrvLevel = new tbllossescode();
tlcNewPrvLevel.ContributeTo = lossPrvData.ContributeTo;
tlcNewPrvLevel.CreatedBy = lossPrvData.CreatedBy;
tlcNewPrvLevel.CreatedOn = lossPrvData.CreatedOn;
tlcNewPrvLevel.IsDeleted = 0;
tlcNewPrvLevel.LossCode = lossPrvData.LossCode;
tlcNewPrvLevel.LossCodeDesc = lossPrvData.LossCodeDesc;
tlcNewPrvLevel.LossCodesLevel = lossPrvData.LossCodesLevel;
tlcNewPrvLevel.LossCodesLevel1ID = lossPrvData.LossCodesLevel1ID;
tlcNewPrvLevel.LossCodesLevel2ID = lossPrvData.LossCodesLevel2ID;
tlcNewPrvLevel.MessageType = lossPrvData.MessageType;
tlcNewPrvLevel.ModifiedBy = lossPrvData.ModifiedBy;
tlcNewPrvLevel.ModifiedOn = lossPrvData.ModifiedOn;
db.tbllossescodes.Add(tlcNewPrvLevel);
db.SaveChanges();
//Delete the Old one.
lossPrvData.IsDeleted = 1;
lossPrvData.ModifiedOn = DateTime.Now;
lossPrvData.ModifiedBy = UserID;
db.Entry(lossPrvData).State = EntityState.Modified;
db.SaveChanges();
//Give new Level1 LossCodeID to 2nd level code.
int Level2LossCodeID = tlcNewPrvLevel.LossCodeID;
tlc.LossCodesLevel2ID = Level2LossCodeID;
}
db.tbllossescodes.Add(tlc);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
Session["Error"] = "Breakdown code already Exist.";
ViewData["Level1"] = new SelectList(db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCodesLevel == 1 && m.MessageType == "BREAKDOWN" && m.LossCodeID != 9999), "LossCodeID", "LossCode");
ViewData["Level2"] = new SelectList(db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCodesLevel == 2 && m.MessageType == "BREAKDOWN"), "LossCodeID", "LossCode");
return(View(tlc));
}
}
if (Convert.ToInt16(tlc.LossCodesLevel) == 1)
{
var duplosscode = db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCode == tlc.LossCode).ToList();
if (duplosscode.Count() == 0)
{
db.tbllossescodes.Add(tlc);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
Session["Error"] = "Breakdown code already Exist.";
ViewData["Level1"] = new SelectList(db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCodesLevel == 1 && m.MessageType == "BREAKDOWN" && m.LossCodeID != 9999), "LossCodeID", "LossCode");
ViewData["Level2"] = new SelectList(db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCodesLevel == 2 && m.MessageType == "BREAKDOWN"), "LossCodeID", "LossCode");
return(View(tlc));
}
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(tbllossescode tlc, int Level1 = 0, int Level2 = 0)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
int UserID = Convert.ToInt32(Session["UserId"]);
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
tlc.ModifiedBy = UserID;
tlc.ModifiedOn = DateTime.Now;
if (Convert.ToInt16(tlc.LossCodesLevel) == 2)
{
tlc.LossCodesLevel1ID = Level1;
var duplosscode = db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCode == tlc.LossCode && m.LossCodeID != tlc.LossCodeID && m.LossCodesLevel1ID == tlc.LossCodesLevel1ID).ToList();
if (duplosscode.Count() == 0)
{
db.Entry(tlc).State = EntityState.Modified;
db.SaveChanges();
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
Session["Error"] = "Loss code already Exist.";
ViewData["Level1"] = new SelectList(db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCodesLevel == 1 && m.LossCodeID != 9999), "LossCodeID", "LossCode", tlc.LossCodesLevel1ID);
ViewData["Level2"] = new SelectList(db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCodesLevel == 2), "LossCodeID", "LossCode", tlc.LossCodesLevel2ID);
ViewBag.radioselected = tlc.LossCodesLevel;
return(View(tlc));
}
}
else if (Convert.ToInt16(tlc.LossCodesLevel) == 3)
{
tlc.LossCodesLevel1ID = Level1;
tlc.LossCodesLevel2ID = Level2;
var duplosscode = db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCode == tlc.LossCode && m.LossCodeID != tlc.LossCodeID && m.LossCodesLevel1ID == tlc.LossCodesLevel1ID && m.LossCodesLevel2ID == tlc.LossCodesLevel2ID).ToList();
if (duplosscode.Count == 0)
{
db.Entry(tlc).State = EntityState.Modified;
db.SaveChanges();
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
Session["Error"] = "Loss code already Exist.";
ViewData["Level1"] = new SelectList(db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCodesLevel == 1 && m.LossCodeID != 9999), "LossCodeID", "LossCode", tlc.LossCodesLevel1ID);
ViewData["Level2"] = new SelectList(db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCodesLevel == 2), "LossCodeID", "LossCode", tlc.LossCodesLevel2ID);
ViewBag.radioselected = tlc.LossCodesLevel;
return(View(tlc));
}
}
else if (Convert.ToInt16(tlc.LossCodesLevel) == 1)
{
var duplosscode = db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCode == tlc.LossCode && m.LossCodeID != tlc.LossCodeID).ToList();
if (duplosscode.Count() == 0)
{
db.Entry(tlc).State = EntityState.Modified;
db.SaveChanges();
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
Session["Error"] = "Loss code already Exist.";
ViewData["Level1"] = new SelectList(db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCodesLevel == 1 && m.LossCodeID != 9999), "LossCodeID", "LossCode", tlc.LossCodesLevel1ID);
ViewData["Level2"] = new SelectList(db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCodesLevel == 2), "LossCodeID", "LossCode", tlc.LossCodesLevel2ID);
ViewBag.radioselected = tlc.LossCodesLevel;
return(View(tlc));
}
}
return(RedirectToAction("Index"));
}
public ActionResult Create(ProductionLossModel objLossCode, int Level1 = 0, int Level2 = 0)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
int UserID = Convert.ToInt32(Session["UserId"]);
ViewBag.Logout = Session["Username"].ToString().ToUpper();
ViewBag.roleid = Session["RoleID"];
objLossCode.ProductionLoss.CreatedBy = UserID;
objLossCode.ProductionLoss.CreatedOn = DateTime.Now;
objLossCode.ProductionLoss.IsDeleted = 0;
//objLossCode.ProductionLoss.ServerTabCheck = 1;
//objLossCode.ProductionLoss.ServerTabFlagSync = 0;
//Check duplicate entry
var losscodelevel = objLossCode.ProductionLoss.LossCodesLevel;
var losscode = objLossCode.ProductionLoss.LossCode;
if (losscodelevel == 1)
{
var DuplicateEntry = db.tbllossescodes.Where(m => m.LossCode == losscode && m.IsDeleted == 0).ToList();
if (DuplicateEntry != null)
{
db.tbllossescodes.Add(objLossCode.ProductionLoss);
db.SaveChanges();
RedirectToAction("Index");
}
else
{
Session["Error"] = "Losscode already exists";
}
}
else if (losscodelevel == 2)
{
objLossCode.ProductionLoss.LossCodesLevel1ID = Level1;
var duplosscode = db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCode == objLossCode.ProductionLoss.LossCode && m.LossCodesLevel1ID == objLossCode.ProductionLoss.LossCodesLevel1ID).ToList();
if (duplosscode.Count == 0)
{
//Here check if Level1 code is used in tbllossofentry, if so then create new copy of it with Different LossID.
var lossOfEntryData = db.tbllossofentries.Where(m => m.MessageCodeID == Level1).ToList();
if (lossOfEntryData.Count > 0)
{
var lossPrvData = db.tbllossescodes.Where(m => m.LossCodeID == Level1 && m.IsDeleted == 0).FirstOrDefault();
tbllossescode tlcNewPrvLevel = new tbllossescode();
tlcNewPrvLevel.ContributeTo = lossPrvData.ContributeTo;
tlcNewPrvLevel.CreatedBy = lossPrvData.CreatedBy;
tlcNewPrvLevel.CreatedOn = lossPrvData.CreatedOn;
tlcNewPrvLevel.IsDeleted = 0;
tlcNewPrvLevel.LossCode = lossPrvData.LossCode;
tlcNewPrvLevel.LossCodeDesc = lossPrvData.LossCodeDesc;
tlcNewPrvLevel.LossCodesLevel = lossPrvData.LossCodesLevel;
tlcNewPrvLevel.LossCodesLevel1ID = lossPrvData.LossCodesLevel1ID;
tlcNewPrvLevel.LossCodesLevel2ID = lossPrvData.LossCodesLevel2ID;
tlcNewPrvLevel.MessageType = lossPrvData.MessageType;
tlcNewPrvLevel.ModifiedBy = lossPrvData.ModifiedBy;
tlcNewPrvLevel.ModifiedOn = lossPrvData.ModifiedOn;
//tlcNewPrvLevel.ServerTabCheck = 1;
//tlcNewPrvLevel.ServerTabFlagSync = 0;
db.tbllossescodes.Add(tlcNewPrvLevel);
db.SaveChanges();
//Delete the Old one.
lossPrvData.IsDeleted = 1;
lossPrvData.ModifiedOn = DateTime.Now;
lossPrvData.ModifiedBy = UserID;
db.Entry(lossPrvData).State = EntityState.Modified;
db.SaveChanges();
//Give new Level1 LossCodeID to 2nd level code.
int Level1LossCodeID = tlcNewPrvLevel.LossCodeID;
objLossCode.ProductionLoss.LossCodesLevel1ID = Level1LossCodeID;
}
db.tbllossescodes.Add(objLossCode.ProductionLoss);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
Session["Error"] = "Loss code already Exist.";
return(View(objLossCode));
}
}
else if (losscodelevel == 3)
{
objLossCode.ProductionLoss.LossCodesLevel1ID = Level1;
objLossCode.ProductionLoss.LossCodesLevel2ID = Level2;
var duplosscode = db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCode == objLossCode.ProductionLoss.LossCode && m.LossCodesLevel1ID == objLossCode.ProductionLoss.LossCodesLevel1ID && m.LossCodesLevel2ID == objLossCode.ProductionLoss.LossCodesLevel2ID).ToList();
if (duplosscode.Count == 0)
{
//Here check if Level1 code is used in tbllossofentry, if so then create new copy of it with Different LossID.
var lossOfEntryData = db.tbllossofentries.Where(m => m.MessageCodeID == Level2).ToList();
if (lossOfEntryData.Count > 0)
{
var lossPrvData = db.tbllossescodes.Where(m => m.LossCodeID == Level2 && m.IsDeleted == 0).FirstOrDefault();
tbllossescode tlcNewPrvLevel = new tbllossescode();
tlcNewPrvLevel.ContributeTo = lossPrvData.ContributeTo;
tlcNewPrvLevel.CreatedBy = lossPrvData.CreatedBy;
tlcNewPrvLevel.CreatedOn = lossPrvData.CreatedOn;
tlcNewPrvLevel.IsDeleted = 0;
tlcNewPrvLevel.LossCode = lossPrvData.LossCode;
tlcNewPrvLevel.LossCodeDesc = lossPrvData.LossCodeDesc;
tlcNewPrvLevel.LossCodesLevel = lossPrvData.LossCodesLevel;
tlcNewPrvLevel.LossCodesLevel1ID = lossPrvData.LossCodesLevel1ID;
tlcNewPrvLevel.LossCodesLevel2ID = lossPrvData.LossCodesLevel2ID;
tlcNewPrvLevel.MessageType = lossPrvData.MessageType;
tlcNewPrvLevel.ModifiedBy = lossPrvData.ModifiedBy;
tlcNewPrvLevel.ModifiedOn = lossPrvData.ModifiedOn;
//tlcNewPrvLevel.ServerTabCheck = 1;
//tlcNewPrvLevel.ServerTabFlagSync = 0;
db.tbllossescodes.Add(tlcNewPrvLevel);
db.SaveChanges();
//Delete the Old one.
lossPrvData.IsDeleted = 1;
lossPrvData.ModifiedOn = DateTime.Now;
lossPrvData.ModifiedBy = UserID;
db.Entry(lossPrvData).State = EntityState.Modified;
db.SaveChanges();
//Give new Level1 LossCodeID to 2nd level code.
int Level2LossCodeID = tlcNewPrvLevel.LossCodeID;
objLossCode.ProductionLoss.LossCodesLevel2ID = Level2LossCodeID;
}
db.tbllossescodes.Add(objLossCode.ProductionLoss);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
Session["Error"] = "Loss code already Exist.";
return(View(objLossCode));
}
}
return(RedirectToAction("Index"));
}
public ActionResult Delete(int id)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"].ToString().ToUpper();
ViewBag.roleid = Session["RoleID"];
var details = db.tbllossescodes.Find(id);
int lossLevel = details.LossCodesLevel;
int UserID = Convert.ToInt32(Session["UserId"]);
if (lossLevel == 1)
{
var item = db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCodesLevel1ID == id).ToList();
foreach (var it in item)
{
//it.ServerTabFlagSync = 1;
//it.ServerTabCheck = 2;
it.IsDeleted = 1;
it.ModifiedBy = UserID;
it.ModifiedOn = System.DateTime.Now;
db.SaveChanges();
}
}
else if (lossLevel == 2)
{
var item = db.tbllossescodes.Where(m => m.IsDeleted == 0 && m.LossCodesLevel2ID == id).ToList();
foreach (var it in item)
{
//it.ServerTabFlagSync = 1;
//it.ServerTabCheck = 2;
it.IsDeleted = 1;
it.ModifiedBy = UserID;
it.ModifiedOn = System.DateTime.Now;
db.SaveChanges();
}
}
int UserID1 = id;
//ViewBag.IsConfigMenu = 0;
tbllossescode tlc = db.tbllossescodes.Find(id);
//tlc.ServerTabFlagSync = 1;
//tlc.ServerTabCheck = 2;
tlc.IsDeleted = 1;
tlc.ModifiedBy = UserID;
tlc.ModifiedOn = System.DateTime.Now;
//start Logging
String Username = Session["Username"].ToString();
//string CompleteModificationdetail = "Deleted Parts/Item";
//ActiveLogStorage Obj = new ActiveLogStorage();
//Obj.SaveActiveLog(Action, Controller, Username, UserID, CompleteModificationdetail);
//End
db.Entry(tlc).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
