public string UpdageLocation(string userName, string tdUserGroupId) { object[] appUsrId = { new SqlParameter("@app_usr_id", userName) }; object[] tdUserGroupIdParam = { new SqlParameter("@tdUserGroupId", tdUserGroupId) }; var rep = new GenericRepository <usp_returnUserData>(_context); rep.ExecueUpdate("sp_SetAppUser", appUsrId); rep.ExecueUpdate("usp_ChangeUserLocation", tdUserGroupIdParam); return("success"); }
public int TdmsFailedTradesSave(string idList, int tdxfailurereason, string resolveddate, string comment, string userName) { var count = 0; var parameters = new[] { new SqlParameter("@tdtradeList", idList), new SqlParameter("@enteredby", userName), new SqlParameter("@tdxfailurereason", tdxfailurereason), new SqlParameter("@resolveddate", resolveddate), new SqlParameter("@comment", comment) }; var repo = new GenericRepository <EmptyUpdateModel>(_context); count = repo.ExecueUpdate("usp_UpdateFailedTrades", parameters); return(count); }