public ActionResult Edit(VehicleTypeList model)
{
SetActiveMenuItem();
if (!ModelState.IsValid)
{
return(View(model));
}
try
{
//Set our updater name
var FullName = Request.Cookies["userInfo"]["FullName"];
//Now update the record
VehicleTypeBLL.UpdateVehicleType(model, FullName);
//Take our ID with us to the confirmation form
ViewBag.Id = model.Id;
//Determine the kind of SQL transaction we have performed
ViewBag.Message = "updated";
//We can now safely go to the confirmation view
return(View("AddUpdateConfirm"));
}
catch (Exception ex)
{
TempData["ErrorMessage"] = ex.Message;
return(Redirect("~/Admin/Home/Error"));
}
}
private void ExecuteLoad(object obj)
{
if (obj != null)
{
byte id = Convert.ToByte(obj);
if (!VehicleTypeList.Any(x => x.VTypeID == id))
{
MessageBox.Show("Invalid Id.", MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Exclamation);
return;
}
SelectedVehicle = VehicleTypeList.FirstOrDefault(x => x.VTypeID == id);
}
Vehicle = new VehicleType
{
VTypeID = SelectedVehicle.VTypeID,
Description = SelectedVehicle.Description,
Capacity = SelectedVehicle.Capacity,
UID = SelectedVehicle.UID,
ButtonImage = SelectedVehicle.ButtonImage,
};
if (Vehicle.ButtonImage != null)
{
Vehicle.ImageSource = Imaging.BinaryToImage(Vehicle.ButtonImage);
}
SetAction(ButtonAction.Selected);
}
public ActionResult Create(VehicleTypeList model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
try
{
//Set our initial return value
var returnValue = 0;
//Set our updater name
var FullName = Request.Cookies["userInfo"]["FullName"];
//Attempt to add our record
VehicleTypeBLL.AddVehicleType(model, FullName, out returnValue);
//Take our ID with us to the confirmation form
ViewBag.Id = returnValue;
//Determine the kind of SQL transaction we have performed
ViewBag.Message = "added";
//We can now safely go to the confirmation view
return(View("AddUpdateConfirm"));
}
catch (Exception ex)
{
TempData["ErrorMessage"] = ex.Message;
return(Redirect("~/Admin/Home/Error"));
}
}
public ActionResult DeleteConfirmed(int id)
{
VehicleTypeList vehicleTypeList = db.VehicleTypeLists.Find(id);
db.VehicleTypeLists.Remove(vehicleTypeList);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void AddNewVehicle()
{
SelectedDriver = null;
SelectedVehicle = new VehicleDTO
{
Type = (VehicleTypes)VehicleTypeList.FirstOrDefault().Value,
Number = _vehicleService.GetVehicleCode()
};
}
public ActionResult Edit([Bind(Include = "Id,VehicleType,RequredSpace")] VehicleTypeList vehicleTypeList)
{
if (ModelState.IsValid)
{
db.Entry(vehicleTypeList).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(vehicleTypeList));
}
public static VehicleTypeList GetVehicleType(int VehicleTypeID)
{
var model = new VehicleTypeList();
var dt = VehicleTypeDAL.GetVehicleType(VehicleTypeID);
var dr = dt.Rows[0];
model.Id = (int)dr["VehicleTypeID"];
model.Display = dr["VehicleType"].ToString();
return(model);
}
public ActionResult Create([Bind(Include = "Id,VehicleType,RequredSpace")] VehicleTypeList vehicleTypeList)
{
if (ModelState.IsValid)
{
db.VehicleTypeLists.Add(vehicleTypeList);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(vehicleTypeList));
}
private void UpdateVehicleType()
{
if (MessageBox.Show(string.Format(UpdateConfirmText, "Vehicle Type"), MessageBoxCaption, MessageBoxButton.YesNo, MessageBoxImage.Question) != MessageBoxResult.Yes)
{
return;
}
try
{
using (SqlConnection Conn = new SqlConnection(GlobalClass.TConnectionString))
{
Conn.Open();
using (SqlTransaction tran = Conn.BeginTransaction())
{
string Remarks = Newtonsoft.Json.JsonConvert.SerializeObject(Conn.Query <TVehicleType>("SELECT VTypeID, [Description], Capacity, [UID] FROM VehicleType WHERE VTypeID = @VTypeID", Vehicle, tran).First());
if (Vehicle.ImageSource != null && Vehicle.ImageSource.UriSource != null)
{
Vehicle.ButtonImage = Imaging.FileToBinary(Vehicle.ImageSource.UriSource.LocalPath);
}
if (Vehicle.Update(tran))
{
GlobalClass.SetUserActivityLog(tran, "Vehicle Type", "Edit", WorkDetail: "VTypeId : " + Vehicle.VTypeID, Remarks: Remarks);
tran.Commit();
MessageBox.Show("Entrance Type Updated Successfully.", MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Information);
var vehicle = VehicleTypeList.First(x => x.VTypeID == Vehicle.VTypeID);
vehicle.Description = Vehicle.Description;
vehicle.Capacity = Vehicle.Capacity;
vehicle.ButtonImage = Vehicle.ButtonImage;
ExecuteUndo(null);
}
else
{
MessageBox.Show("Entrance Type could not be updated.", MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Exclamation);
tran.Rollback();
}
}
}
}
catch (SqlException ex)
{
if (ex.Number == 2601)
{
MessageBox.Show("Entered Entrance name already exist in the database. Enter unique name and try again", MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Hand);
}
else
{
MessageBox.Show(ex.Number + " : " + ex.Message, MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(GlobalClass.GetRootException(ex).Message, MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void SaveVehicleType()
{
if (MessageBox.Show(string.Format(SaveConfirmText, "Entrance Type"), MessageBoxCaption, MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No)
{
return;
}
try
{
using (SqlConnection Conn = new SqlConnection(GlobalClass.TConnectionString))
{
Conn.Open();
using (SqlTransaction Tran = Conn.BeginTransaction())
{
Vehicle.VTypeID = Conn.ExecuteScalar <byte>("SELECT CAST(ISNULL(MAX(VTypeID), 0) + 1 AS TINYINT) FROM VehicleType", transaction: Tran);
if (Vehicle.ImageSource != null)
{
Vehicle.ButtonImage = Imaging.FileToBinary(Vehicle.ImageSource.UriSource.LocalPath);
}
if (Vehicle.Save(Tran))
{
GlobalClass.SetUserActivityLog(Tran, "Entrance Type", "New", WorkDetail: "VTypeID : " + Vehicle.VTypeID, Remarks: Vehicle.Description);
Tran.Commit();
MessageBox.Show("Entrance Type Saved Successfully.", MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Information);
VehicleTypeList.Add(new VehicleType {
VTypeID = Vehicle.VTypeID, Description = Vehicle.Description, Capacity = Vehicle.Capacity, UID = GlobalClass.User.UID
});
ExecuteUndo(null);
}
else
{
MessageBox.Show("Entrance Type could not be Saved.", MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
}
}
}
catch (SqlException ex)
{
if (ex.Number == 2601)
{
MessageBox.Show("Entered Entrance name already exist in the database. Enter unique name and try again", MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Hand);
}
else
{
MessageBox.Show(ex.Number + " : " + ex.Message, MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
// GET: VehicleTypeLists/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VehicleTypeList vehicleTypeList = db.VehicleTypeLists.Find(id);
if (vehicleTypeList == null)
{
return(HttpNotFound());
}
return(View(vehicleTypeList));
}
private void ExecuteDelete(object obj)
{
if (MessageBox.Show(string.Format(DeleteConfirmText, "Entrance Type"), MessageBoxCaption, MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No)
{
return;
}
try
{
using (SqlConnection Conn = new SqlConnection(GlobalClass.TConnectionString))
{
Conn.Open();
using (SqlTransaction tran = Conn.BeginTransaction())
{
string Remarks = Newtonsoft.Json.JsonConvert.SerializeObject(Conn.Query <TVehicleType>("SELECT VTypeID, [Description], Capacity, [UID] FROM VehicleType WHERE VTypeID = @VTypeID", Vehicle, tran).First());
if (Vehicle.Delete(tran))
{
GlobalClass.SetUserActivityLog(tran, "Entrance Type", "Delete", WorkDetail: "VTypeId : " + Vehicle.VTypeID, Remarks: Remarks);
tran.Commit();
MessageBox.Show("Entrance Type Deleted successfully.", MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Information);
VehicleTypeList.Remove(VehicleTypeList.First(x => x.VTypeID == Vehicle.VTypeID));
ExecuteUndo(null);
}
else
{
MessageBox.Show("Entrance Type could not be Deleted.", MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
}
}
}
catch (SqlException ex)
{
if (ex.Number == 547)
{
MessageBox.Show("Selected entrance type cannot be deleted because it has already been linked to another transaction.", MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Hand);
}
else
{
MessageBox.Show(ex.Number + " : " + ex.Message, MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public override void Update(ViewModelReturnData VMReturnData)
{
if (VMReturnData.NewCardType_Active)
{
View.Visibility = Visibility.Visible;
#region Navigation Bar details
VMReturnData.ViewTitle = VMReturnData.EditCard ? "Edit Card" : "New Card";
VMReturnData.SubTitle = "Vehicle Type details";
VMReturnData.CurrentPageNumber = 3;
VMReturnData.TotalPageNumber = 4;
VMReturnData.MenuButtonEnabled = Visibility.Collapsed;
VMReturnData.HelpButtonEnabled = Visibility.Visible;
#endregion
if (!OneTimeRead)
{
VehicleTypeList = new ObservableCollection <string>();
VehicleTypeList2 = new ObservableCollection <string>();
DisplayVehicleList = new ObservableCollection <string>();
index = 0;
foreach (var item in TagTypesL.MernokAssetType)
{
if (item.IsLicensable)
{
VehicleTypeList.Add(item.TypeName);
}
}
OneTimeRead = true;
VehicleTypenum = 0;
}
if (Bypassed)
{
DisplayVehicleList = new ObservableCollection <string> {
"All Vehicle Types"
};
ByEnabled = BtnAddEnabled = false;
VMReturnData.VMCardDetails.VehicleLicenceType = Enumerable.Repeat((uint)255, 30).ToArray();
VMReturnData.VMCardDetails.ByPassBits = VMReturnData.VMCardDetails.ByPassBits | 0x04;
VMReturnData.NextButtonEnabled = true;
}
else
{
DisplayVehicleList = VehicleTypeList2;
for (int i = 0; i < index; i++)
{
VMReturnData.VMCardDetails.VehicleLicenceType[i] = (byte)(TagTypesL.MernokAssetType.IndexOf(TagTypesL.MernokAssetType.Where(p => p.TypeName == VehicleTypeList2[i]).FirstOrDefault()) + 1);
}
ByEnabled = BtnAddEnabled = true;
VMReturnData.NextButtonEnabled = VehicleTypeList2.Count() > 0 ? true : false;
VMReturnData.VMCardDetails.ByPassBits = (uint)(VMReturnData.VMCardDetails.ByPassBits & ~0b00000100);
}
if (AddbtnPressed)
{
AddbtnPressed = false;
if (VehicleTypeList2.Count < 15)
{
VMReturnData.VMCardDetails.VehicleLicenceType[index] = (byte)(TagTypesL.MernokAssetType.IndexOf(TagTypesL.MernokAssetType.Where(p => p.TypeName == VehicleTypeList[VehicleTypenum]).FirstOrDefault()) + 1);
VehicleTypeList2.Add(VehicleTypeList[VehicleTypenum]);
index++;
VehicleTypeList.RemoveAt(VehicleTypenum);
VehicleTypenum = 0;
}
else
{
BtnAddEnabled = false;
}
}
if (RemovebtnPressed)
{
RemovebtnPressed = false;
if (VehicleTypeList2.Count() > 0)
{
BtnremoveEnabled = true;
index--;
VMReturnData.VMCardDetails.VehicleLicenceType[index] = 0;
VehicleTypeList.Add(VehicleTypeList2.Last());
VehicleTypeList2.RemoveAt(VehicleTypeList2.Count - 1);
}
}
if (VehicleTypeList.Count > 0)
{
ByEnabled = BtnAddEnabled = true;
}
else
{
BtnAddEnabled = false;
}
if (VehicleTypeList2.Count() > 0)
{
BtnremoveEnabled = true;
}
else
{
BtnremoveEnabled = false;
}
}
else
{
//View is not visible, do not update
//Stop any animations on this vieModel
OneTimeRead = false;
this.View.Visibility = Visibility.Collapsed;
}
}
public static void AddVehicleType(VehicleTypeList model, string UpdatedBy, out int returnValue)
{
VehicleTypeDAL.AddVehicleType(model.Display, UpdatedBy, out returnValue);
}
public static void UpdateVehicleType(VehicleTypeList model, string UpdatedBy)
{
VehicleTypeDAL.UpdateVehicleType(model.Id, model.Display, UpdatedBy);
}
