protected void gvIncidence_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
string format = "dd/MM/yyyy";
hid.Value = "Update";
dvID.Visible = true;
dvMsg.InnerText = "Update Incident's Information :";
btnSubmit.Text = "Update";
int Id = Convert.ToInt32(gvIncidence.SelectedDataKey[0].ToString());
GridViewRow row = gvIncidence.SelectedRow;
txtID.Text = Id.ToString();
IncidentLog log = IncidenceBLL.GetIncidence(Id);
if (log != null)
{
// txtDesc.Text = row.Cells[4].Text;
ddlVeh.SelectedValue = log.AssociatedVehicle.Value.ToString();
ddlIncType.SelectedValue = log.IncidentTypeID.Value.ToString();
ddlDriver.SelectedValue = log.AssociatedDriver.Value.ToString();
txtDesc.Text = log.Note;
if (ddlIncType.SelectedValue == vehMaintenanceID)
{
dvmainTenance.Visible = true;
txtDate.Text = log.VehMaintenanceDate.HasValue ? DateTime.Parse(log.VehMaintenanceDate.Value.ToString()).ToString(format) : "";
txtMile.Text = log.MileageAtMaintenance.HasValue ? log.MileageAtMaintenance.Value.ToString() : "";
}
}
}catch (Exception ex)
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> An error occured. Kindly try again. If error persist contact Administrator!!.";
Utility.WriteError("Error: " + ex.InnerException);
}
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity <UserLog>().HasData(Models.UserLog.GetSeederData());
modelBuilder.Entity <DroneLog>().HasData(DroneLog.GetSeederData());
modelBuilder.Entity <Payload>().HasData(Payload.GetSeederData());
modelBuilder.Entity <ImageLog>().HasData(ImageLog.GetSeederData());
modelBuilder.Entity <VideoLog>().HasData(VideoLog.GetSeederData());
modelBuilder.Entity <IncidentLog>().HasData(IncidentLog.GetSeederData());
modelBuilder.Entity <ObjectObserve>().HasData(ObjectObserve.GetSeederData());
modelBuilder.Entity <StaticalLog>().HasData(StaticalLog.GetSeederData());
modelBuilder.Entity <WarningLog>().HasData(WarningLog.GetSeederData());
modelBuilder.Entity <MonitorRegionLog>().HasData(MonitorRegionLog.GetSeederData());
modelBuilder.Entity <ResolveProblemLog>().HasData(ResolveProblemLog.GetSeederData());
modelBuilder.Entity <UavConnectLog>().HasData(UavConnectLog.GetSeederData());
}
public static bool AddIncidence(IncidentLog incident)
{
try
{
using (FleetMgtSysDBEntities db = new FleetMgtSysDBEntities())
{
db.IncidentLogs.Add(incident);
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
// Utility.WriteError("Error Msg: " + ex.Message);
throw ex;
}
}
public static bool UpdateIncidenceLog(IncidentLog incident)
{
try
{
bool rst = false;
using (var db = new FleetMgtSysDBEntities())
{
db.IncidentLogs.Attach(incident);
db.Entry(incident).State = System.Data.Entity.EntityState.Modified;
//db.ObjectStateManager.ChangeObjectState(auction, System.Data.EntityState.Modified);
db.SaveChanges();
rst = true;
}
return(rst);
}
catch (Exception ex)
{
Utility.WriteError("Error Msg: " + ex.Message);
throw ex;
}
}
public int Update_IncidentLog_By_id(IncidentLog objIncidentLog)
{
return (int)ExecuteNonQuery(Sp_IncidentLog_Update, new object[] { objIncidentLog.Incidentlog, objIncidentLog.Incidentid });
}
public int Insert_IncidentLog(IncidentLog objIncidentLog)
{
return (int)ExecuteNonQuery(Sp_IncidentLog_Insert, new object[] { objIncidentLog.Incidentlog, objIncidentLog.Incidentid, objIncidentLog.Userid });
}
public object GenerateIncidentLog_mstObject(ref IDataReader returnData)
{
IncidentLog obj = new IncidentLog();
while (returnData.Read())
{
obj.Incidentid = (int)returnData["Incidentid"];
obj.Incidentlog = (string)returnData["Incidentlog"];
}
returnData.Close();
returnData.Dispose();
return obj;
}
public CollectionBase GenerateIncidentLog_mstCollection(ref IDataReader returnData)
{
BLLCollection<IncidentLog> col = new BLLCollection<IncidentLog>();
while (returnData.Read())
{
IncidentLog obj = new IncidentLog();
obj.Incidentid = (int)returnData["Incidentid"];
obj.Userid = (int)returnData["Userid"];
obj.Incidentlog = (string)returnData["Incidentlog"];
DateTime Mydatetime = new DateTime();
Mydatetime = (DateTime)returnData["CreateDateTime"];
obj.CreateDateTime = Mydatetime.ToString();
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (hid.Value == "Update")
{
IncidentLog incident = null; bool rst = false;
incident = IncidenceBLL.GetIncidence(Convert.ToInt32(txtID.Text));
if (incident != null)
{
incident.Note = txtDesc.Text;
incident.IncidentTypeID = Convert.ToInt32(ddlIncType.SelectedValue);
incident.AssociatedDriver = Convert.ToInt32(ddlDriver.SelectedValue);
incident.AssociatedVehicle = Convert.ToInt32(ddlVeh.SelectedValue);
incident.LastModifiedDate = DateTime.Now;
incident.ModifiedBy = User.Identity.Name;
if (ddlIncType.SelectedValue == vehMaintenanceID)
{
incident.VehMaintenanceDate = DateTime.Parse(txtDate.Text, culture);
decimal mileAtSer = 0;
if (!decimal.TryParse(txtMile.Text, out mileAtSer))
{
error.Visible = true;
error.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button>Mileage must be numeric";
return;
}
incident.MileageAtMaintenance = mileAtSer;
Vehicle veh = VehicleBLL.GetVehicle(int.Parse(ddlVeh.SelectedValue));
if (veh != null)
{
veh.LastServiceDate = DateTime.Parse(txtDate.Text, culture);
veh.MileageAtLastService = mileAtSer;
VehicleBLL.UpdateVehicle(veh);
}
}
rst = IncidenceBLL.UpdateIncidenceLog(incident);
if (rst != false)
{
BindGrid();
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record updated successfully!!.";
return;
}
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not updated. Kindly try again. If error persist contact Administrator!!.";
}
}
else
{
IncidentLog incident = new IncidentLog();
if (ddlIncType.SelectedValue == vehMaintenanceID)
{
decimal mileAtSer = 0;
if (!decimal.TryParse(txtMile.Text, out mileAtSer))
{
error.Visible = true;
error.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button>Mileage must be numeric";
return;
}
incident.VehMaintenanceDate = DateTime.Parse(txtDate.Text, culture);
incident.MileageAtMaintenance = mileAtSer;
Vehicle veh = VehicleBLL.GetVehicle(int.Parse(ddlVeh.SelectedValue));
if (veh != null)
{
veh.LastServiceDate = DateTime.Parse(txtDate.Text, culture);
veh.MileageAtLastService = mileAtSer;
veh.Mileage = mileAtSer;
VehicleBLL.UpdateVehicle(veh);
}
}
bool result = false;
incident.Note = txtDesc.Text;
incident.IncidentTypeID = Convert.ToInt32(ddlIncType.SelectedValue);
incident.AssociatedDriver = Convert.ToInt32(ddlDriver.SelectedValue);
incident.AssociatedVehicle = Convert.ToInt32(ddlVeh.SelectedValue);
incident.DateAdded = DateTime.Now;
incident.AddedBy = User.Identity.Name;
result = IncidenceBLL.AddIncidence(incident);
if (result)
{
BindGrid();
Reset();
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record added successfully!!.";
return;
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not added. Kindly try again. If error persist contact Administrator!!.";
}
}
}
catch (Exception ex)
{
error.Visible = true;
error.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button> An error occurred. kindly try again!!!";
Utility.WriteError("Error: " + ex.Message);
}
}
