public List <FrayteCustomerAssociatedUser> GetCustomerDetail(string Name, int RoleId) { List <FrayteCustomerAssociatedUser> customer = new List <FrayteCustomerAssociatedUser>(); // To Do : customer should come according to moduleType var operationzone = UtilityRepository.GetOperationZone(); if (RoleId == (int)FrayteUserRole.Admin || RoleId == (int)FrayteUserRole.Staff) { var findUser = (from u in dbContext.Users.Where(p => p.ContactName.Contains(Name)) join ur in dbContext.UserRoles on u.UserId equals ur.UserId where u.IsActive == true && u.OperationZoneId == operationzone.OperationZoneId && ur.RoleId == (int)FrayteUserRole.Customer select u).ToList(); if (findUser != null && findUser.Count > 0) { FrayteCustomerAssociatedUser associateUser; foreach (var uu in findUser) { var phonecode = (from ua in dbContext.UserAddresses join c in dbContext.Countries on ua.CountryId equals c.CountryId where ua.UserId == uu.UserId select new { PhoneCode = c.CountryPhoneCode }).FirstOrDefault(); associateUser = new FrayteCustomerAssociatedUser(); associateUser.UserId = uu.UserId; associateUser.ContactName = uu.ContactName; associateUser.Email = uu.UserEmail; associateUser.TelephoneNo = (phonecode == null || phonecode.PhoneCode == "") ? uu.TelephoneNo : "(+" + phonecode.PhoneCode + ") " + uu.TelephoneNo; associateUser.WorkingHours = UtilityRepository.GetWorkingHours(uu.WorkingStartTime, uu.WorkingEndTime); customer.Add(associateUser); } } } return(customer); }
public void GetAssociateCustomeDetail(FrayteInternalUser customer) { customer.AssociateCustomer = new List <FrayteAssociateCustomer>(); FrayteAssociateCustomer user; var associatedetail = (from cs in dbContext.CustomerStaffs join u in dbContext.Users on cs.UserId equals u.UserId join ua in dbContext.UserAddresses on u.UserId equals ua.UserId join c in dbContext.Countries on ua.CountryId equals c.CountryId where cs.CustomerStaffId == customer.UserId && cs.IsActive == true && u.IsActive == true select new { CustomerStaffDetailId = cs.CustomerStaffDetailId, UserId = u.UserId, ContactName = u.ContactName, Email = u.UserEmail, PhoneCode = (c == null || c.CountryPhoneCode == "") ? "" : c.CountryPhoneCode, TelephoneNo = u.TelephoneNo, WorkingStartTime = u.WorkingStartTime, WorkingEndTime = u.WorkingEndTime }).ToList(); if (associatedetail != null && associatedetail.Count > 0) { foreach (var dd in associatedetail) { user = new FrayteAssociateCustomer(); user.CustomerId = dd.UserId; user.CustomerStaffDetailId = dd.CustomerStaffDetailId; user.CustomerName = dd.ContactName; user.Email = dd.Email; user.ContactNo = dd.PhoneCode == "" ? dd.TelephoneNo : "(+" + dd.PhoneCode + ") " + dd.TelephoneNo; user.WorkingHours = UtilityRepository.GetWorkingHours(dd.WorkingStartTime, dd.WorkingEndTime); customer.AssociateCustomer.Add(user); } } }
public FrayteWarehouse GetWarehouseDetail(int?warehouseId) { FrayteWarehouse warehouseDetail = new FrayteWarehouse(); WorkingWeekDay workingDays = new WorkingWeekDay(); var warehouse = dbContext.Warehouses.Where(p => p.WarehouseId == warehouseId).FirstOrDefault(); if (warehouse != null) { warehouseDetail.WarehouseId = warehouse.WarehouseId; warehouseDetail.Address = warehouse.Address; warehouseDetail.Address2 = warehouse.Address2; warehouseDetail.Address3 = warehouse.Address3; warehouseDetail.City = warehouse.City; warehouseDetail.State = warehouse.State; warehouseDetail.Zip = warehouse.Zip; warehouseDetail.WorkingWeekDay = new WorkingWeekDay(); if (warehouse.WorkingWeekDayId != null) { warehouseDetail.WorkingWeekDay.WorkingWeekDayId = warehouse.WorkingWeekDayId.Value; } if (warehouseDetail.WorkingWeekDay.WorkingWeekDayId > 0) { workingDays = dbContext.WorkingWeekDays.Find(warehouseDetail.WorkingWeekDay.WorkingWeekDayId); } if (workingDays != null) { warehouseDetail.WorkingWeekDay = workingDays; } warehouseDetail.Email = warehouse.Email; warehouseDetail.TelephoneNo = warehouse.TelephoneNo; warehouseDetail.MobileNo = warehouse.MobileNo; warehouseDetail.Fax = warehouse.Fax; warehouseDetail.WorkingStartTime = UtilityRepository.GetTimeZoneTime(warehouse.WorkingStartTime, warehouse.TimeZoneId); warehouseDetail.WorkingEndTime = UtilityRepository.GetTimeZoneTime(warehouse.WorkingEndTime, warehouse.TimeZoneId); warehouseDetail.Address3 = warehouse.Address3; warehouseDetail.Address3 = warehouse.Address3; warehouseDetail.Address3 = warehouse.Address3; warehouseDetail.LocationMapImage = warehouse.LocationMapImage; warehouseDetail.LocationName = warehouse.LocationName; warehouseDetail.MapDetail = new GrayteGoogleMap(); warehouseDetail.MapDetail.latitude = warehouse.LocationLatitude.HasValue ? warehouse.LocationLatitude.Value : 0; warehouseDetail.MapDetail.longitude = warehouse.LocationLongitude.HasValue ? warehouse.LocationLongitude.Value : 0; warehouseDetail.Zoom = warehouse.LocationZoom.HasValue ? warehouse.LocationZoom.Value : 0; warehouseDetail.MarkerDetail = new GrayteGoogleMap(); warehouseDetail.MarkerDetail.latitude = warehouse.MarkerLatitude.HasValue ? warehouse.MarkerLatitude.Value : 0; warehouseDetail.MarkerDetail.longitude = warehouse.MarkerLongitude.HasValue ? warehouse.MarkerLongitude.Value : 0; //Get Country Details var country = dbContext.Countries.Where(p => p.CountryId == warehouse.CountryId).FirstOrDefault(); if (country != null) { warehouseDetail.Country = new FrayteCountryCode(); warehouseDetail.Country.CountryId = country.CountryId; warehouseDetail.Country.Code = country.CountryCode; warehouseDetail.Country.Code2 = country.CountryCode2; warehouseDetail.Country.Name = country.CountryName; } else { warehouseDetail.Country = new FrayteCountryCode(); } //Get TimeZone details var timezone = dbContext.Timezones.Where(p => p.TimezoneId == warehouse.TimeZoneId).FirstOrDefault(); if (timezone != null) { warehouseDetail.Timezone = new TimeZoneModal(); warehouseDetail.Timezone.TimezoneId = timezone.TimezoneId; warehouseDetail.Timezone.Name = timezone.Name; warehouseDetail.Timezone.Offset = timezone.Offset; warehouseDetail.Timezone.OffsetShort = timezone.OffsetShort; } else { warehouseDetail.Timezone = new TimeZoneModal(); } //Get warehouse manager detail var warehouseManager = dbContext.Users.Where(p => p.UserId == warehouse.ManagerId).FirstOrDefault(); if (warehouseManager != null) { warehouseDetail.Manager = new FrayteCustomerAssociatedUser(); warehouseDetail.Manager.UserId = warehouseManager.UserId; warehouseDetail.Manager.AssociateType = FrayteAssociateType.Manager; warehouseDetail.Manager.ContactName = warehouseManager.ContactName; warehouseDetail.Manager.Email = warehouseManager.Email; warehouseDetail.Manager.TelephoneNo = warehouseManager.TelephoneNo; warehouseDetail.Manager.WorkingHours = UtilityRepository.GetWorkingHours(warehouseManager.WorkingStartTime, warehouseManager.WorkingEndTime); } else { warehouseDetail.Manager = new FrayteCustomerAssociatedUser(); } } return(warehouseDetail); }
public List <FrayteWarehouse> GetAllWarehouseList() { List <FrayteWarehouse> lstFrayteWarehouse = new List <FrayteWarehouse>(); var lstWarehouse = (from w in dbContext.Warehouses join c in dbContext.Countries on w.CountryId equals c.CountryId join tz in dbContext.Timezones on w.TimeZoneId equals tz.TimezoneId join u in dbContext.Users on w.ManagerId equals u.UserId into tempManager from us in tempManager.DefaultIfEmpty() select new { w.WarehouseId, w.Address, w.Address2, w.Address3, w.City, w.State, w.Zip, w.CountryId, c.CountryCode, c.CountryName, w.LocationName, w.LocationLatitude, w.LocationMapImage, w.ManagerId, ManagerName = us.ContactName, ManagerEmail = us.Email, ManagerTelephone = us.TelephoneNo, ManagerStartTime = us.WorkingStartTime, ManagerEndTime = us.WorkingEndTime, w.Email, w.TelephoneNo, w.MobileNo, w.Fax, w.WorkingStartTime, w.WorkingEndTime, w.TimeZoneId, TimeZoneName = tz.Name, TimeZoneOffset = tz.Offset, TimezoneOffSetShort = tz.OffsetShort }).ToList(); if (lstWarehouse != null) { foreach (var w in lstWarehouse) { FrayteWarehouse frayteWarehouse = new FrayteWarehouse(); frayteWarehouse.WarehouseId = w.WarehouseId; frayteWarehouse.Address = w.Address; frayteWarehouse.Address2 = w.Address2; frayteWarehouse.Address3 = w.Address3; frayteWarehouse.City = w.City; frayteWarehouse.State = w.State; frayteWarehouse.Zip = w.Zip; frayteWarehouse.Country = new FrayteCountryCode(); frayteWarehouse.Country.CountryId = w.CountryId; frayteWarehouse.Country.Code = w.CountryCode; frayteWarehouse.Country.Name = w.CountryName; frayteWarehouse.LocationName = w.LocationName; frayteWarehouse.LocationMapImage = w.LocationMapImage; frayteWarehouse.Manager = new FrayteCustomerAssociatedUser(); frayteWarehouse.Manager.UserId = w.ManagerId.HasValue ? w.ManagerId.Value : 0; if (frayteWarehouse.Manager.UserId > 0) { frayteWarehouse.Manager.ContactName = w.ManagerName; frayteWarehouse.Manager.Email = w.ManagerEmail; frayteWarehouse.Manager.TelephoneNo = w.ManagerTelephone; frayteWarehouse.Manager.WorkingHours = UtilityRepository.GetWorkingHours(w.ManagerStartTime, w.ManagerEndTime); } frayteWarehouse.Email = w.Email; frayteWarehouse.TelephoneNo = w.TelephoneNo; frayteWarehouse.MobileNo = w.MobileNo; frayteWarehouse.Fax = w.Fax; frayteWarehouse.WorkingStartTime = UtilityRepository.GetTimeZoneTime(w.WorkingStartTime, w.TimeZoneName); frayteWarehouse.WorkingEndTime = UtilityRepository.GetTimeZoneTime(w.WorkingEndTime, w.TimeZoneName); frayteWarehouse.Timezone = new TimeZoneModal(); frayteWarehouse.Timezone.TimezoneId = w.TimeZoneId; frayteWarehouse.Timezone.Name = w.TimeZoneName; frayteWarehouse.Timezone.Offset = w.TimeZoneOffset; frayteWarehouse.Timezone.OffsetShort = w.TimezoneOffSetShort; lstFrayteWarehouse.Add(frayteWarehouse); } } return(lstFrayteWarehouse); }