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