public string DeletePic(string conn, UpdateUserPics userPics) { string msg = string.Empty; SqlHelper sqlHelper = new SqlHelper(conn); var para = new DynamicParameters(); var outPut = new DynamicParameters(); try { para.Add("@PicID", userPics.PicId); } catch (Exception exp) { msg = "Error :" + exp.Message; } try { var result = sqlHelper.ExecuteSpReturnMessage("DeleteUserPic", para, null, true, null); msg = "Successfully Update Profile Pic."; } catch (Exception exp) { msg = "Error :" + exp.Message; } //int valueout = para.Get<int>("@outresult"); return(msg); }
public string UpdateProfilePic(UpdateUserPics userPics) { var data = userPics; string con = ConfigurationManager.ConnectionStrings["SqlServerConnString"].ConnectionString; Crud_UserProfile repository = new Crud_UserProfile(); return(repository.UpdateProfilePic(con, data)); //InsertUserProfilePics }