public OperationStatus ActionCarPoolRequest(CarPoolAssociationCustomModel model) { OperationStatus status = OperationStatus.Error; DateTime PoolDate = Convert.ToDateTime(model.DDate); try { using (dbcontext = new CarPoolApplicationEntities()) { var updatePoolInfo = dbcontext.tblCarPoolMemberAssociations.FirstOrDefault(x => x.AssociationId == model.AssociationId); if (updatePoolInfo != null) { updatePoolInfo.IsApproved = model.IsApproved; updatePoolInfo.ModifiedBy = model.ModifiedBy; updatePoolInfo.ModifiedDate = DateTime.Now; dbcontext.SaveChanges(); status = OperationStatus.Update; } else { status = OperationStatus.Duplicate; } } } catch (Exception ex) { dbcontext.Dispose(); status = OperationStatus.Exception; throw ex; } return(status); }
/// <summary> /// This method is used to save new pool info /// </summary> /// <returns></returns> public OperationStatus SaveCarPoolApplication(CarPoolRegistrationCustomModel model) { OperationStatus status = OperationStatus.Error; try { using (dbcontext = new CarPoolApplicationEntities()) { if (model.Id == 0) { tblCarPoolRegistration _addCarPool = new tblCarPoolRegistration { MemberId = model.MemberId, Source = model.Source, Destination = model.Destination, PoolDate = model.PoolDate, Time = model.Time, Charges = model.Charges, SeatsAvailable = model.SeatsAvailable, IsActive = true, IsDeleted = false, CreatedDate = DateTime.Now, CreatedBy = model.CreatedBy, ModifiedDate = DateTime.Now, ModifiedBy = model.ModifiedBy, }; dbcontext.tblCarPoolRegistrations.Add(_addCarPool); dbcontext.SaveChanges(); status = OperationStatus.Success; } else { var updatePoolInfo = dbcontext.tblCarPoolRegistrations.FirstOrDefault(m => m.Id == model.Id); if (updatePoolInfo != null) { updatePoolInfo.MemberId = model.MemberId; updatePoolInfo.Source = model.Source; updatePoolInfo.Destination = model.Destination; updatePoolInfo.PoolDate = model.PoolDate; updatePoolInfo.Time = model.Time; updatePoolInfo.Charges = model.Charges; updatePoolInfo.SeatsAvailable = model.SeatsAvailable; updatePoolInfo.ModifiedBy = model.ModifiedBy; updatePoolInfo.ModifiedDate = DateTime.Now; dbcontext.SaveChanges(); status = OperationStatus.Update; } } } } catch (Exception ex) { dbcontext.Dispose(); status = OperationStatus.Exception; throw ex; } return(status); }
/// <summary> /// This method is used to save new members /// </summary> /// <returns></returns> public OperationStatus SaveApplicationUser(ApplicationUserModel applicationUserModel) { OperationStatus status = OperationStatus.Error; using (TransactionScope ts = new TransactionScope()) { try { using (dbcontext = new CarPoolApplicationEntities()) { if (applicationUserModel.ApplicationUserId == 0) { var rs = dbcontext.tblApplicationUsers.FirstOrDefault(x => x.UserName == applicationUserModel.UserName && x.IsDeleted == false); if (rs == null) { tblMember _addMember = new tblMember { Name = applicationUserModel.Name, EmailId = applicationUserModel.EmailId, MobileNo = applicationUserModel.MobileNo, Gender = applicationUserModel.Gender, DateOfBirth = applicationUserModel.DateOfBirth, Address = applicationUserModel.Address, FatherName = applicationUserModel.FatherName, MotherName = applicationUserModel.MotherName, IsActive = true, IsDeleted = false, CreatedDate = DateTime.Now, CreatedBy = applicationUserModel.CreatedBy, ModifiedDate = DateTime.Now, ModifyBy = applicationUserModel.ModifyBy, }; dbcontext.tblMembers.Add(_addMember); dbcontext.SaveChanges(); int userid = _addMember.MemberId; tblApplicationUser _applicationUserinfo = new tblApplicationUser { Name = applicationUserModel.Name, EmailId = applicationUserModel.EmailId, MobileNo = applicationUserModel.MobileNo, UserIdentityKey = userid, UserName = applicationUserModel.UserName, Password = applicationUserModel.Password, IsActive = true, IsDeleted = false, CreatedDate = DateTime.Now, CreatedBy = applicationUserModel.CreatedBy, ModifiedDate = DateTime.Now, ModifyBy = applicationUserModel.ModifyBy, }; dbcontext.tblApplicationUsers.Add(_applicationUserinfo); dbcontext.SaveChanges(); status = OperationStatus.Success; ts.Complete(); } else { status = OperationStatus.Duplicate; //ts.Dispose(); } } } } catch (Exception ex) { dbcontext.Dispose(); status = OperationStatus.Exception; ts.Dispose(); throw ex; } } return(status); }
/// <summary> /// This method is used to save car pool requests /// </summary> /// <returns></returns> public OperationStatus SubmitCarPoolRequest(CarPoolAssociationCustomModel model) { OperationStatus status = OperationStatus.Error; DateTime PoolDate = Convert.ToDateTime(model.DDate); try { using (dbcontext = new CarPoolApplicationEntities()) { if (model.AssociationId == 0) { var rs = dbcontext.tblCarPoolMemberAssociations.FirstOrDefault(x => x.MemberId == model.MemberId && x.CarPoolId == model.CarPoolId && (x.DDate.Value.Year == PoolDate.Year && x.DDate.Value.Month == PoolDate.Month && x.DDate.Value.Day == PoolDate.Day) ); if (rs == null) { tblCarPoolMemberAssociation _addCarPool = new tblCarPoolMemberAssociation { MemberId = model.MemberId, CarPoolId = model.CarPoolId, DDate = PoolDate, Description = model.Description, IsApproved = 1, IsActive = true, IsDeleted = false, CreatedDate = DateTime.Now, CreatedBy = model.CreatedBy, ModifiedDate = DateTime.Now, ModifiedBy = model.ModifiedBy, }; dbcontext.tblCarPoolMemberAssociations.Add(_addCarPool); dbcontext.SaveChanges(); status = OperationStatus.Success; } else { status = OperationStatus.Duplicate; } } else { var rs = dbcontext.tblCarPoolMemberAssociations.FirstOrDefault(m => m.IsDeleted == false && m.MemberId == model.MemberId && m.CarPoolId == model.CarPoolId && (m.DDate.Value.Year == PoolDate.Year && m.DDate.Value.Month == PoolDate.Month && m.DDate.Value.Day == PoolDate.Day) && m.AssociationId != model.AssociationId ); if (rs == null) { var updatePoolInfo = dbcontext.tblCarPoolMemberAssociations.FirstOrDefault(x => x.AssociationId == model.AssociationId); if (updatePoolInfo != null) { updatePoolInfo.MemberId = model.MemberId; updatePoolInfo.CarPoolId = model.CarPoolId; updatePoolInfo.DDate = PoolDate; updatePoolInfo.Description = model.Description; updatePoolInfo.ModifiedBy = model.ModifiedBy; updatePoolInfo.ModifiedDate = DateTime.Now; dbcontext.SaveChanges(); status = OperationStatus.Update; } } else { status = OperationStatus.Duplicate; } } } } catch (Exception ex) { dbcontext.Dispose(); status = OperationStatus.Exception; throw ex; } return(status); }