/// <summary> /// Get All Countries List /// </summary> /// <returns></returns> public IEnumerable <Countries> GetCountryList() { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); foreach (var x in ent.Countries) { yield return(x); } }
public List <AirlineFlightTaxesMappings> GetExistingAirlineName() { using (TravelPortalEntity.EntityModel entities = new TravelPortalEntity.EntityModel()) { var results = from o in entities.AirlineFlightTaxesMappings where o.AirlineId != o.AirlineId //&& o.AirlineId == o.MappingId select o; return(results.ToList <AirlineFlightTaxesMappings>()); } }
public List <AirlineFlightTaxesMappings> GetByFlightMapping(int id) { using (TravelPortalEntity.EntityModel entities = new TravelPortalEntity.EntityModel()) { var results = from o in entities.AirlineFlightTaxesMappings where o.AirlineId == id select o; return(results.ToList <AirlineFlightTaxesMappings>()); } }
public int GetAllSequenceNoFromControllerList(string ControllerName) { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var cc = (from aa in ent.ControllerLists.Where(b => b.ControllerName == ControllerName) select new RolePrivilageModel { SeqNumber = aa.SeqNumber }).Count(); return(cc); }
public int GetAllControllerName() { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var cc = (from aa in ent.ControllerGroups select new RolePrivilageModel { SeqNumber = aa.SeqNumber }).Count(); return(cc); }
public List <AgentSettingsModel> GetAllAdminSettingList() { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var cc = (from aa in ent.Settings.Where(ii => (ii.isActive == true && ii.SettingFor == "AGENT")) select new AgentSettingsModel { SettingName = aa.SettingName, SettingId = aa.SettingId, }).ToList(); return(cc); }
public List <LedgerMasterModel> GetAllAgentNameBasedonAccTypeName(int AgentId) { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var cc = (from aa in ent.Agents select new LedgerMasterModel { AgentId = aa.AgentId, AgentName = aa.AgentName }).ToList(); return(cc); }
public List <LedgerMasterModel> GetAllLedgerAccountBasedonAccTypeName(int LedgerAccountId) { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var cc = (from aa in ent.GL_LedgerAccTypes select new LedgerMasterModel { LedgerAccTypeId = aa.LedgerAccTypeId, LedgerAccTypeName = aa.LedgerAccTypeName }).ToList(); return(cc); }
public List <RolePrivilageModel> GetAllControllerNameBasedonProductandSubProduct(int ProductId, int SubProductId) { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var cc = (from aa in ent.ControllerLists where aa.ProductId == ProductId && aa.SubProductId == SubProductId select new RolePrivilageModel { ControllerId = aa.ControllerId, ControllerName = aa.ControllerName }).ToList(); return(cc); }
public void SaveAgentSetting(List <int> abinfo, int AgentId) { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); foreach (var item in abinfo) { ent.AgentSettings.AddObject(new AgentSettings() { AgentId = AgentId, SettingId = item, }); } ent.SaveChanges(); }
public void SaveRolePrivilageMapping(List <RolePrivilegeMappings> roleinfo) { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); foreach (var item in roleinfo) { ent.RolePrivilegeMappings.AddObject(new RolePrivilegeMappings() { RoleId = item.RoleId, PrivilegeId = item.PrivilegeId, }); } ent.SaveChanges(); }
public void DeleteAgentSetting(int agentid) { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); try { ent.DeleteAgentSetting(agentid); ent.SaveChanges(); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void SaveAgentProduct(List <Core_AgentProducts> abinfo) { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); foreach (var item in abinfo) { ent.Core_AgentProducts.AddObject(new Core_AgentProducts() { AgentId = item.AgentId, ProductId = item.ProductId, }); } ent.SaveChanges(); }
public LedgerMasterModel GetGLAccTypesBasedOnTypeName(int AccTypeId) { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var cc = (from aa in ent.GL_AccTypes.Where(x => x.AccTypeId == AccTypeId) select new LedgerMasterModel { MapTable = aa.MapTable, DisplayMember = aa.DisplayMember, ValueMember = aa.ValueMember, }).SingleOrDefault(); return(cc); }
public List <UserManagementModel.LockApprovedUserModel> GetUnppprovedUserAdminUserList() { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var cc = (from aa in ListAllAdminUser().Where(aa => aa.IsApproved == false) select new UserManagementModel.LockApprovedUserModel { UserName = aa.UserName, Email = aa.Email, IsApproved = aa.IsApproved, UserId = aa.UserId, IsLockedOut = aa.IsLockedOut }).ToList(); return(cc.ToList()); }
public List <AgentSettingsModel> GetAllActiveSettingForAgent(int agentid) { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var cc = (from aa in ent.Settings join bb in ent.AgentSettings on aa.SettingId equals bb.SettingId where bb.AgentId == agentid select new AgentSettingsModel { SettingName = aa.SettingName, SettingId = aa.SettingId, }).ToList(); return(cc); }
public List <UserManagementModel.LockApprovedUserModel> GetUnapprovedAgentUserList() { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var cc = (from aa in ent.GetUserByApproveStatus(false) select new UserManagementModel.LockApprovedUserModel { UserName = aa.UserName, AgentName = aa.AgentName, Email = aa.Email, IsApproved = aa.IsApproved, UserId = aa.UserId, }).ToList(); return(cc.ToList()); }
/// <summary> /// /// </summary> /// <returns></returns> /// public List <RoleBasedRoleModel> GetAllRolesListForAdmin() { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var cc = (from aa in ent.aspnet_Roles // join bb in ent.asp //on aa.RoleId equals bb.RoleId // where bb.CreatedBy == 0 select new RoleBasedRoleModel { RoleId = aa.RoleId, RoleName = aa.RoleName, }).ToList(); return(cc); }
public List <RoleBasedRoleModel> GetAllAdminRolesBasedonProductAndSubProduct(int ProductId) { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var cc = (from aa in ent.aspnet_Roles join bb in ent.Core_ProductRoles on aa.RoleId equals bb.RoleId where (bb.ProductId == ProductId && bb.Core_SubProduct.SubProductName == "Administrator") select new RoleBasedRoleModel { RoleId = aa.RoleId, RoleName = aa.RoleName, }).ToList(); return(cc); }
public List <RoleBasedRoleModel> GetAllRolesListForAgent(int agentid) { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var cc = (from aa in ent.aspnet_Roles join bb in ent.RoleUserTypeMappings on aa.RoleId equals bb.RoleId where (bb.CreatedBy == agentid || (bb.UserTypeId == 2 && bb.CreatedBy == 0)) select new RoleBasedRoleModel { RoleId = aa.RoleId, RoleName = aa.RoleName, }).ToList(); return(cc); }
//////////////////////////// Associated User Product List //////////////////////////////////////////////////// public List <RoleBasedRoleModel> GetAllAssociatedProductofAdminUser(Guid userid) { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var cc = (from aa in ent.Core_Products join bb in ent.Core_UserProducts on aa.ProductId equals bb.ProductId where bb.UsersDetails.UserId == userid select new RoleBasedRoleModel { ProductName = aa.ProductName, ProductId = aa.ProductId, }).ToList(); return(cc); }
public List <RoleBasedRoleModel> GetAllRolesListonProductWise(int ProductId) { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var cc = (from aa in ent.aspnet_Roles join bb in ent.Core_ProductRoles on aa.RoleId equals bb.RoleId where bb.ProductId == ProductId && bb.Core_SubProduct.SubProductName == "Agent" select new RoleBasedRoleModel { RoleId = aa.RoleId, RoleName = aa.RoleName, ProductId = bb.ProductId, }).ToList(); return(cc); }
public List <UserManagementModel.LockApprovedUserModel> GetAllLockedUserList() { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var cc = (from aa in ListAllRegisteredUser() select new UserManagementModel.LockApprovedUserModel { AgentName = aa.AgentName, UserName = aa.UserName, Email = aa.Email, IsApproved = aa.IsApproved, UserId = aa.UserId, IsLockedOut = aa.IsLockedOut }).ToList(); return(cc.ToList()); }
public void CheckExistanceofUserProduct(int UserId, int productid) { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var product = ent.Core_UserProducts.Where(xx => xx.UserId == UserId && xx.ProductId == productid).ToList(); if (product.Count() == 0) { Core_UserProducts obj = new Core_UserProducts { ProductId = productid, UserId = UserId, }; ent.AddToCore_UserProducts(obj); ent.SaveChanges(); } }
public IEnumerable <SelectListItem> ddlCityList() { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var result = ent.Bus_Cities.OrderBy(o => o.BusCityName); List <SelectListItem> ddlList = new List <SelectListItem>(); ddlList.Add(new SelectListItem { Text = "--Select--", Value = "" }); foreach (var item in result) { ddlList.Add(new SelectListItem { Value = item.BusCityId.ToString(), Text = item.BusCityName.ToString() + "(" + item.BusCityCode + ")" }); } return(ddlList); }
public IEnumerable <SelectListItem> OptionList() { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var result = ent.MRC_CardValue.Where(x => x.IsActive == true); List <SelectListItem> ddlList = new List <SelectListItem>(); ddlList.Add(new SelectListItem { Text = "--Select--", Value = "" }); foreach (var item in result) { ddlList.Add(new SelectListItem { Text = item.CardValue.ToString(), Value = item.CardValueId.ToString() }); } return(ddlList); }
//public List<LedgerMasterModel> GetAllAccTypesName(int id) //{ // TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); // var cc = (from aa in ent.GL_AccTypes // select new LedgerMasterModel // { // }).ToList(); // return cc; //} /*-----------------------------------------------------------------------------------------------------------------------------------------*/ /// <summary> /// / /// </summary> /// <param name="MapTable"></param> /// <param name="DisplayMember"></param> /// <param name="ValueMember"></param> /// <returns></returns> public List <LedgerMasterModel> GetAllAirlineNameBasedonAccTypeName(string MapTable, string DisplayMember, string ValueMember) { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var result = ent.Air_GetAccMappedValues(MapTable, DisplayMember, ValueMember); List <LedgerMasterModel> Search = new List <LedgerMasterModel>(); foreach (var item in result) { LedgerMasterModel obj = new LedgerMasterModel { ValueMember = item.ValueMember.ToString(), DisplayMember = item.DisplayMember, }; Search.Add(obj); } return(Search.ToList()); }
public IEnumerable <SelectListItem> ddlTypeList() { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var result = ent.Bus_Master.OrderBy(o => o.BusMasterName); List <SelectListItem> ddlList = new List <SelectListItem>(); ddlList.Add(new SelectListItem { Text = "--Select--", Value = "" }); ddlList.Add(new SelectListItem { Text = "Day(दिवा)", Value = "Day(दिवा)" }); ddlList.Add(new SelectListItem { Text = "Night(रात्री)", Value = "Night(रात्री)" }); return(ddlList); }
public void DeleteDistributorAgentSetting(int agentid) { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); try { var filteredSettings = ent.AgentSettings.Where(x => x.AgentId == agentid && (x.AgentSettingId == 5 || x.AgentSettingId == 6)); foreach (AgentSettings agentSetting in filteredSettings) { ent.DeleteObject(agentSetting); } ent.SaveChanges(); } catch (Exception ex) { throw new Exception(ex.Message); } }
public List <RoleBasedRoleModel> GetUserAssociatedRolewithProduct(Guid UserId) { TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel(); var result = (from a in ent.vw_aspnet_UsersInRoles join b in ent.aspnet_Roles on a.RoleId equals b.RoleId join c in ent.Core_ProductRoles on a.RoleId equals c.RoleId where a.UserId == UserId select new RoleBasedRoleModel { RoleId = b.RoleId, RoleName = b.RoleName, ProductId = c.ProductId, ProductName = c.Core_Products.ProductName }).ToList(); return(result); }