public List <SelectListItem> GetAllFleetModelsForDropDown()
{
List <SelectListItem> lstFleetModels = new List <SelectListItem>();
try
{
using (this.objDataContext = new FleetModelsDataContext(Functions.StrConnection))
{
lstFleetModels.Add(new SelectListItem {
Text = "--Select--", Value = string.Empty
});
List <GetFleetModelsAllResult> lstFleetModelsResult = this.objDataContext.GetFleetModelsAll().ToList();
if (lstFleetModelsResult != null && lstFleetModelsResult.Count > 0)
{
foreach (var item in lstFleetModelsResult)
{
lstFleetModels.Add(new SelectListItem {
Text = item.FleetModelsName, Value = item.Id.ToString()
});
}
}
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetModels, mySession.Current.UserId);
}
return(lstFleetModels);
}
public long SaveFleetModels(ClsFleetModels objSave)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
using (this.objDataContext = new FleetModelsDataContext(Functions.StrConnection))
{
var result = this.objDataContext.InsertOrUpdateFleetModels(objSave.lgId, objSave.strFleetModelsName, mySession.Current.UserId, PageMaster.FleetModels).FirstOrDefault();
if (result != null)
{
objSave.lgId = result.InsertedId;
}
}
scope.Complete();
}
return(objSave.lgId);
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetModels, mySession.Current.UserId);
return(0);
}
}
public List <GetFleetModelsAllResult> GetFleetModelsAll()
{
try
{
using (this.objDataContext = new FleetModelsDataContext(Functions.StrConnection))
{
List <GetFleetModelsAllResult> lstFleetModelsAll = this.objDataContext.GetFleetModelsAll().ToList();
return(lstFleetModelsAll);
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetModels, mySession.Current.UserId);
return(null);
}
}
public List <SearchFleetModelsResult> SearchFleetModels(int inRow, int inPage, string strSearch, string strSort)
{
try
{
using (this.objDataContext = new FleetModelsDataContext(Functions.StrConnection))
{
List <SearchFleetModelsResult> lstSearchFleetModels = this.objDataContext.SearchFleetModels(inRow, inPage, strSearch, strSort).ToList();
return(lstSearchFleetModels);
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetModels, mySession.Current.UserId);
return(null);
}
}
public bool IsFleetModelsExists(long lgFleetModelsId, string strFleetModelsName)
{
try
{
using (this.objDataContext = new FleetModelsDataContext(Functions.StrConnection))
{
if (this.objDataContext.FleetModels.Where(x => x.Id != lgFleetModelsId && x.Model == strFleetModelsName && x.IsDeleted == false).Count() > 0)
{
return(true);
}
}
return(false);
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetModels, mySession.Current.UserId);
return(false);
}
}
public DeleteFleetModelsResult DeleteFleetModels(string strFleetModelsIdList, long lgDeletedBy)
{
DeleteFleetModelsResult result = new DeleteFleetModelsResult();
try
{
using (TransactionScope scope = new TransactionScope())
{
using (this.objDataContext = new FleetModelsDataContext(Functions.StrConnection))
{
result = this.objDataContext.DeleteFleetModels(strFleetModelsIdList, lgDeletedBy, PageMaster.FleetModels).ToList().FirstOrDefault();
}
scope.Complete();
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetModels, mySession.Current.UserId);
}
return(result);
}
public ClsFleetModels GetFleetModelsByFleetModelsId(long lgFleetModelsId)
{
ClsFleetModels objClsFleetModels = new ClsFleetModels();
try
{
using (this.objDataContext = new FleetModelsDataContext(Functions.StrConnection))
{
GetFleetModelsByIdResult item = this.objDataContext.GetFleetModelsById(lgFleetModelsId).ToList().FirstOrDefault();
if (item != null)
{
objClsFleetModels.lgId = item.Id;
objClsFleetModels.strFleetModelsName = item.FleetModelsName;
}
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetModels, mySession.Current.UserId);
}
return(objClsFleetModels);
}
