public ActionResult Index([Bind(Include = "IdRaidValue,RaidDate,IDPlayer,IDAttendance,MinusAddition,PlusAddition,IDIsActive")] raiddates raiddates, int?id, DateTime?RTDate, string LogsHref)
{
var RDI = id ?? 0;
if (ModelState.IsValid && raiddates.IDPlayer != "" && raiddates.IDPlayer != null)
{
db.Entry(raiddates).State = EntityState.Modified;
db.SaveChanges();
}
var RTC = -1;
if (id.HasValue)
{
RTC = db.raiddatetable.Where(t => t.idRaidDateTable == id).ToList().Count();
}
if (RTDate.HasValue)
{
RTC = db.raiddatetable.Where(t => t.RaidDate == RTDate).ToList().Count();
}
if (RTC == 0)
{
string cnnString = "server=localhost;user id=root;password=Kageretsu;persistsecurityinfo=True;database=staticdb";
MySqlConnection cnn = new MySqlConnection(cnnString);
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = cnn;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "NewRaidData";
cmd.Parameters.Add(new MySqlParameter("InputDate", RTDate));
//add any parameters the stored procedure might require
cnn.Open();
var result = cmd.ExecuteNonQuery();
cnn.Close();
RDI = db.raiddatetable.Where(t => t.RaidDate == RTDate).ToList().First().idRaidDateTable;
}
else
{
if (RTDate.HasValue)
{
raiddatetable raiddatetable = new raiddatetable();
raiddatetable = db.raiddatetable.Where(t => t.RaidDate == RTDate).First();
raiddatetable.LogRef = LogsHref;
db.SaveChanges();
}
if (raiddates.RaidDate.HasValue)
{
raiddatetable raiddatetable = new raiddatetable();
raiddatetable = db.raiddatetable.Where(t => t.idRaidDateTable == raiddates.RaidDate).First();
raiddatetable.LogRef = LogsHref;
db.SaveChanges();
}
}
return(RedirectToAction("Index", new { id = RDI }));
}
public ActionResult Edit([Bind(Include = "IdRaidValue,RaidDate,IDPlayer,IDAttendance,MinusAddition,PlusAddition,IDIsActive")] raiddates raiddates, int?id)
{
raiddates raiddatesItem = db.raiddates.Where(r => r.IdRaidValue == id).First();
ViewBag.IDAttendance = new SelectList(db.attendance_list, "ID_attendance", "ID_attendance", raiddatesItem.IDAttendance);
if (id.HasValue)
{
var ModelDB = db.raiddates;
var ModelItem = ModelDB.Where(r => r.IdRaidValue == id).First();
raiddates = ModelItem;
}
return(PartialView(raiddates));
}
public ActionResult Edit(int?id)
{
raiddates raiddates = db.raiddates.Find(id);
ViewBag.IDAttendance = new SelectList(db.attendance_list, "ID_attendance", "ID_attendance", raiddates.IDAttendance);
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (raiddates == null)
{
return(HttpNotFound());
}
return(PartialView(raiddates));
}
