public ClsCarFleet GetCarFleetByCarFleetId(long lgCarFleetId)
{
ClsCarFleet objClsCarFleet = new ClsCarFleet();
try
{
using (this.objDataContext = new CarFleetDataContext(Functions.StrConnection))
{
GetCarFleetByIdResult item = this.objDataContext.GetCarFleetById(lgCarFleetId).ToList().FirstOrDefault();
if (item != null)
{
objClsCarFleet.inId = item.ID;
objClsCarFleet.inOwner_Id = item.Owner_Id;
objClsCarFleet.strLast_Trip = item.Last_Trip.Replace(' ', '/');
objClsCarFleet.strCode = item.Code;
objClsCarFleet.strReg = item.Reg;
objClsCarFleet.strDesc = item.Description;
objClsCarFleet.inColor_Id = item.Color_Id;
objClsCarFleet.strFuel_Type = item.Fuel_Type;
objClsCarFleet.inLast_Km = item.Last_Km;
objClsCarFleet.strLast_Location = item.Last_Location;
objClsCarFleet.strMake = item.Make;
objClsCarFleet.inFleetModels_Id = Convert.ToInt32(item.FleetModels_Id);
}
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.CarFleet, mySession.Current.UserId);
}
return(objClsCarFleet);
}
public Task <List <SelectListItem> > GetAllCarFleetCodeForDropDown()
{
List <SelectListItem> lstCarFleet = new List <SelectListItem>();
try
{
using (this.objDataContext = new CarFleetDataContext(Functions.StrConnection))
{
lstCarFleet.Add(new SelectListItem {
Text = "--Select--", Value = string.Empty
});
List <GetCarFleetAllResult> lstCarFleetResult = this.objDataContext.GetCarFleetAll().ToList();
if (lstCarFleetResult != null && lstCarFleetResult.Count > 0)
{
foreach (var item in lstCarFleetResult)
{
lstCarFleet.Add(new SelectListItem {
Text = item.Code, Value = item.ID.ToString()
});
}
}
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.TripReason, mySession.Current.UserId);
}
return(Task.FromResult(lstCarFleet));
}
public int SaveCarFleet(ClsCarFleet objSave)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
using (this.objDataContext = new CarFleetDataContext(Functions.StrConnection))
{
var result = this.objDataContext.InsertOrUpdateCarFleet(objSave.inId, objSave.inOwner_Id, objSave.strCode, objSave.strReg, objSave.strDesc, objSave.inColor_Id,
objSave.strFuel_Type, objSave.strLast_Trip, objSave.inLast_Km, objSave.strLast_Location, objSave.inFleetModels_Id, objSave.inFleetMakes_Id, mySession.Current.UserId, PageMaster.CarFleet.ToString().intSafe(), null, null).FirstOrDefault();
if (result != null)
{
objSave.inId = result.InsertedId;
}
}
scope.Complete();
}
return(objSave.inId);
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.CarFleet, mySession.Current.UserId);
return(0);
}
}
public List <GetCarFleetAllResult> GetCarFleetAll()
{
try
{
using (this.objDataContext = new CarFleetDataContext(Functions.StrConnection))
{
List <GetCarFleetAllResult> lstCarFleetAll = this.objDataContext.GetCarFleetAll().ToList();
return(lstCarFleetAll);
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.CarFleet, mySession.Current.UserId);
return(null);
}
}
public List <SearchCarFleetResult> SearchCarFleet(int inRow, int inPage, string strSearch, string strSort, string strTripStartDate, string strTripEndDate)
{
try
{
using (this.objDataContext = new CarFleetDataContext(Functions.StrConnection))
{
List <SearchCarFleetResult> lstSearchCarFleet = this.objDataContext.SearchCarFleet(inRow, inPage, strSort, strTripStartDate, strTripEndDate, strSearch).ToList();
return(lstSearchCarFleet);
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.CarFleet, mySession.Current.UserId);
return(null);
}
}
public DeleteCarFleetResult DeleteCarFleet(string strCarFleetId, long lgDeletedBy)
{
try
{
using (this.objDataContext = new CarFleetDataContext(Functions.StrConnection))
{
DeleteCarFleetResult result = this.objDataContext.DeleteCarFleet(strCarFleetId, lgDeletedBy, PageMaster.User).FirstOrDefault();
if (result == null)
{
result = new DeleteCarFleetResult();
}
return(result);
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.User, mySession.Current.UserId);
return(null);
}
}
