// GET: AccidentM/Delete/5
public ActionResult Delete(int?id, int?acid)
{
if (Session["OnlineUser"] != null)
{
if (Session["UserRole"].Equals("SUPERADMIN") || Session["UserRole"].Equals("ADMIN") || Session["UserRole"].Equals("SUBADMIN") || Session["UserRole"].Equals("OPRATOR"))
{
ViewBag.OnlineUser = Session["UserName"].ToString();
ViewBag.OnlineUserRole = Session["UserRole"].ToString();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_AccidentM tbl_AccidentM = db.tbl_AccidentM.FirstOrDefault(x => x.AccidentId == acid && x.MaterialId == id);
if (tbl_AccidentM == null)
{
return(HttpNotFound());
}
return(View(tbl_AccidentM));
}
else
{
return(RedirectToAction("Accessdenied", "Home"));
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public ActionResult Edit([Bind(Include = "AccidentMid,AccidentId,MaterialId,tedad")] tbl_AccidentM tbl_AccidentM)
{
if (Session["OnlineUser"] != null)
{
if (Session["UserRole"].Equals("SUPERADMIN") || Session["UserRole"].Equals("ADMIN") || Session["UserRole"].Equals("SUBADMIN") || Session["UserRole"].Equals("OPRATOR"))
{
ViewBag.OnlineUser = Session["UserName"].ToString();
ViewBag.OnlineUserRole = Session["UserRole"].ToString();
if (ModelState.IsValid)
{
db.Entry(tbl_AccidentM).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Edit", "Accident", new { id = tbl_AccidentM.AccidentId }));
}
}
else
{
return(RedirectToAction("Accessdenied", "Home"));
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
ViewBag.AccidentId = new SelectList(db.tbl_Accident, "AccidentId", "AccidentEventLocation", tbl_AccidentM.AccidentId);
ViewBag.MaterialId = new SelectList(db.tbl_Material, "MaterialId", "MaterialCode", tbl_AccidentM.MaterialId);
return(View(tbl_AccidentM));
}
// GET: AccidentM/Delete/5
public ActionResult Delete(int?id, int?acid)
{
try
{
if (Session["OnlineUser"] != null)
{
if (Session["UserRole"].Equals("SUPERADMIN") || Session["UserRole"].Equals("ADMIN") || Session["UserRole"].Equals("SUBADMIN") || Session["UserRole"].Equals("OPRATOR"))
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_AccidentM tbl_AccidentM = db.tbl_AccidentM.FirstOrDefault(x => x.AccidentId == acid && x.MaterialId == id);
if (tbl_AccidentM == null)
{
return(HttpNotFound());
}
return(View(tbl_AccidentM));
}
else
{
return(RedirectToAction("Accessdenied", "Home"));
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
catch (Exception ex)
{
ModelState.AddModelError(ex.Message, ex.InnerException.ToString());
return(View());
}
}
public ActionResult DeleteConfirmed(int id, int acid)
{
try
{
if (Session["OnlineUser"] != null)
{
if (Session["UserRole"].Equals("SUPERADMIN") || Session["UserRole"].Equals("ADMIN") || Session["UserRole"].Equals("SUBADMIN") || Session["UserRole"].Equals("OPRATOR"))
{
ViewBag.OnlineUser = Session["UserName"].ToString();
ViewBag.OnlineUserRole = Session["UserRole"].ToString();
tbl_AccidentM tbl_AccidentM = db.tbl_AccidentM.FirstOrDefault(x => x.AccidentId == acid && x.MaterialId == id);
db.tbl_AccidentM.Remove(tbl_AccidentM);
db.SaveChanges();
return(RedirectToAction("Edit", "Accident", new { id = tbl_AccidentM.AccidentId }));
}
else
{
return(RedirectToAction("Accessdenied", "Home"));
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
catch (Exception ex)
{
ModelState.AddModelError(ex.Message, ex.InnerException.ToString());
return(View());
}
}
public ActionResult Addmaterial(int[] MaterialId, int[] tedad, int Acid)
{
Random rand = new Random();
if (Session["OnlineUser"] != null)
{
if (Session["UserRole"].Equals("SUPERADMIN") || Session["UserRole"].Equals("ADMIN") || Session["UserRole"].Equals("SUBADMIN"))
{
ViewBag.OnlineUser = Session["UserName"].ToString();
ViewBag.OnlineUserRole = Session["UserRole"].ToString();
ViewBag.material = db.tbl_Material.ToList();
if (MaterialId != null)
{
for (int i = 0; i < MaterialId.Count(); i++)
{
tbl_AccidentM tbl_AccidentM = new tbl_AccidentM();
Random rand1 = new Random();
int random1 = 0;
random1 = rand.Next(11111111, 99999999);
while (db.tbl_AccidentM.FirstOrDefault(x => x.AccidentMid == random1) != null)
{
random1 = rand.Next(11111111, 99999999);
}
tbl_AccidentM.AccidentMid = random1;
tbl_AccidentM.AccidentId = Acid;
tbl_AccidentM.MaterialId = MaterialId[i];
tbl_AccidentM.tedad = tedad[i];
db.tbl_AccidentM.Add(tbl_AccidentM);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("Index"));
}
}
else
{
return(RedirectToAction("Accessdenied", "Home"));
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public ActionResult Create([Bind(Include = "AccidentId,AccidentEventLocation,AccidentDescrption,AccidentTime,AccidentDate,AccidentReportUrl,AccidentWid,AccidentTypeId,AccidentZone,AccidentUserId,AccidentUsageId,AccidentTimeStartOperation,AccidentTimeEndOperation,AccidentTimeToClear,AccidentReporter,AccidentReportReciver,AccidentReportType,AccidentSiteFloors,AccidentBuildingType,AccidentBuildingOwner,AccidentBuildingTel,AccidentBuildingTenant,AccidentOtherType,AccidentPreliminaryMeasures,AccidentDescriptionOperation,AccidentDamageDescriptionO,AccidentDamageDescriptionL,AccidentReportProducer,AccidentOperationsCommander,DateAdd,AccidentOperationProblems,AccidentCause")] tbl_Accident tbl_Accident, HttpPostedFileBase[] pic, List <int> OperatingStation, List <int> Employee, List <int> Organisation, string[] InjuredName, string[] InjuredLastName, int[] InjuredSex, int[] InjuredType, int[] InjuredTypeinjury, string[] InjuredDescription, string[] InjuredLocation, int[] MaterialId, int[] tedad)
{
try
{
Random rand = new Random();
int te, dateint;
if (ModelState.IsValid)
{
if (Session["OnlineUser"] != null)
{
if (Session["UserRole"].Equals("SUPERADMIN") || Session["UserRole"].Equals("ADMIN") || Session["UserRole"].Equals("SUBADMIN"))
{
System.Globalization.PersianCalendar pc = new System.Globalization.PersianCalendar();
dateint = Convert.ToInt32(pc.GetYear(DateTime.Now));
int accident = db.tbl_Accident.Where(x => x.AccidentId.ToString().Substring(0, 4).Equals(dateint.ToString())).Count();
te = Convert.ToInt32(string.Format("{0}{1}", dateint, accident + 1));
while (db.tbl_Accident.FirstOrDefault(f => f.AccidentId == te) != null)
{
te = Convert.ToInt32(string.Format("{0}{1}", dateint, accident + 1));
}
if (pic != null)
{
foreach (var item in pic)
{
var Fi1 = Path.GetExtension(item.FileName);
var Ri1 = Path.Combine(Server.MapPath("~/Documents/Doc/"), string.Format("{0}{1}", te.ToString(), Fi1));
item.SaveAs(Ri1);
tbl_Accident.AccidentReportUrl = string.Format("Documents/Doc/{0}{1}", te.ToString(), Fi1);
}
}
tbl_Accident.AccidentId = te;
tbl_Accident.AccidentUserId = Convert.ToInt32(Session["OnlineUser"].ToString());
tbl_Accident.DateAdd = DateTime.Now;
tbl_Accident.Isdelete = false;
db.tbl_Accident.Add(tbl_Accident);
db.SaveChanges();
int rs, re, rf;
foreach (int item in OperatingStation)
{
tbl_AccidentStation oState = new tbl_AccidentStation();
rs = rand.Next(111111, 999999);
while (db.tbl_AccidentStation.FirstOrDefault(f => f.AccidentStationId == rs) != null)
{
rs = rand.Next(111111, 999999);
}
oState.AccidentStationId = rs;
oState.StationId = item;
oState.AccidentId = te;
db.tbl_AccidentStation.Add(oState);
db.SaveChanges();
}
foreach (int item in Employee)
{
tbl_AccidentEmplyoee oEmployee = new tbl_AccidentEmplyoee();
re = rand.Next(111111, 999999);
while (db.tbl_AccidentEmplyoee.FirstOrDefault(f => f.AEId == re) != null)
{
re = rand.Next(111111, 999999);
}
oEmployee.AEId = re;
oEmployee.EmployeeId = item;
oEmployee.AccidentId = te;
db.tbl_AccidentEmplyoee.Add(oEmployee);
db.SaveChanges();
}
foreach (int item in Organisation)
{
tbl_AccidentO dll = new tbl_AccidentO();
rf = rand.Next(111111, 999999);
while (db.tbl_AccidentO.FirstOrDefault(f => f.AccidentOid == rf) != null)
{
rf = rand.Next(111111, 999999);
}
dll.AccidentOid = rf;
dll.OrganizationsId = item;
dll.AccidentId = te;
db.tbl_AccidentO.Add(dll);
db.SaveChanges();
}
for (int i = 0; i < InjuredName.Count(); i++)
{
tbl_Injured tbl_Injured = new tbl_Injured();
Random rand2 = new Random();
int random = 0;
random = rand.Next(11111111, 99999999);
while (db.tbl_Injured.FirstOrDefault(x => x.InjuredID == random) != null)
{
random = rand.Next(11111111, 99999999);
}
tbl_Injured.InjuredID = random;
tbl_Injured.InjuredName = InjuredName[i];
tbl_Injured.InjuredLastName = InjuredLastName[i];
tbl_Injured.InjuredDescription = InjuredDescription[i];
tbl_Injured.InjuredLocation = InjuredLocation[i];
//sex
if (InjuredSex[i] == 1)
{
tbl_Injured.InjuredSex = true;
}
else if (InjuredSex[i] == 0)
{
tbl_Injured.InjuredSex = false;
}
//type
if (InjuredType[i] == 1)
{
tbl_Injured.InjuredType = true;
}
else if (InjuredType[i] == 0)
{
tbl_Injured.InjuredType = false;
}
//masdoumiat
if (InjuredTypeinjury[i] == 1)
{
tbl_Injured.InjuredTypeinjury = true;
}
else if (InjuredTypeinjury[i] == 0)
{
tbl_Injured.InjuredTypeinjury = false;
}
db.tbl_Injured.Add(tbl_Injured);
tbl_AccidentInjured tbl_AccidentInjured = new tbl_AccidentInjured();
Random rand1 = new Random();
int random1 = 0;
random1 = rand.Next(11111111, 99999999);
while (db.tbl_AccidentInjured.FirstOrDefault(x => x.AccidentInjuredid == random1) != null)
{
random1 = rand.Next(11111111, 99999999);
}
tbl_AccidentInjured.AccidentInjuredid = random1;
tbl_AccidentInjured.AccidentId = te;
tbl_AccidentInjured.InjuredId = random;
db.tbl_AccidentInjured.Add(tbl_AccidentInjured);
db.SaveChanges();
}
if (MaterialId != null)
{
for (int i = 0; i < MaterialId.Count(); i++)
{
tbl_AccidentM tbl_AccidentM = new tbl_AccidentM();
Random rand1 = new Random();
int random1 = 0;
random1 = rand.Next(11111111, 99999999);
while (db.tbl_AccidentM.FirstOrDefault(x => x.AccidentMid == random1) != null)
{
random1 = rand.Next(11111111, 99999999);
}
tbl_AccidentM.AccidentMid = random1;
tbl_AccidentM.AccidentId = te;
tbl_AccidentM.MaterialId = MaterialId[i];
tbl_AccidentM.tedad = tedad[i];
db.tbl_AccidentM.Add(tbl_AccidentM);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("Index"));
}
}
else
{
return(RedirectToAction("Accessdenied", "Home"));
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
return(View(tbl_Accident));
}
catch (Exception ex)
{
ModelState.AddModelError(ex.Message, ex.InnerException.ToString());
return(View());
}
}
