public List <SelectListItem> GetAllFleetMakesForDropDown()
{
List <SelectListItem> lstFleetMakes = new List <SelectListItem>();
try
{
using (this.objDataContext = new FleetMakesDataContext(Functions.StrConnection))
{
lstFleetMakes.Add(new SelectListItem {
Text = "--Select--", Value = string.Empty
});
List <GetFleetMakesAllResult> lstFleetMakesResult = this.objDataContext.GetFleetMakesAll().ToList();
if (lstFleetMakesResult != null && lstFleetMakesResult.Count > 0)
{
foreach (var item in lstFleetMakesResult)
{
lstFleetMakes.Add(new SelectListItem {
Text = item.FleetMakesName, Value = item.Id.ToString()
});
}
}
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetMakes, mySession.Current.UserId);
}
return(lstFleetMakes);
}
public long SaveFleetMakes(ClsFleetMakes objSave)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
using (this.objDataContext = new FleetMakesDataContext(Functions.StrConnection))
{
var result = this.objDataContext.InsertOrUpdateFleetMakes(objSave.lgId, objSave.strFleetMakesName, mySession.Current.UserId, PageMaster.FleetMakes).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.FleetMakes, mySession.Current.UserId);
return(0);
}
}
public List <GetFleetMakesAllResult> GetFleetMakesAll()
{
try
{
using (this.objDataContext = new FleetMakesDataContext(Functions.StrConnection))
{
List <GetFleetMakesAllResult> lstFleetMakesAll = this.objDataContext.GetFleetMakesAll().ToList();
return(lstFleetMakesAll);
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetMakes, mySession.Current.UserId);
return(null);
}
}
public List <SearchFleetMakesResult> SearchFleetMakes(int inRow, int inPage, string strSearch, string strSort)
{
try
{
using (this.objDataContext = new FleetMakesDataContext(Functions.StrConnection))
{
List <SearchFleetMakesResult> lstSearchFleetMakes = this.objDataContext.SearchFleetMakes(inRow, inPage, strSearch, strSort).ToList();
return(lstSearchFleetMakes);
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetMakes, mySession.Current.UserId);
return(null);
}
}
public bool IsFleetMakesExists(long lgFleetMakesId, string strFleetMakesName)
{
try
{
using (this.objDataContext = new FleetMakesDataContext(Functions.StrConnection))
{
if (this.objDataContext.FleetMakes.Where(x => x.Id != lgFleetMakesId && x.Make == strFleetMakesName && x.IsDeleted == false).Count() > 0)
{
return(true);
}
}
return(false);
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetMakes, mySession.Current.UserId);
return(false);
}
}
public DeleteFleetMakesResult DeleteFleetMakes(string strFleetMakesIdList, long lgDeletedBy)
{
DeleteFleetMakesResult result = new DeleteFleetMakesResult();
try
{
using (TransactionScope scope = new TransactionScope())
{
using (this.objDataContext = new FleetMakesDataContext(Functions.StrConnection))
{
result = this.objDataContext.DeleteFleetMakes(strFleetMakesIdList, lgDeletedBy, PageMaster.FleetMakes).ToList().FirstOrDefault();
}
scope.Complete();
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetMakes, mySession.Current.UserId);
}
return(result);
}
public ClsFleetMakes GetFleetMakesByFleetMakesId(long lgFleetMakesId)
{
ClsFleetMakes objClsFleetMakes = new ClsFleetMakes();
try
{
using (this.objDataContext = new FleetMakesDataContext(Functions.StrConnection))
{
GetFleetMakesByIdResult item = this.objDataContext.GetFleetMakesById(lgFleetMakesId).ToList().FirstOrDefault();
if (item != null)
{
objClsFleetMakes.lgId = item.Id;
objClsFleetMakes.strFleetMakesName = item.FleetMakesName;
}
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetMakes, mySession.Current.UserId);
}
return(objClsFleetMakes);
}
