public bool IsDefaultZoneType(long zoneid, long typeid, TaxiAppzDBContext context, LoggedInUser loggedInUser)
{
try
{
var zonetypeexist = context.TabZonetypeRelationship.Where(z => z.Zoneid == zoneid && z.IsDefault == 1).FirstOrDefault();
if (zonetypeexist != null)
{
zonetypeexist.IsDefault = 0;
context.TabZonetypeRelationship.Update(zonetypeexist);
var zonetype = context.TabZonetypeRelationship.Where(z => z.Zoneid == zoneid && z.Typeid == typeid).FirstOrDefault();
zonetype.IsDefault = 1;
context.TabZonetypeRelationship.Update(zonetype);
context.SaveChanges();
return(true);
}
else
{
var zonetype = context.TabZonetypeRelationship.Where(z => z.Zoneid == zoneid && z.Typeid == typeid).FirstOrDefault();
zonetype.IsDefault = 1;
context.TabZonetypeRelationship.Update(zonetype);
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Extention.insertlog(ex.Message.ToString(), "Admin", "IsDefaultZoneType", context);
return(false);
}
}
public bool EditRole(TaxiAppzDBContext context, long id, Roles roles, LoggedInUser loggedInUser)
{
var roleExist = context.TabRoles.FirstOrDefault(t => t.IsDelete == 0 && t.RoleName.ToLower() == roles.RoleName.ToLower() && t.Roleid != id);
if (roleExist != null)
{
throw new DataValidationException($"Role with name '{roles.RoleName}' already exists.");
}
TabRoles Insertdata = new TabRoles();
var updatedate = context.TabRoles.Where(r => r.Roleid == id && r.IsDelete == 0).FirstOrDefault();
if (updatedate != null)
{
updatedate.RoleName = roles.RoleName;
updatedate.DisplayName = roles.DisplayName;
updatedate.Description = roles.Description;
updatedate.CreatedBy = loggedInUser.Email;
updatedate.UpdatedAt = Extention.GetDateTime();
context.Update(updatedate);
context.SaveChanges();
return(true);
}
return(false);
}
public bool AddZone(ManageZoneAdd manageZone, TaxiAppzDBContext context, LoggedInUser loggedInUser)
{
var serviceExist = context.TabServicelocation.FirstOrDefault(t => t.IsDeleted == 0 && t.Servicelocid == manageZone.Serviceslocid);
if (serviceExist == null)
{
throw new DataValidationException($"Service location does not already exists.");
}
TabZone tabZone = new TabZone();
tabZone.Zonename = manageZone.ZoneName;
tabZone.Servicelocid = manageZone.Serviceslocid;
tabZone.Unit = manageZone.Unit;
tabZone.IsActive = 1;
tabZone.IsDeleted = 0;
tabZone.CreatedBy = tabZone.UpdatedBy = loggedInUser.UserName;
tabZone.CreatedAt = tabZone.UpdatedAt = Extention.GetDateTime();
context.TabZone.Add(tabZone);
context.SaveChanges();
foreach (var zonepolygon in manageZone.ZonePolygoneList)
{
TabZonepolygon tabZonepolygon = new TabZonepolygon();
tabZonepolygon.Longitudes = zonepolygon.Lng;
tabZonepolygon.Latitudes = zonepolygon.Lat;
tabZonepolygon.IsActive = 1;
tabZonepolygon.CreatedBy = tabZonepolygon.UpdatedBy = loggedInUser.UserName;
tabZonepolygon.CreatedAt = tabZonepolygon.UpdatedAt = Extention.GetDateTime();
tabZonepolygon.Zoneid = tabZone.Zoneid;
context.TabZonepolygon.Add(tabZonepolygon);
}
context.SaveChanges();
return(true);
}
public ManageZone GetZonedetails(long zoneid, TaxiAppzDBContext context)
{
try
{
ManageZone manageZones = new ManageZone();
List <ManageZonePolygon> manageZonePolygon = new List <ManageZonePolygon>();
var zonedtls = context.TabZone.Where(z => z.Zoneid == zoneid && z.IsDeleted == 0).FirstOrDefault();
var zonepolygondtls = context.TabZonepolygon.Where(z => z.Zoneid == zoneid && z.IsDeleted == 0).ToList();
manageZones.Zoneid = zonedtls.Zoneid;
manageZones.ZoneName = zonedtls.Zonename;
manageZones.Unit = zonedtls.Unit;
manageZones.Serviceslocid = zonedtls.Servicelocid;
foreach (var zonepolygon in zonepolygondtls)
{
manageZonePolygon.Add(new ManageZonePolygon()
{
Lat = zonepolygon.Latitudes,
Lng = zonepolygon.Longitudes
});
}
manageZones.ZonePolygoneList = manageZonePolygon;
return(manageZones == null ? null : manageZones);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message.ToString(), "Admin", "GetZonedetails", context);
return(null);
}
}
public List <AdminList> List(TaxiAppzDBContext context)
{
try
{
List <AdminList> addAdminList = new List <AdminList>();
var addAdmin = context.TabAdmin.Where(t => t.IsDeleted == 0).ToList().OrderByDescending(t => t.UpdatedAt);
foreach (var admin in addAdmin)
{
addAdminList.Add(new AdminList()
{
Email = admin.Email,
Id = admin.Id,
Name = admin.Firstname + ' ' + admin.Lastname,
Role = admin.Role.ToString(),
Operations = "",
Phoneno = admin.PhoneNumber,
Rgcode = admin.RegistrationCode,
Status = admin.IsActive == 1 ? true : false
});
}
return(addAdminList);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "List", context);
return(null);
}
}
public List <ZoneTypeDrop> ZoneType(long zoneId, TaxiAppzDBContext context)
{
try
{
List <ZoneTypeDrop> zoneTypeLists = new List <ZoneTypeDrop>();
var typeVechile = context.TabTypes.Where(t => t.IsDeleted == 0 && t.IsActive == 1).ToList();
var relationTypeZone = context.TabZonetypeRelationship.Where(t => t.IsDelete == 0 && t.IsActive == 1 && t.Zoneid == zoneId).Select(t => t.Typeid);
foreach (var item in typeVechile)
{
zoneTypeLists.Add(new ZoneTypeDrop()
{
Id = item.Typeid,
Name = item.Typename
});
}
foreach (var item in relationTypeZone)
{
zoneTypeLists.Remove(zoneTypeLists.FirstOrDefault(t => t.Id == item));
}
return(zoneTypeLists == null ? null : zoneTypeLists);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message.ToString(), "Admin", "ListZoneType", context);
return(null);
}
}
public bool ActiveZone(long zoneid, bool isStatus, TaxiAppzDBContext context, LoggedInUser loggedInUser)
{
try
{
var tabzone = context.TabZone.Where(z => z.Zoneid == zoneid && z.IsDeleted == 0).FirstOrDefault();
var tabpolygondtls = context.TabZonepolygon.Where(z => z.Zoneid == zoneid).ToList();
if (tabzone != null)
{
tabzone.IsActive = isStatus == true ? 1 : 0;
tabzone.UpdatedAt = DateTime.UtcNow;
tabzone.UpdatedBy = loggedInUser.UserName;
context.TabZone.Update(tabzone);
foreach (var tabpoly in tabpolygondtls)
{
tabpoly.IsActive = isStatus ? 1 : 0;
tabpoly.UpdatedAt = DateTime.UtcNow;
tabpoly.UpdatedBy = loggedInUser.UserName;
context.TabZonepolygon.Update(tabpoly);
}
context.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message.ToString(), "Admin", "DeleteZone", context);
return(false);
}
}
public List <UserList> BlockedList(TaxiAppzDBContext context)
{
try
{
List <UserList> userListModel = new List <UserList>();
var userlist = context.TabUser.Where(u => u.IsActive == false && u.IsDelete == 0).ToList();
foreach (var user in userlist)
{
userListModel.Add(new UserList()
{
Name = user.Firstname + ' ' + user.Lastname,
Email = user.Email,
Phoneno = user.PhoneNumber,
Status = user.IsActive,
Id = user.Id
});
}
return(userListModel == null ? null : userListModel);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "BlockedList", context);
return(null);
}
}
public List <Roles> GetRoleList(TaxiAppzDBContext context)
{
try
{
List <Roles> rolelist = new List <Roles>();
var listroles = context.TabRoles.Where(t => t.IsDelete == 0).ToList();
foreach (var role in listroles)
{
rolelist.Add(new Roles()
{
RoleID = role.Roleid,
RoleName = role.RoleName,
DisplayName = role.DisplayName,
Description = role.Description,
IsActive = role.IsActive.ToString()
});
}
return(rolelist != null ? rolelist : null);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "GetRoleList", context);
return(null);
}
}
public bool EditType(TaxiAppzDBContext context, VehicleTypeInfo vehicleTypeInfo, LoggedInUser loggedInUser)
{
try
{
var updatedate = context.TabTypes.Where(r => r.Typeid == vehicleTypeInfo.Id && r.IsDeleted == 0).FirstOrDefault();
if (updatedate != null)
{
updatedate.Imagename = vehicleTypeInfo.Image;
updatedate.Typename = vehicleTypeInfo.Name;
updatedate.UpdatedAt = DateTime.UtcNow;
updatedate.UpdatedBy = loggedInUser.UserName;
context.Update(updatedate);
context.SaveChanges();
return(true);
}
return(false);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, loggedInUser.UserName, System.Reflection.MethodBase.GetCurrentMethod().Name, context);
return(false);
}
}
public List <VehicleTypeList> ListType(TaxiAppzDBContext context)
{
try
{
//var filesStorage = StorageFactory.GetStorage();
List <VehicleTypeList> vehicleTypeLists = new List <VehicleTypeList>();
var vechilesTupe = context.TabTypes.Where(t => t.IsDeleted == 0).ToList().OrderByDescending(t => t.UpdatedAt);
foreach (var vechiles in vechilesTupe)
{
//var files = File.ReadAllBytes(filesStorage.GetDownloadFile(vechiles.Imagename, vechiles.Typeid.ToString(), "VechileTypes").FullName);
vehicleTypeLists.Add(new VehicleTypeList()
{
Id = vechiles.Typeid,
//Image = Convert.ToBase64String(files),
IsActive = vechiles.IsActive == 1 ? true : false,
Name = vechiles.Typename
});
}
return(vehicleTypeLists);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", System.Reflection.MethodBase.GetCurrentMethod().Name, context);
return(null);
}
}
public bool EditSetprice(List <SetPrice> setPrice, TaxiAppzDBContext context)
{
try
{
foreach (var setprice in setPrice)
{
var tabSetpriceZonetype = context.TabSetpriceZonetype.Where(t => t.Zonetypeid == setprice.ZoneTypeid && t.RideType == setprice.RideType && t.IsDelete == false).FirstOrDefault();
if (tabSetpriceZonetype != null)
{
tabSetpriceZonetype.Zonetypeid = setprice.ZoneTypeid;
tabSetpriceZonetype.Baseprice = setprice.BasePrice;
tabSetpriceZonetype.Pricepertime = setprice.PricePerTime;
tabSetpriceZonetype.Basedistance = setprice.BaseDistance;
tabSetpriceZonetype.Priceperdistance = setprice.PricePerDistance;
tabSetpriceZonetype.Customseldrifee = setprice.CustomerIdfee;
tabSetpriceZonetype.Freewaitingtime = setprice.Freewaitingtime;
tabSetpriceZonetype.Waitingcharges = setprice.WaitingCharges;
tabSetpriceZonetype.Cancellationfee = setprice.CancellationFee;
tabSetpriceZonetype.Dropfee = setprice.DropFee;
tabSetpriceZonetype.Admincommtype = setprice.admincommtype;
tabSetpriceZonetype.Admincommission = setprice.admincommission;
tabSetpriceZonetype.Driversavingper = setprice.Driversavingper;
tabSetpriceZonetype.RideType = setprice.RideType;
context.TabSetpriceZonetype.Update(tabSetpriceZonetype);
}
else
{
TabSetpriceZonetype tabSetprice = new TabSetpriceZonetype();
tabSetprice.Zonetypeid = setprice.ZoneTypeid;
tabSetprice.Baseprice = setprice.BasePrice;
tabSetprice.Pricepertime = setprice.PricePerTime;
tabSetprice.Basedistance = setprice.BaseDistance;
tabSetprice.Priceperdistance = setprice.PricePerDistance;
tabSetprice.Freewaitingtime = setprice.Freewaitingtime;
tabSetprice.Waitingcharges = setprice.WaitingCharges;
tabSetprice.Customseldrifee = setprice.CustomerIdfee == null ? 0 : setprice.CustomerIdfee;
tabSetprice.Cancellationfee = setprice.CancellationFee;
tabSetprice.Dropfee = setprice.DropFee;
tabSetprice.Admincommtype = setprice.admincommtype;
tabSetprice.Admincommission = setprice.admincommission;
tabSetprice.Driversavingper = setprice.Driversavingper;
tabSetprice.RideType = setprice.RideType;
context.TabSetpriceZonetype.Add(tabSetprice);
}
context.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "EditSetPrice", context);
return(false);
}
}
public string GetMenukey(string rolename, TaxiAppzDBContext context)
{
string menuname = null;
try
{
var menulist = context.TabMenuAccess.Include(r => r.Menu).Include(t => t.Role).Where(s => s.Role.RoleName == rolename && s.Viewstatus == true).ToList();
if (menulist.Count > 0)
{
return(menuname = string.Join(",", menulist.Select(x => x.Menu.Menukey)));
}
return(menuname);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "Menukey", context);
return(null);
}
}
public bool AddType(TaxiAppzDBContext context, VehicleTypeInfo vehicleTypeInfo, LoggedInUser loggedInUser)
{
var filesStorage = StorageFactory.GetStorage();
bool isFileMoved = false;
var file = context.TabUploadfiledetails.FirstOrDefault(t => t.Fileid == long.Parse(vehicleTypeInfo.Image));
if (file == null)
{
throw new DataValidationException("File does not exist");
}
try
{
var fileName = file.Filename;
isFileMoved = fileName == "" ? false : true;
TabTypes tabTypes = new TabTypes();
tabTypes.Imagename = fileName;
tabTypes.Typename = vehicleTypeInfo.Name;
tabTypes.IsActive = 1;
tabTypes.IsDeleted = 0;
tabTypes.CreatedAt = DateTime.UtcNow;
tabTypes.UpdatedAt = DateTime.UtcNow;
tabTypes.UpdatedBy = tabTypes.CreatedBy = loggedInUser.UserName;
context.TabTypes.Add(tabTypes);
context.SaveChanges();
filesStorage.MoveToPersistant(file.Filename, tabTypes.Typeid.ToString(), "VechileTypes");
isFileMoved = true;
return(true);
}
catch (Exception ex)
{
if (!isFileMoved)
{
filesStorage.MoveToTemp(file.Filename, vehicleTypeInfo.Image, "VechileTypes");
}
Extention.insertlog(ex.Message, "Admin", System.Reflection.MethodBase.GetCurrentMethod().Name, context);
return(false);
}
}
public bool SaveSurgePrice(SurgePrice surgePrice, TaxiAppzDBContext content, LoggedInUser loggedIn)
{
var existZone = content.TabZone.FirstOrDefault(t => t.IsDeleted == 0 && t.Zoneid == surgePrice.Zoneid);
if (existZone == null)
{
throw new DataValidationException("Zone name does not exist");
}
var exist = content.TabSurgeprice.FirstOrDefault(t => t.IsDelete == false && t.ZoneId == surgePrice.Zoneid);
if (exist == null)
{
TabSurgeprice tabSurgeprice = new TabSurgeprice();
tabSurgeprice.PeakType = surgePrice.Peaktype;
tabSurgeprice.StartTime = surgePrice.Starttime;
tabSurgeprice.ZoneId = surgePrice.Zoneid;
tabSurgeprice.EndTime = surgePrice.Endtime;
tabSurgeprice.SurgepriceType = surgePrice.Surgepricetype;
tabSurgeprice.SurgepriceValue = surgePrice.Surgepricevalue;
tabSurgeprice.IsActive = true;
tabSurgeprice.UpdatedAt = tabSurgeprice.CreatedAt = Extention.GetDateTime();
tabSurgeprice.UpdatedBy = tabSurgeprice.CreatedBy = loggedIn.UserName;
content.TabSurgeprice.Add(tabSurgeprice);
content.SaveChanges();
return(true);
}
else
{
exist.PeakType = surgePrice.Peaktype;
exist.StartTime = surgePrice.Starttime;
exist.EndTime = surgePrice.Endtime;
exist.SurgepriceType = surgePrice.Surgepricetype;
exist.SurgepriceValue = surgePrice.Surgepricevalue;
exist.UpdatedAt = Extention.GetDateTime();
exist.UpdatedBy = loggedIn.UserName;
content.TabSurgeprice.Update(exist);
content.SaveChanges();
return(true);
}
}
public ZoneTypeRelation GetZoneTypebyid(long zoneid, long zonetypeid, TaxiAppzDBContext context)
{
try
{
ZoneTypeRelation zoneTypeRelation = new ZoneTypeRelation();
var zonetype = context.TabZonetypeRelationship.Include(t => t.Zoneid == zoneid && t.Typeid == zonetypeid).FirstOrDefault();
if (zonetype != null)
{
zoneTypeRelation.Typeid = zonetype.Typeid;
zoneTypeRelation.Paymentmode = zonetype.Paymentmode;
zoneTypeRelation.Showbill = zonetype.Showbill == true ? "YES" : "NO";
return(zoneTypeRelation != null ? zoneTypeRelation : null);
}
return(null);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message.ToString(), "Admin", "GetZoneTypebyid", context);
return(null);
}
}
public VehicleEmerInfo GetbyEmerId(TaxiAppzDBContext context, long id)
{
try
{
VehicleEmerInfo vehicleEmerInfo = new VehicleEmerInfo();
var listService = context.TabSos.FirstOrDefault(t => t.Sosid == id && t.IsDeleted == 0);
if (listService != null)
{
vehicleEmerInfo.Id = listService.Sosid;
vehicleEmerInfo.Number = listService.ContactNumber;
vehicleEmerInfo.Name = listService.Sosname;
}
return(vehicleEmerInfo != null ? vehicleEmerInfo : null);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", System.Reflection.MethodBase.GetCurrentMethod().Name, context);
return(null);
}
}
public bool StatusEmer(TaxiAppzDBContext context, long id, bool isStatus, LoggedInUser loggedInUser)
{
try
{
var tabSos = context.TabSos.Where(r => r.Sosid == id && r.IsDeleted == 0).FirstOrDefault();
if (tabSos != null)
{
tabSos.IsActive = isStatus == true ? 1 : 0;
tabSos.UpdatedAt = DateTime.UtcNow;
tabSos.UpdatedBy = loggedInUser.UserName;
context.Update(tabSos);
context.SaveChanges();
return(true);
}
return(false);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", System.Reflection.MethodBase.GetCurrentMethod().Name, context);
return(false);
}
}
public List <VehicleTypeZoneList> ListTypeWithZone(TaxiAppzDBContext context)
{
try
{
List <VehicleTypeZoneList> vehicleTypeLists = new List <VehicleTypeZoneList>();
var vechilesTupe = context.TabZonetypeRelationship.Include(t => t.Zone).Include(t => t.Type).Where(t => t.IsDelete == 0 && t.Zone != null).ToList().OrderByDescending(t => t.UpdatedAt);
foreach (var vechiles in vechilesTupe)
{
vehicleTypeLists.Add(new VehicleTypeZoneList()
{
Id = vechiles.Zonetypeid,
Name = vechiles.Zone.Zonename + '-' + vechiles.Type.Typename
});;
}
return(vehicleTypeLists);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", System.Reflection.MethodBase.GetCurrentMethod().Name, context);
return(null);
}
}
public bool DisableUser(TaxiAppzDBContext context, long id, bool status, LoggedInUser loggedInUser)
{
try
{
var updatedate = context.TabUser.Where(u => u.Id == id && u.IsDelete == 0).FirstOrDefault();
if (updatedate != null)
{
updatedate.UpdatedAt = TimeZoneInfo.ConvertTimeToUtc(DateTime.Now);
updatedate.UpdatedBy = "Admin";
updatedate.IsActive = status;
context.Update(updatedate);
context.SaveChanges();
return(true);
}
return(false);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "DisableUser", context);
return(false);
}
}
public List <ManageZone> ListServiceBasedZone(long zoneid, TaxiAppzDBContext context)
{
try
{
List <ManageZone> typeLists = new List <ManageZone>();
var typelist = context.TabZone.Where(t => t.Servicelocid == zoneid && t.IsDeleted == 0).ToList();
foreach (var type in typelist)
{
typeLists.Add(new ManageZone()
{
Zoneid = type.Zoneid,
ZoneName = type.Zonename
});
}
return(typeLists == null ? null : typeLists);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message.ToString(), "Admin", "ListZoneType", context);
return(null);
}
}
public SurgePrice GetSurgePrice(TaxiAppzDBContext context, long zoneId)
{
try
{
SurgePrice surgePrice = new SurgePrice();
var listSurgePrice = context.TabSurgeprice.FirstOrDefault(t => t.ZoneId == zoneId);
if (listSurgePrice != null)
{
surgePrice.Id = listSurgePrice.SurgepriceId;
surgePrice.Starttime = listSurgePrice.StartTime;
surgePrice.Endtime = listSurgePrice.EndTime;
surgePrice.Peaktype = listSurgePrice.PeakType;
surgePrice.Surgepricetype = listSurgePrice.SurgepriceType;
surgePrice.Surgepricevalue = listSurgePrice.SurgepriceValue;
}
return(surgePrice != null ? surgePrice : null);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", System.Reflection.MethodBase.GetCurrentMethod().Name, context);
return(null);
}
}
public List <TypeList> ListTypesDuringAddZone(long zoneid, TaxiAppzDBContext context)
{
try
{
List <TypeList> typeLists = new List <TypeList>();
var typelist = context.TabZonetypeRelationship.Where(t => t.Zoneid == zoneid).Select(t => t.Typeid).ToList();
var types = context.TabTypes.Where(x => !typelist.Contains(x.Typeid) && x.IsActive == 1 && x.IsDeleted == 0).ToList();
foreach (var type in types)
{
typeLists.Add(new TypeList()
{
Id = type.Typeid,
Name = type.Typename
});
}
return(typeLists == null ? null : typeLists);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message.ToString(), "Admin", "ListZoneType", context);
return(null);
}
}
public List <SetPrice> GetSetprice(long zoneid, long zonetypeid, TaxiAppzDBContext context)
{
try
{
List <SetPrice> setPrices = new List <SetPrice>();
var getsetpricelist = context.TabSetpriceZonetype.Where(t => t.Zonetypeid == zonetypeid && t.IsDelete == false).ToList();
foreach (var getprice in getsetpricelist)
{
setPrices.Add(new SetPrice()
{
SetPriceid = getprice.Setpriceid,
ZoneTypeid = getprice.Zonetypeid,
BasePrice = getprice.Baseprice,
PricePerTime = getprice.Pricepertime,
BaseDistance = getprice.Basedistance,
PricePerDistance = getprice.Priceperdistance,
Freewaitingtime = getprice.Freewaitingtime,
WaitingCharges = getprice.Waitingcharges,
CancellationFee = getprice.Cancellationfee,
DropFee = getprice.Dropfee,
admincommtype = getprice.Admincommtype,
admincommission = getprice.Admincommission,
CustomerIdfee = getprice.Customseldrifee,
Driversavingper = getprice.Driversavingper,
RideType = getprice.RideType
});
}
return(setPrices);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "EditSetPrice", context);
return(null);
}
}
public AdminDetails GetbyId(long id, TaxiAppzDBContext context)
{
try
{
AdminDetails adminInfo = new AdminDetails();
var data = context.TabAdmin.Include(t => t.TabAdminDetails).Where(t => t.Id == id && t.IsDeleted == 0).FirstOrDefault();
if (data != null)
{
adminInfo.Country = 0;
adminInfo.Email = data.Email;
adminInfo.Emerphonenumber = data.EmergencyNumber;
adminInfo.Firstname = data.Firstname;
adminInfo.Languagename = data.Language;
adminInfo.Lastname = data.Lastname;
adminInfo.Password = data.Password;
adminInfo.Phonenumber = data.PhoneNumber;
adminInfo.RoleId = data.Role;
}
var tabAdmin = context.TabAdminDetails.Where(t => t.AdminId == id && t.IsDeleted == 0).FirstOrDefault();
if (tabAdmin != null)
{
adminInfo.Address = tabAdmin.Address;
adminInfo.Postalcode = tabAdmin.PostalCode;
adminInfo.Country = tabAdmin.CountryId;
adminInfo.Postalcode = tabAdmin.PostalCode;
adminInfo.DocumentName = tabAdmin.DocumentName;
}
return(adminInfo != null ? adminInfo : null);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "GetbyId", context);
return(null);
}
}
public Roles GetRoleDtls(TaxiAppzDBContext context, long id)
{
try
{
Roles _role = new Roles();
var roleresult = context.TabRoles.Where(r => r.Roleid == id).FirstOrDefault();
if (roleresult != null)
{
_role.RoleID = roleresult.Roleid;
_role.RoleName = roleresult.RoleName;
_role.DisplayName = roleresult.DisplayName;
_role.Description = roleresult.Description;
_role.IsActive = roleresult.IsActive.ToString();
return(_role);
}
_role.Status = "No Data Found";
return(_role);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "GetRoleDtls", context);
return(null);
}
}
public List <ZoneTypeList> ListZoneType(long zoneid, TaxiAppzDBContext context)
{
try
{
List <ZoneTypeList> zoneTypeLists = new List <ZoneTypeList>();
var zonetypelist = context.TabZonetypeRelationship.Include(t => t.Type).Where(z => z.Zoneid == zoneid && z.IsDelete == 0).ToList();
foreach (var zonetype in zonetypelist)
{
zoneTypeLists.Add(new ZoneTypeList()
{
Id = zonetype.Zonetypeid,
Name = zonetype.Type.Typename,
IsDefault = zonetype.IsDefault,
IsActive = zonetype.IsActive == 0 ? false : true
});
}
return(zoneTypeLists == null ? null : zoneTypeLists);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message.ToString(), "Admin", "ListZoneType", context);
return(null);
}
}
public List <VehicleEmerList> ListEmer(TaxiAppzDBContext context)
{
try
{
List <VehicleEmerList> vehicleEmerList = new List <VehicleEmerList>();
var vechilesEmer = context.TabSos.Where(t => t.IsDeleted == 0).ToList().OrderByDescending(t => t.UpdatedAt);
foreach (var vechi in vechilesEmer)
{
vehicleEmerList.Add(new VehicleEmerList()
{
Id = vechi.Sosid,
Name = vechi.Sosname,
Number = vechi.ContactNumber,
IsActive = vechi.IsActive == 1 ? true : false
});
}
return(vehicleEmerList);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", System.Reflection.MethodBase.GetCurrentMethod().Name, context);
return(null);
}
}
