public bool EditZoneType(ZoneTypeRelation zoneTypeRelation, TaxiAppzDBContext context, LoggedInUser loggedInUser)
{
var serviceExist = context.TabZone.FirstOrDefault(t => t.IsDeleted == 0 && t.Zoneid == zoneTypeRelation.Zoneid);
if (serviceExist == null)
{
throw new DataValidationException($"Zone does not already exists.");
}
var typeExist = context.TabTypes.FirstOrDefault(t => t.IsDeleted == 0 && t.Typeid == zoneTypeRelation.Typeid);
if (typeExist == null)
{
throw new DataValidationException($"Vechile type does not already exists.");
}
var zonetypeedit = context.TabZonetypeRelationship.Where(z => z.Zoneid == zoneTypeRelation.Zoneid && z.Typeid == zoneTypeRelation.Typeid).FirstOrDefault();
if (zonetypeedit != null)
{
zonetypeedit.Zoneid = zoneTypeRelation.Zoneid;
zonetypeedit.Typeid = zoneTypeRelation.Typeid;
zonetypeedit.Paymentmode = zoneTypeRelation.Paymentmode;
zonetypeedit.Showbill = zoneTypeRelation.Showbill.ToUpper() == "YES" ? true : false;
zonetypeedit.IsActive = 1;
context.TabZonetypeRelationship.Update(zonetypeedit);
context.SaveChanges();
return(true);
}
return(false);
}
public ManagePromo GetPromoDetails(long promoid, TaxiAppzDBContext content)
{
try
{
ManagePromo managepromo = new ManagePromo();
var promodetails = content.TabPromo.Where(t => t.Promoid == promoid).FirstOrDefault();
if (promodetails != null)
{
managepromo.CoupenCode = promodetails.CouponCode;
managepromo.EstimateAmount = promodetails.PromoEstimateAmount;
managepromo.Value = promodetails.PromoValue;
managepromo.Zoneid = promodetails.Zoneid;
managepromo.Uses = promodetails.PromoUses;
managepromo.RepeatedlyUse = promodetails.PromoUsersRepeateduse;
managepromo.StartDate = promodetails.StartDate;
managepromo.ExpiryDate = promodetails.EndDate;
return(managepromo);
}
return(null);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "GetPromoDetails", content);
return(null);
}
}
public List <PromoTransaction> PromoTransaction(TaxiAppzDBContext content)
{
try
{
List <PromoTransaction> promoTransactions = new List <PromoTransaction>();
var promolist = content.TabPromo.Where(t => t.IsDelete == false).ToList();
if (promolist.Count > 0)
{
foreach (var promo in promolist)
{
promoTransactions.Add(new PromoTransaction()
{
PromoID = promo.Promoid,
CoupenCode = promo.CouponCode,
Value = promo.PromoValue,
Type = promo.PromoType,
Uses = promo.PromoUses
});
}
}
return(promoTransactions == null ? null : promoTransactions);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "PromoTransaction", content);
return(null);
}
}
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 EditCurrency(TaxiAppzDBContext context, CurrencyInfo currencyInfo, LoggedInUser loggedInUser)
{
var zoneexist = context.TabCurrencies.FirstOrDefault(t => t.IsDelete == 0 && t.Currenciesid == currencyInfo.StandardId);
if (zoneexist == null)
{
throw new DataValidationException($"Currency standard does not exists");
}
var updatedate = context.TabCommonCurrency.Where(r => r.Currencyid == currencyInfo.CurrencyID && r.IsDeleted == 0).FirstOrDefault();
if (updatedate == null)
{
throw new DataValidationException($"Currency does not exists");
}
if (updatedate != null)
{
updatedate.Currencyname = currencyInfo.CurrencyName;
updatedate.CurrencySymbol = currencyInfo.CurrencySymbol;
updatedate.Currenciesid = currencyInfo.StandardId;
updatedate.UpdatedAt = DateTime.UtcNow;
updatedate.UpdatedBy = loggedInUser.Email;
context.Update(updatedate);
context.SaveChanges();
return(true);
}
return(false);
}
public bool SaveTripSettings(TripSettings tripSettings, TaxiAppzDBContext content, LoggedInUser loggedIn)
{
var exist = content.TabTripSettings.FirstOrDefault(t => t.IsActive == false && t.TripSettingsId == tripSettings.Id);
if (exist == null)
{
TabTripSettings tabTripSettings = new TabTripSettings();
tabTripSettings.TripSettingsQuestion = tripSettings.TripSettingQuestion;
tabTripSettings.TripSettingsAnswer = tripSettings.TripSettingAnswer;
tabTripSettings.IsActive = true;
tabTripSettings.UpdatedAt = tabTripSettings.CreatedAt = Extention.GetDateTime();
tabTripSettings.UpdatedBy = tabTripSettings.CreatedBy = loggedIn.UserName;
content.TabTripSettings.Add(tabTripSettings);
content.SaveChanges();
return(true);
}
else
{
exist.TripSettingsQuestion = tripSettings.TripSettingQuestion;
exist.TripSettingsAnswer = tripSettings.TripSettingAnswer;
exist.UpdatedAt = Extention.GetDateTime();
exist.UpdatedBy = loggedIn.UserName;
content.TabTripSettings.Update(exist);
content.SaveChanges();
return(true);
}
}
public bool EditService(TaxiAppzDBContext context, ServiceInfo serviceInfo, LoggedInUser loggedInUser)
{
var serviceExists = context.TabServicelocation.FirstOrDefault(t => t.IsDeleted == 0 && t.Name.ToLower() == serviceInfo.ServiceName.ToLower() && t.Servicelocid != serviceInfo.ServiceId);
if (serviceExists != null)
{
throw new DataValidationException($"Service with name '{serviceExists.Name}' already exists.");
}
var updatedate = context.TabServicelocation.Where(r => r.Servicelocid == serviceInfo.ServiceId && r.IsDeleted == 0).FirstOrDefault();
if (updatedate != null)
{
updatedate.Countryid = serviceInfo.CountryId;
updatedate.Timezoneid = serviceInfo.TimezoneId;
updatedate.Currencyid = serviceInfo.CurrencyId;
updatedate.Name = serviceInfo.ServiceName;
updatedate.UpdatedAt = DateTime.UtcNow;
updatedate.UpdatedBy = loggedInUser.Email;
context.Update(updatedate);
context.SaveChanges();
return(true);
}
return(false);
}
public bool SaveCancelDriver(TaxiAppzDBContext context, CancelDriverInfo cancelDriverInfo, LoggedInUser loggedInUser)
{
var roleExist = context.TabDriverCancellation.FirstOrDefault(t => t.IsDelete == false && t.Zonetypeid == cancelDriverInfo.Zonetypeid);
if (roleExist == null)
{
throw new DataValidationException($"Tab driver cancellation does not exists");
}
TabDriverCancellation tabDriverCancellation = new TabDriverCancellation();
tabDriverCancellation.Arrivalstatus = cancelDriverInfo.ArrivalStatus;
tabDriverCancellation.CancellationReasonArabic = cancelDriverInfo.CancelReasonArabic;
tabDriverCancellation.CancellationReasonEnglish = cancelDriverInfo.CancelReasonEnglish;
tabDriverCancellation.CancellationReasonSpanish = cancelDriverInfo.CancelReasonSpanish;
tabDriverCancellation.Paymentstatus = cancelDriverInfo.PaymentStatus;
tabDriverCancellation.Zonetypeid = cancelDriverInfo.Zonetypeid;
tabDriverCancellation.CreatedAt = tabDriverCancellation.UpdatedAt = TimeZoneInfo.ConvertTimeToUtc(DateTime.Now);
tabDriverCancellation.CreatedBy = tabDriverCancellation.UpdatedBy = loggedInUser.Email;
tabDriverCancellation.IsDelete = false;
tabDriverCancellation.IsActive = true;
context.Add(tabDriverCancellation);
context.SaveChanges();
return(true);
}
public bool EditUser(TaxiAppzDBContext context, CancelUserInfo cancelUserInfo, LoggedInUser loggedInUser)
{
var roleExist = context.TabZonetypeRelationship.FirstOrDefault(t => t.IsDelete == 0 && t.Zonetypeid == cancelUserInfo.Zonetypeid);
if (roleExist == null)
{
throw new DataValidationException($"Zone type does not exists");
}
var tabUserCancellation = context.TabUserCancellation.Where(r => r.UserCancelId == cancelUserInfo.Id && r.IsDelete == false).FirstOrDefault();
if (tabUserCancellation != null)
{
tabUserCancellation.Arrivalstatus = cancelUserInfo.ArrivalStatus;
tabUserCancellation.CancellationReasonArabic = cancelUserInfo.CancelReasonArabic;
tabUserCancellation.CancellationReasonEnglish = cancelUserInfo.CancelReasonEnglish;
tabUserCancellation.CancellationReasonSpanish = cancelUserInfo.CancelReasonSpanish;
tabUserCancellation.Paymentstatus = cancelUserInfo.PaymentStatus;
tabUserCancellation.Zonetypeid = cancelUserInfo.Zonetypeid;
tabUserCancellation.UpdatedAt = TimeZoneInfo.ConvertTimeToUtc(DateTime.Now);
tabUserCancellation.UpdatedBy = loggedInUser.Email;
context.Update(tabUserCancellation);
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 List <CancelDriver> DriverList(TaxiAppzDBContext context)
{
try
{
List <CancelDriver> cancelDrivers = new List <CancelDriver>();
var driverlist = context.TabDriverCancellation.Where(t => t.IsDelete == false).ToList().OrderByDescending(t => t.UpdatedAt);
foreach (var drivers in driverlist)
{
cancelDrivers.Add(new CancelDriver()
{
Id = drivers.DriverCancelId,
ArrivalStatus = drivers.Arrivalstatus,
CancellationList = drivers.CancellationReasonEnglish,
PayingStatus = drivers.Paymentstatus,
Type = "driver",
IsActive = drivers.IsActive
});
}
return(cancelDrivers);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "DriverList", 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 ActiveZoneType(long zoneid, long typeid, bool isactivestatus, TaxiAppzDBContext context, LoggedInUser loggedInUser)
{
var serviceExist = context.TabZone.FirstOrDefault(t => t.IsDeleted == 0 && t.Zoneid == zoneid);
if (serviceExist == null)
{
throw new DataValidationException($"Zone does not already exists.");
}
var typeExist = context.TabTypes.FirstOrDefault(t => t.IsDeleted == 0 && t.Typeid == typeid);
if (typeExist == null)
{
throw new DataValidationException($"Vechile type does not already exists.");
}
var zonetypeedit = context.TabZonetypeRelationship.Where(z => z.Zoneid == zoneid && z.Typeid == typeid).FirstOrDefault();
if (zonetypeedit != null)
{
zonetypeedit.IsActive = isactivestatus ? 1 : 0;
context.TabZonetypeRelationship.Update(zonetypeedit);
context.SaveChanges();
return(true);
}
return(false);
}
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 bool SaveReferral(ManageReferral manageReferral, TaxiAppzDBContext content, LoggedInUser loggedIn)
{
try
{
if (content.TabManageReferral.Any(t => t.IsActive == true && t.ReferralGainAmountPerPerson == manageReferral.ReferralGain_Amount_PerPerson && t.ReferralWorthAmount == manageReferral.ReferralWorth_Amount && t.TripToCompletedToearnRefferalAmount == manageReferral.Trip_to_completed_toearn_refferalAmount && t.TripToCompletedTorefer == manageReferral.Trip_to_completed_torefer))
{
return(true);
}
TabManageReferral tabManageReferral = new TabManageReferral();
tabManageReferral.ReferralGainAmountPerPerson = manageReferral.ReferralGain_Amount_PerPerson;
tabManageReferral.ReferralWorthAmount = manageReferral.ReferralWorth_Amount;
tabManageReferral.TripToCompletedTorefer = manageReferral.Trip_to_completed_toearn_refferalAmount;
tabManageReferral.TripToCompletedToearnRefferalAmount = manageReferral.Trip_to_completed_torefer;
tabManageReferral.IsActive = true;
tabManageReferral.UpdatedAt = tabManageReferral.CreatedAt = Extention.GetDateTime();
tabManageReferral.UpdatedBy = tabManageReferral.CreatedBy = loggedIn.UserName;
content.TabManageReferral.Add(tabManageReferral);
foreach (var referral in content.TabManageReferral.Where(t => t.IsActive == true).ToList())
{
referral.IsActive = false;
referral.UpdatedAt = Extention.GetDateTime();
referral.UpdatedBy = loggedIn.UserName;
}
content.SaveChanges();
return(true);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "PromoTransaction", content);
return(false);
}
}
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 TripSettings GetTripSettings(TaxiAppzDBContext context)
{
try
{
TripSettings trips = new TripSettings();
var listTripSetting = context.TabTripSettings.Where(t => t.IsActive == true).ToList();
trips.AssignMethod = listTripSetting.FirstOrDefault(t => t.TripSettingsId == 1).TripSettingsAnswer;
trips.RequestWaitSecond = listTripSetting.FirstOrDefault(t => t.TripSettingsId == 2).TripSettingsAnswer;
trips.CaptainGetTrips = listTripSetting.FirstOrDefault(t => t.TripSettingsId == 3).TripSettingsAnswer;
trips.CaptainsRatingLimit = listTripSetting.FirstOrDefault(t => t.TripSettingsId == 4).TripSettingsAnswer;
trips.CertainMinutes = listTripSetting.FirstOrDefault(t => t.TripSettingsId == 5).TripSettingsAnswer;
trips.DispatchRequest = listTripSetting.FirstOrDefault(t => t.TripSettingsId == 6).TripSettingsAnswer;
trips.LocationChangeLimit = listTripSetting.FirstOrDefault(t => t.TripSettingsId == 7).TripSettingsAnswer;
trips.PickupLocationUnits = listTripSetting.FirstOrDefault(t => t.TripSettingsId == 8).TripSettingsAnswer;
trips.RequestInKm = listTripSetting.FirstOrDefault(t => t.TripSettingsId == 9).TripSettingsAnswer;
trips.ScheduleTripsTime = listTripSetting.FirstOrDefault(t => t.TripSettingsId == 10).TripSettingsAnswer;
trips.RewardPoints = listTripSetting.FirstOrDefault(t => t.TripSettingsId == 11).TripSettingsAnswer;
trips.TransferTripAmount = listTripSetting.FirstOrDefault(t => t.TripSettingsId == 12).TripSettingsAnswer;
trips.TripGraceTime = listTripSetting.FirstOrDefault(t => t.TripSettingsId == 13).TripSettingsAnswer;
return(trips != null ? trips : null);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", System.Reflection.MethodBase.GetCurrentMethod().Name, context);
return(null);
}
}
public List <DrivertoUser> ListDriverRating(TaxiAppzDBContext context)
{
try
{
List <DrivertoUser> drivertoUsers = new List <DrivertoUser>();
var driverList = context.TabRequestRating.Include(t => t.User).Include(t => t.Driver).ToList();
foreach (var driver in driverList)
{
drivertoUsers.Add(new DrivertoUser()
{
Id = driver.RatingId,
Comment = driver.Comments,
DriverName = driver.Driver == null ? "" : driver.Driver.FirstName + ' ' + driver.Driver.LastName,
UserName = driver.User.Firstname + ' ' + driver.User.Lastname,
Rating = driver.UserRating,
RequestID = driver.RequestId
});
}
return(drivertoUsers);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "ListDriverRating", context);
return(null);
}
}
public List <ServiceListModel> ListService(TaxiAppzDBContext context)
{
try
{
List <ServiceListModel> rolelist = new List <ServiceListModel>();
var listService = context.TabServicelocation.Include(t => t.Country).Include(t => t.Timezone).Include(t => t.Currency).Where(t => t.IsDeleted == 0).ToList().OrderByDescending(t => t.UpdatedAt);
foreach (var service in listService)
{
rolelist.Add(new ServiceListModel()
{
Country = service.Country.Name,
CurrencyCode = service.Country.Currency,
CurrencySymbol = service.Currency.CurrencySymbol,
ServiceId = service.Servicelocid,
ServiceName = service.Name,
TimeZone = service.Timezone.Zonedescription
});
}
return(rolelist != null ? rolelist : null);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "ListService", context);
return(null);
}
}
public List <ManageFAQList> ListFAQ(TaxiAppzDBContext context)
{
try
{
List <ManageFAQList> manageFAQ = new List <ManageFAQList>();
var listFAQ = context.TabFaq.Where(t => t.IsDelete == false).ToList().OrderByDescending(t => t.UpdatedAt);
foreach (var FAQ in listFAQ)
{
manageFAQ.Add(new ManageFAQList()
{
Complaint_Type = FAQ.ComplaintType,
FAQ_Answer = FAQ.FaqAnswer,
FAQ_Question = FAQ.FaqQuestion,
Id = FAQ.Faqid,
IsActive = FAQ.IsActive,
Servicelocid = FAQ.Servicelocid
});
}
return(manageFAQ != null ? manageFAQ : null);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "ListFAQ", 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 List <ManageUserComplaint> ListUserComplaintTemplate(TaxiAppzDBContext context)
{
try
{
var complaintlist = context.TabUserComplaint.Where(t => t.IsDelete == false).ToList();
List <ManageUserComplaint> manageUserlist = new List <ManageUserComplaint>();
if (complaintlist.Count > 0)
{
foreach (var complaint in complaintlist)
{
manageUserlist.Add(new ManageUserComplaint()
{
UserComplaintType = complaint.UserComplaintType,
UserComplaintTitle = complaint.UserComplaintTitle,
IsActive = complaint.IsActive
});
}
return(manageUserlist);
}
return(null);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "ListUserComplaintTemplate", context);
return(null);
}
}
public List <CurrencyList> ListCurrency(TaxiAppzDBContext context)
{
try
{
List <CurrencyList> currencylist = new List <CurrencyList>();
var currencyList = context.TabCommonCurrency.Include(t => t.Currencies).Where(t => t.IsDeleted == 0).ToList().OrderByDescending(t => t.UpdatedAt);
foreach (var currency in currencyList)
{
currencylist.Add(new CurrencyList()
{
IsActive = currency.IsActive == 1 ? true : false,
CurrencyId = currency.Currencyid,
CurrencyName = currency.Currencyname,
StandardName = currency.Currencies.Currency,
Symbol = currency.CurrencySymbol
});;
}
return(currencylist);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "ListCurrency", context);
return(null);
}
}
public bool EditDriverComplainttemplate(ManageDriverComplaint manageDriver, TaxiAppzDBContext content, LoggedInUser loggedInUser)
{
var roleExist = content.TabDriverComplaint.FirstOrDefault(t => t.IsDelete == false && t.DriverComplaintId == manageDriver.DriverCompalintID);
if (roleExist == null)
{
throw new DataValidationException($"Driver comlaints does not exists");
}
var zoneexist = content.TabZone.FirstOrDefault(t => t.IsDeleted == 0 && t.Zoneid == manageDriver.ZoneId);
if (zoneexist != null)
{
throw new DataValidationException($"Zone does not exists");
}
var driverComplaintdtls = content.TabDriverComplaint.Where(t => t.DriverComplaintId == manageDriver.DriverCompalintID).FirstOrDefault();
driverComplaintdtls.DriverComplaintTitle = manageDriver.DriverComplaintTitle;
driverComplaintdtls.DriverComplaintType = manageDriver.DriverComplaintType;
driverComplaintdtls.Zoneid = manageDriver.ZoneId;
driverComplaintdtls.IsActive = true;
driverComplaintdtls.UpdatedAt = DateTime.UtcNow;
driverComplaintdtls.UpdatedBy = loggedInUser.UserName;
content.TabDriverComplaint.Update(driverComplaintdtls);
content.SaveChanges();
return(true);
}
private string GenerateJWTToken(TabAdmin userinfo, TaxiAppzDBContext context)
{
try
{
insertlog("Token Generation", userinfo.Email, "GenerateJWTToken", context);
var securityKey = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(_jwt.SecretKey));
var credentials = new SigningCredentials(securityKey, SecurityAlgorithms.HmacSha256);
var claims = new[]
{
new Claim(JwtRegisteredClaimNames.Sub, userinfo.Firstname),
new Claim("lastName", userinfo.Lastname),
new Claim("role", userinfo.RoleNavigation.RoleName),
new Claim("MailID", userinfo.Email),
new Claim(JwtRegisteredClaimNames.Jti, Guid.NewGuid().ToString()),
};
var token = new JwtSecurityToken(
issuer: _jwt.Issuer,
audience: _jwt.Audience,
claims: claims,
expires: DateTime.Now.AddMinutes(_jwt.AccessTokenDuration),
signingCredentials: credentials
);
return(new JwtSecurityTokenHandler().WriteToken(token));
}
catch (Exception ex)
{
insertlog(ex.Message, userinfo.Email, "GenerateJWTToken", context);
return(null);
}
}
public ManageEmailOption GetbyEmailId(TaxiAppzDBContext context, long id)
{
try
{
ManageEmailOption manageEmailOption = new ManageEmailOption();
var listEmail = context.TabManageEmail.FirstOrDefault(t => t.ManageEmailid == id);
if (listEmail != null)
{
manageEmailOption.Id = listEmail.ManageEmailid;
manageEmailOption.EmailTitle = listEmail.Emailtitle;
manageEmailOption.IsActive = listEmail.IsActive;
manageEmailOption.Description = listEmail.Description;
List <ManageSMSHint> manageSMSHints = new List <ManageSMSHint>();
var listHintSms = context.TabManageEmailHints.Where(t => t.ManageEmailid == listEmail.ManageEmailid).ToList();
foreach (var item in listHintSms)
{
ManageSMSHint sMSHint = new ManageSMSHint();
sMSHint.Id = item.ManageEmailHint;
sMSHint.Keyword = item.HintKeyword;
sMSHint.HintMsg = item.HintDescription;
manageSMSHints.Add(sMSHint);
}
}
return(manageEmailOption != null ? manageEmailOption : null);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "GetbyEmailId", context);
return(null);
}
}
public List <ManagePromo> ManageOption(TaxiAppzDBContext content)
{
try
{
List <ManagePromo> managePromos = new List <ManagePromo>();
var promolist = content.TabPromo.Where(t => t.IsDelete == false).ToList();
if (promolist.Count > 0)
{
foreach (var promo in promolist)
{
managePromos.Add(new ManagePromo()
{
PromoID = promo.Promoid,
CoupenCode = promo.CouponCode,
EstimateAmount = promo.PromoEstimateAmount,
Value = promo.PromoValue,
Zoneid = promo.Zoneid,
Uses = promo.PromoUses,
RepeatedlyUse = promo.PromoUsersRepeateduse,
StartDate = promo.StartDate,
ExpiryDate = promo.EndDate,
IsActive = promo.IsActive
});
}
}
return(managePromos == null ? null : managePromos);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "ManageOption", content);
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 bool AddPromo(ManagePromo managePromo, TaxiAppzDBContext content, LoggedInUser loggedIn)
{
var emailid = content.TabZone.FirstOrDefault(t => t.IsDeleted == 0 && t.Zoneid == managePromo.Zoneid);
if (emailid == null)
{
throw new DataValidationException($"Zone does not already exists.");
}
TabPromo tabPromo = new TabPromo();
tabPromo.CouponCode = managePromo.CoupenCode;
tabPromo.PromoEstimateAmount = managePromo.EstimateAmount;
tabPromo.PromoValue = managePromo.Value;
tabPromo.Zoneid = managePromo.Zoneid;
tabPromo.PromoType = managePromo.CoupenCode;
tabPromo.PromoUses = managePromo.Uses;
tabPromo.PromoUsersRepeateduse = managePromo.Value;
tabPromo.StartDate = managePromo.StartDate;
tabPromo.EndDate = managePromo.ExpiryDate;
tabPromo.IsActive = true;
tabPromo.IsDelete = true;
tabPromo.UpdatedAt = tabPromo.CreatedAt = DateTime.UtcNow;
tabPromo.UpdatedBy = tabPromo.CreatedBy = loggedIn.UserName;
content.TabPromo.Add(tabPromo);
content.SaveChanges();
return(true);
}
public bool AddZoneType(long zoneid, ZoneTypeRelation zoneTypeRelation, TaxiAppzDBContext context, LoggedInUser loggedInUser)
{
var serviceExist = context.TabZone.FirstOrDefault(t => t.IsDeleted == 0 && t.Zoneid == zoneTypeRelation.Zoneid);
if (serviceExist == null)
{
throw new DataValidationException($"Zone does not already exists.");
}
var typeExist = context.TabTypes.FirstOrDefault(t => t.IsDeleted == 0 && t.Typeid == zoneTypeRelation.Typeid);
if (typeExist == null)
{
throw new DataValidationException($"Vechile type does not already exists.");
}
var isrelationshipexist = context.TabZonetypeRelationship.Any(z => z.Zoneid == zoneid && z.IsDelete == 0);
TabZonetypeRelationship tabZonetypeRelationship = new TabZonetypeRelationship();
tabZonetypeRelationship.Zoneid = zoneTypeRelation.Zoneid;
tabZonetypeRelationship.Typeid = zoneTypeRelation.Typeid;
tabZonetypeRelationship.Paymentmode = zoneTypeRelation.Paymentmode;
tabZonetypeRelationship.Showbill = zoneTypeRelation.Showbill.ToUpper() == "YES" ? true : false;
tabZonetypeRelationship.IsActive = 1;
tabZonetypeRelationship.IsDefault = isrelationshipexist ? 0 : 1;
context.TabZonetypeRelationship.Add(tabZonetypeRelationship);
context.SaveChanges();
return(true);
}
