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;
}
