public static BusinessObjects.User GetDetails(int Id) { BusinessObjects.User userBO = null; using (ADOBathindaEntities context = new ADOBathindaEntities()) { var InDb = context.Users.Include(u => u.District).SingleOrDefault(u => u.Id == Id); userBO = new BusinessObjects.User { Name = InDb.Name, PhoneNumber = InDb.PhoneNumber, EmailId = InDb.EmailId, Id = InDb.Id, DistrictId = InDb.DistrictId }; //Adding Foreign Keys //District userBO.District = new BusinessObjects.District { Id = InDb.District.Id, Name = InDb.District.Name }; context.Dispose(); } return(userBO); }
public static bool Add(BusinessObjects.User userBO) { int i = 0; var user = new User { Name = userBO.Name, PhoneNumber = userBO.PhoneNumber, EmailId = userBO.EmailId, DistrictId = userBO.DistrictId }; using (ADOBathindaEntities context = new ADOBathindaEntities()) { context.Users.Add(user); i = context.SaveChanges(); context.Dispose(); } if (i > 0) { return(true); } else { return(false); } }
public static List <BusinessObjects.User> GetAllByDistrict(int DistrictId) { List <BusinessObjects.User> list = new List <BusinessObjects.User>(); using (ADOBathindaEntities context = new ADOBathindaEntities()) { var Users = context.Users.Include(u => u.District).Where(u => u.DistrictId == DistrictId).ToList(); foreach (var user in Users) { BusinessObjects.User UserBO = new BusinessObjects.User { Name = user.Name, PhoneNumber = user.PhoneNumber, EmailId = user.EmailId, Id = user.Id, DistrictId = user.DistrictId }; //Adding Foreign Keys //District UserBO.District = new BusinessObjects.District { Id = user.District.Id, Name = user.District.Name }; list.Add(UserBO); context.Dispose(); } } return(list); }
//ASSUMING YOUR RetrieveLogs.RetrieveMessages() function returns //a Message object. replace this type with whatever type the //RetrieveLogs.RetrieveMessages() method returns. public Message RetrieveKeyFn(string username, string password) { BusinessObjects.User p = RetreiveLogs.AuthenitcateCredentials(username, password); if (p != null) { var message = RetrieveLogs.RetrieveMessages(p.UserId); if (message == null) { // handle behavior for no messages. In this case // I will just create a new Message object with a -1 LogId return new Message { LogId = -1 } } ; else { return(message); } } else { //handle behavior when the user is not authenticated. //In this case I throw an exception throw new Exception(); } }
public BusinessObjects.User SaveUser(BusinessObjects.User user) { var request = _mapper.Map <DataAccess.Entity.User>(user); DataAccess.Entity.User entity = request.User_Id == 0 ? _userRepository.Create(request) : _userRepository.Update(request); var result = _mapper.Map <BusinessObjects.User>(entity); //result.Status = true; //result.StatusMessage = request.User_Id == 0 ? "User added successfully!" : "User updated successfully!"; return(result); }
public void UserMaps_BusinessObjectToEntity() { var bo = new BusinessObjects.User { UserId = 111, FirstName = "Firstname", LastName = "Lastname", EmployeeId = "emp123" }; var result = _mapper.Map <DataAccess.Entity.User>(bo); Assert.That(result.User_Id == 111); }
public BusinessObjects.User Read(long ID) { BusinessObjects.User UserItem = new BusinessObjects.User(); try { UserItem = (new DataAccess.Client.User()).Read(ID); } catch (Exception ex) { throw ex; } return UserItem; }
public BusinessObjects.User Read(long UserID) { BusinessObjects.User User = new BusinessObjects.User(); List<SqlParameter> param = new List<SqlParameter>(); param.Add(new SqlParameter("@PK_User_Id", UserID)); param.Add(new SqlParameter("@UserName", "")); param.Add(new SqlParameter("@password", "")); DataTable dt = Read(param.ToArray(), "SP_User_Read"); if (dt.Rows.Count > 0) { User = MapToUser(dt.Rows[0]); } return User; }
public static bool Delete(BusinessObjects.User userBO) { int i = 0; using (ADOBathindaEntities context = new ADOBathindaEntities()) { var InDb = context.Users.SingleOrDefault(u => u.Id == userBO.Id); context.Users.Remove(InDb); i = context.SaveChanges(); context.Dispose(); } if (i > 0) { return(true); } else { return(false); } }
public static bool Update(BusinessObjects.User userBO) { int i = 0; using (ADOBathindaEntities context = new ADOBathindaEntities()) { var InDb = context.Users.SingleOrDefault(u => u.Id == userBO.Id); InDb.Name = userBO.Name; InDb.PhoneNumber = userBO.PhoneNumber; InDb.EmailId = userBO.EmailId; InDb.DistrictId = userBO.DistrictId; i = context.SaveChanges(); context.Dispose(); } if (i > 0) { return(true); } else { return(false); } }
public static bool Delete(BusinessObjects.User userBO) { return(UserDA.Delete(userBO)); }
public static bool Update(BusinessObjects.User userBO) { return(UserDA.Update(userBO)); }
public static bool Add(BusinessObjects.User userBO) { return(UserDA.Add(userBO)); }
private BusinessObjects.User MapToUser(DataRow dr) { BusinessObjects.User User = new BusinessObjects.User(); User.PK_User_Id = Convert.ToInt32(dr["PK_User_ID"]); User.UserLogin.PK_User_Id = Convert.ToInt32(dr["PK_User_ID"]); User.UserLogin.UserName = Convert.ToString(dr["User_Name"]); User.UserType.PK_UserType_Id = Convert.ToInt16(dr["FK_Utype_Id"]); User.Age = Convert.ToInt16(dr["Age"]); User.State = Convert.ToInt32(dr["State"]); User.City = Convert.ToInt32(dr["City"]); User.Country = Convert.ToInt32(dr["Country"]); User.UserLogin.AuthType.Auth_Id = Convert.ToInt16(dr["AuthType"]); User.UserEmpType = Convert.ToInt16(dr["UserEmpType"]); User.IsOther = Convert.ToInt16(dr["IsOther"]); User.IsVerified = Convert.ToInt16(dr["IsVerified"]); User.Area = Convert.ToString(dr["User_Name"]); User.Education = Convert.ToString(dr["User_Name"]); User.Fax = Convert.ToString(dr["User_Name"]); User.FirstName = Convert.ToString(dr["User_Name"]); User.Gender = Convert.ToString(dr["User_Name"]); User.LastName = Convert.ToString(dr["User_Name"]); User.MaritalStatus = Convert.ToString(dr["User_Name"]); User.Mobile1 = Convert.ToString(dr["User_Name"]); User.Mobile2 = Convert.ToString(dr["User_Name"]); User.Occupation = Convert.ToString(dr["User_Name"]); User.OtherLocation = Convert.ToString(dr["User_Name"]); User.ZipCode = Convert.ToString(dr["User_Name"]); User.Birthdate = Convert.ToDateTime(dr["BirthDate"]); return User; }