public IHttpActionResult PutUserPhone(int id, UserPhoneDTO userPhone)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != userPhone.UserPhoneID)
{
return(BadRequest());
}
try
{
db.Update(userPhone);
}
catch (DbUpdateConcurrencyException)
{
if (!UserPhoneExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
/// <summary>
/// Invoked when <see cref="ToDTO"/> operation is about to return.
/// </summary>
/// <param name="dto"><see cref="UserPhoneDTO"/> converted from <see cref="UserPhone"/>.</param>
static partial void OnDTO(this UserPhone entity, UserPhoneDTO dto)
{
if (entity != null && entity.Phone != null)
{
dto.Phone = PhoneAssembler.ToDTO(entity.Phone);
}
}
public UserPhoneDTO Create(UserPhoneDTO modelDTO)
{
if (modelDTO != null)
{
return(UserPhoneAssembler.ToDTO(userPhoneRepo.CreateUserPhone(UserPhoneAssembler.ToEntity(modelDTO))));
}
return(null);
}
public UserPhoneDTO Get(int id)
{
UserPhoneDTO userPhoneDTO = null;
if (id > 0)
{
userPhoneDTO = userPhoneRepo.GetUserPhone(id).ToDTO();
}
return(userPhoneDTO);
}
public IHttpActionResult PostUserPhone(UserPhoneDTO userPhone)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Create(userPhone);
return(CreatedAtRoute("DefaultApi", new { id = userPhone.UserPhoneID }, userPhone));
}
public IHttpActionResult GetUserPhone(int id)
{
UserPhoneDTO userPhone = db.Get(id);
if (userPhone == null)
{
return(NotFound());
}
return(Ok(userPhone));
}
public UserPhoneDTO Get(int UserPhoneID)
{
UserPhoneDTO oUserPhoneDTO = null;
if (UserPhoneID > 0)
{
UserPhone oUserPhone = oUserPhoneRepo.GetUserPhone(UserPhoneID);
}
return(oUserPhoneDTO);
}
public UserPhoneDTO Update(UserPhoneDTO modelDTO)
{
UserPhoneDTO returnUserPhone = null;
if (modelDTO != null && modelDTO.UserPhoneID > 0)
{
userPhoneRepo.UpdateUserPhone(0, UserPhoneAssembler.ToEntity(modelDTO));
returnUserPhone = modelDTO;
}
return(returnUserPhone);
}
public UserPhoneDTO Update(UserPhoneDTO oUserPhoneDTO)
{
UserPhoneDTO returnUserPhone = null;
if (oUserPhoneDTO != null && oUserPhoneDTO.UserPhoneID > 0)
{
oUserPhoneRepo.UpdateUserPhone(0, UserPhoneAssembler.ToEntity(oUserPhoneDTO));
returnUserPhone = oUserPhoneDTO;
}
return(returnUserPhone);
}
/// <summary>
/// Converts this instance of <see cref="UserPhone"/> to an instance of <see cref="UserPhoneDTO"/>.
/// </summary>
/// <param name="entity"><see cref="UserPhone"/> to convert.</param>
public static UserPhoneDTO ToDTO(this UserPhone entity)
{
if (entity == null)
{
return(null);
}
var dto = new UserPhoneDTO();
dto.UserPhoneID = entity.UserPhoneID;
dto.UserID = entity.UserID;
dto.PhoneID = entity.PhoneID;
dto.IsPrimary = entity.IsPrimary;
entity.OnDTO(dto);
return(dto);
}
/// <summary>
/// Converts this instance of <see cref="UserPhoneDTO"/> to an instance of <see cref="UserPhone"/>.
/// </summary>
/// <param name="dto"><see cref="UserPhoneDTO"/> to convert.</param>
public static UserPhone ToEntity(this UserPhoneDTO dto)
{
if (dto == null)
{
return(null);
}
var entity = new UserPhone();
entity.UserPhoneID = dto.UserPhoneID;
entity.UserID = dto.UserID;
entity.PhoneID = dto.PhoneID;
entity.IsPrimary = dto.IsPrimary;
dto.OnEntity(entity);
return(entity);
}
public UserDataModel GetUser(UserDTO userDTO)
{
UserDataModel userDataModel = null;
if (userDTO != null)
{
UserAddressDTO userAddressDTO = (userDTO.UserAddresses != null) ? userDTO.UserAddresses.Where(o => o.IsPrimary).FirstOrDefault() : null;
AddressDTO oPrimaryAddressDTO = (userAddressDTO != null) ? userAddressDTO.Address : null;
UserAccountDTO userAccountDTO = (userDTO.UserAddresses != null) ? userDTO.UserAccounts.FirstOrDefault(o => o.IsActive == true) : null;
UserPhoneDTO userPhoneDTO = (userDTO.UserPhones != null) ? userDTO.UserPhones.Where(o => o.IsPrimary).FirstOrDefault() : null;
PhoneDTO oPrimaryPhoneDTO = (userPhoneDTO != null) ? userPhoneDTO.Phone : null;
UserEmailDTO userEmailDTO = (userDTO.UserEmails != null) ? userDTO.UserEmails.Where(o => o.IsPrimary).FirstOrDefault() : null;
EmailDTO oPrimaryEmailDTO = (userEmailDTO != null) ? userEmailDTO.Email : null;
userDataModel = UserDataModelAssembler.ToDataModel(userDTO, userAccountDTO, oPrimaryAddressDTO, oPrimaryPhoneDTO, oPrimaryEmailDTO);
userDataModel.UserAddressID = (userAddressDTO != null) ? userAddressDTO.UserAddressID : 0;
userDataModel.UserPhoneID = (userPhoneDTO != null) ? userPhoneDTO.UserPhoneID : 0;
userDataModel.UserEmailID = (userEmailDTO != null) ? userEmailDTO.UserEmailID : 0;
}
return(userDataModel);
}
public UserDataModel Get(UserDTO modelDTO)
{
UserDataModel userDataModel = null;
if (modelDTO != null)
{
UserAddressDTO userAddressDTO = (modelDTO.UserAddresses != null) ? modelDTO.UserAddresses.Where(o => o.IsPrimary).FirstOrDefault() : null;
AddressDTO oPrimaryAddressDTO = (userAddressDTO != null) ? userAddressDTO.Address : null;
UserAccountDTO userAccountDTO = (modelDTO.UserAccounts != null) ? modelDTO.UserAccounts.FirstOrDefault(o => o.IsActive == true) : null;
UserPhoneDTO userPhoneDTO = (modelDTO.UserPhone != null) ? modelDTO.UserPhone.Where(o => o.IsPrimary).FirstOrDefault() : null;
PhoneDTO oPrimaryPhoneDTO = (userPhoneDTO != null) ? userPhoneDTO.Phone : null;
UserEmailDTO userEmailDTO = (modelDTO.UserEmails != null) ? modelDTO.UserEmails.Where(o => o.IsPrimary).FirstOrDefault() : null;
EmailDTO oPrimaryEmailDTO = (userEmailDTO != null) ? userEmailDTO.Email : null;
List <ExperienceDTO> userExpriencelDTO = (modelDTO.Experiences != null) ? modelDTO.Experiences.ToList() : null;
List <AchievementDTO> userAchievementlDTO = (modelDTO.Achievements != null) ? modelDTO.Achievements.ToList() : null;
List <EducationDTO> userEducationlDTO = (modelDTO.Educations != null) ? modelDTO.Educations.ToList() : null;
List <SkillDTO> userSkillDTO = (modelDTO.Skills != null) ? modelDTO.Skills.ToList() : null;
List <LanguageDTO> userLanguageDTO = (modelDTO.Languages != null) ? modelDTO.Languages.ToList() : null;
ImageDTO userImageDTO = (modelDTO.UserImages != null) ? modelDTO.UserImages.Where(x => x.IsPrimary == true).FirstOrDefault().Image : null;
//ImageDTO oPrimaryImage = (userImageDTO != null) ? userImageDTO.UserImageID : null;
userDataModel = UserDataModelAssembler.ToDataModel(modelDTO, userAccountDTO, oPrimaryAddressDTO, oPrimaryPhoneDTO, oPrimaryEmailDTO, userExpriencelDTO, userAchievementlDTO, userEducationlDTO, userSkillDTO, userLanguageDTO, userImageDTO);
userDataModel.UserAddressID = (userAddressDTO != null) ? userAddressDTO.UserAddressID : 0;
userDataModel.AddressID = (userAddressDTO != null) ? userAddressDTO.AddressID : 0;
userDataModel.UserPhoneID = (userPhoneDTO != null) ? userPhoneDTO.UserPhoneID : 0;
userDataModel.PhoneID = (userPhoneDTO != null) ? userPhoneDTO.PhoneID : 0;
userDataModel.UserEmailID = (userEmailDTO != null) ? userEmailDTO.UserEmailID : 0;
userDataModel.EmailID = (userEmailDTO != null) ? userEmailDTO.EmailID : 0;
}
return(userDataModel);
}
/// <summary> /// Invoked when <see cref="ToEntity"/> operation is about to return. /// </summary> /// <param name="entity"><see cref="UserPhone"/> converted from <see cref="UserPhoneDTO"/>.</param> static partial void OnEntity(this UserPhoneDTO dto, UserPhone entity);
/// <summary> /// Invoked when <see cref="ToDTO"/> operation is about to return. /// </summary> /// <param name="dto"><see cref="UserPhoneDTO"/> converted from <see cref="UserPhone"/>.</param> static partial void OnDTO(this UserPhone entity, UserPhoneDTO dto);
private List <UserPhoneDTO> GetUserPhonesDTO(Search search, out int _count)
{
_count = 0;
var result = new List <UserPhoneDTO>();
string queryEnd = "";
string head = "";
if (search.isCount == false)
{
head = @" usi.[ID]
,usi.[UserID]
,usr.UserName
,cst.Name as CustomerName
,cst.[Surname] as CustomerSurname
,usi.[CompanyName]
,usi.[ModelName]
,usi.[ModelNumber]
,usi.[SerialNumber]
,usi.[IMEI1]
,usi.[IMEI2]
,usi.[OSName]
,usi.[OSVersion]
,usi.InsertDate ";
}
else
{
head = @" count(*) as totalcount ";
}
StringBuilder allQuery = new StringBuilder();
var query = @"SELECT " + head + @" FROM [DB_A62358_ScoreMe].[dbo].[tbl_UserPhoneInforamtion] usi
join [dbo].[tbl_User] usr on usi.UserID=usr.ID and usr.Status=1
left join [dbo].[tbl_Customer] cst on cst.UserId=usr.ID and usr.Status=1
where usi.Status=1 ";
allQuery.Append(query);
var userNameQuery = @" and usr.UserName like N'%' + @P_UserName + '%'";
if (!string.IsNullOrEmpty(search.UserName))
{
allQuery.Append(userNameQuery);
}
var customerNameQuery = @" and cst.Name like N'%' + @P_Name+ '%'";
if (!string.IsNullOrEmpty(search.Name))
{
allQuery.Append(customerNameQuery);
}
if (search.isCount == false)
{
queryEnd = @" order by usi.ID desc OFFSET ( @PageNo - 1 ) * @RecordsPerPage ROWS FETCH NEXT @RecordsPerPage ROWS ONLY";
}
allQuery.Append(queryEnd);
using (var connection = new SqlConnection(ConnectionStrings.ConnectionString))
{
connection.Open();
using (var command = new SqlCommand(allQuery.ToString(), connection))
{
command.Parameters.AddWithValue("@PageNo", search.pageNumber);
command.Parameters.AddWithValue("@RecordsPerPage", search.pageSize);
command.Parameters.AddWithValue("@P_UserName", search.UserName.GetStringOrEmptyData());
command.Parameters.AddWithValue("@P_Name", search.Name.GetStringOrEmptyData());
var reader = command.ExecuteReader();
while (reader.Read())
{
if (search.isCount == false)
{
UserPhoneDTO userPhoneDTO = new UserPhoneDTO()
{
ID = reader.GetInt64OrDefaultValue(0),
UserID = reader.GetInt64OrDefaultValue(1),
UserName = reader.GetStringOrEmpty(2),
CustomerName = reader.GetStringOrEmpty(3),
CustomerSurname = reader.GetStringOrEmpty(4),
CompanyName = reader.GetStringOrEmpty(5),
ModelName = reader.GetStringOrEmpty(6),
ModelNumber = reader.GetStringOrEmpty(7),
SerialNumber = reader.GetStringOrEmpty(8),
IMEI1 = reader.GetStringOrEmpty(9),
IMEI2 = reader.GetStringOrEmpty(10),
OSName = reader.GetStringOrEmpty(11),
OSVersion = reader.GetStringOrEmpty(12),
InsertDate = reader.GetDateTimeOrEmpty(13)
};
result.Add(userPhoneDTO);
}
else
{
_count = reader.GetInt32OrDefaultValue(0);
}
}
}
connection.Close();
}
return(result);
}
