public APIResponse UpdateUser(UserMasterDetail userMasterDetail)
{
APIResponse response = new APIResponse();
try
{
response.Data = userManager.UpdateUserMaster(userMasterDetail);
if (response.Data != 0)
{
response.Success = true;
response.Error = null;
}
else
{
response.Success = false;
response.Error = "Record not Updated";
}
}
catch (Exception ex)
{
response.Data = null;
response.Success = false;
response.Error = ex.Message;
}
return(response);
}
public int UpdateUserMaster(UserMasterDetail userMaster)
{
int result = 0;
try
{
string query = string.Format("update UserMaster set Name='{0}',Address='{1}',MobileNo='{2}',UserName='******',Password='******',RoleId={5},ShopId={6} where UserId={7}", userMaster.Name, userMaster.Address, userMaster.MobileNo, userMaster.UserName, userMaster.Password, userMaster.RoleId, userMaster.ShopId, userMaster.UserId);
result = _db.Execute(query);
}
catch (Exception EX)
{
throw;
}
return(result);
}
public UserMasterDetail SingleUserMaster(int userId)
{
UserMasterDetail dbEntityDetail = new UserMasterDetail();
try
{
string query = string.Format(@"select RoleMaster.RoleId,ShopMaster.ShopId, RoleMaster.RoleName,ShopMaster.ShopName, UserMaster.Name,UserMaster.Address,UserMaster.MobileNo,UserMaster.UserName,UserMaster.Password from UserMaster
inner join RoleMaster on RoleMaster.RoleId=UserMaster.RoleId
inner join ShopMaster on ShopMaster.ShopId=UserMaster.ShopId where UserMaster.IsDelete=0 and ShopMaster.IsDelete=0 and RoleMaster.IsDelete=0 and UserMaster.UserId={0}", userId);
dbEntityDetail = _db.Query <UserMasterDetail>(query).FirstOrDefault();
// lstUnitMaster = temp;
}
catch (Exception)
{
throw;
}
return(dbEntityDetail);
}
public int UpdateUserMaster(UserMasterDetail userMasterDetail)
{
return(userRepository.UpdateUserMaster(userMasterDetail));
}
