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 <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 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 <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 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 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 <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 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 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 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 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 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 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 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 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 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); } }