public ResultData DeleteAddressBranch(long id) { ResultData resultData = new ResultData(); try { StudioAddress studioAddress = db.StudioAddresses.Where(t => t.Id == id).FirstOrDefault(); if (studioAddress != null) { db.StudioAddresses.Remove(studioAddress); db.SaveChanges(); } resultData.Message = "Data Deleted Successfully"; resultData.IsSuccess = true; resultData.Data = 1; return(resultData); } catch (Exception ex) { resultData.Message = ex.Message.ToString(); resultData.IsSuccess = false; resultData.Data = 0; ErrorLog errorLog = new ErrorLog(); errorLog.ErrorMessage = ex.Message.ToString(); errorLog.StackTrace = ex.StackTrace.ToString(); errorLog.EventName = "DeleteAddressBranch"; return(resultData); } }
public ResultData SaveAddressBranch(StudioAddress data) { ResultData resultData = new ResultData(); try { if (data != null && data.Id == 0) { db.StudioAddresses.Add(data); db.SaveChanges(); } else if (data.Id > 0) { StudioAddress oldStudioAddress = db.StudioAddresses.Where(n => n.Id == data.Id).FirstOrDefault(); if (oldStudioAddress != null) { oldStudioAddress.Country = data.Country; oldStudioAddress.StateId = data.StateId; oldStudioAddress.CityId = data.CityId; oldStudioAddress.StudioId = data.StudioId; oldStudioAddress.Address = data.Address; oldStudioAddress.LatLong = data.LatLong; oldStudioAddress.Pincode = data.Pincode; oldStudioAddress.StudioName = data.StudioName; db.SaveChanges(); } } resultData.Message = "Data Saved Successfully"; resultData.IsSuccess = true; resultData.Data = "1"; return(resultData); } catch (Exception ex) { resultData.Message = ex.Message.ToString(); resultData.IsSuccess = false; resultData.Data = 0; ErrorLog errorLog = new ErrorLog(); errorLog.ErrorMessage = ex.Message.ToString(); errorLog.StackTrace = ex.StackTrace.ToString(); errorLog.EventName = "SaveAddressBranch"; return(resultData); } }
private static HomeBoothDbContext SeedTestContext(HomeBoothDbContext testContext) { List <Client> testClients = new() { new Client { Id = "id1", CreatedOn = DateTime.UtcNow, Email = "*****@*****.**", FirstName = "Basil", LastName = "Pilsner", PhoneNumber = "XXX-XXX-XXXX", }, new Client { Id = "id2", CreatedOn = DateTime.UtcNow, Email = "*****@*****.**", FirstName = "Fatboi", LastName = "Pilsner", PhoneNumber = "XXX-XXX-XXXX", }, }; List <Host> testHosts = new() { new Host { Id = "1", CreatedOn = DateTime.UtcNow, Email = "*****@*****.**", FirstName = "Roger", LastName = "Waters", PhoneNumber = "XXX-XXX-XXX" }, new Host { Id = "2", CreatedOn = DateTime.UtcNow, Email = "*****@*****.**", FirstName = "David", LastName = "Gilmour", PhoneNumber = "XXX-XXX-XXX" }, }; Studio testStudio = new() { Id = 2, CreatedOn = DateTime.UtcNow, Name = "The Hive", Host = testHosts[0], Address = new StudioAddress { AddressLine1 = "3522 Oak Ave", AddressLine2 = "", City = "Nashville", State = "TN", PostalCode = "23428", Country = "USA", CreatedOn = DateTime.UtcNow, }, Description = "We are the best studio", Services = new List <StudioService> { new StudioService { Description = "The best producing ever", ServiceName = "Mixing" }, new StudioService { Description = "The best mastering ever", ServiceName = "Mastering" }, }, Rate = 20, StudioItems = new List <StudioItem> { new StudioItem { Name = "SM57", ItemType = "Microphone", Condition = "New", Quanitity = 4, CreatedOn = DateTime.UtcNow, } }, Schedules = new List <StudioSchedule> { new StudioSchedule { } }, IsBooked = false, }; testContext.Hosts.AddRange(testHosts); testContext.Clients.AddRange(testClients); testContext.Studios.Add(testStudio); testContext.SaveChanges(); foreach (var entity in testContext.ChangeTracker.Entries()) { entity.State = EntityState.Detached; } return(testContext); }