public Info delete(Reviewer rev) { Info retVal = new Info(FinTrackRes.REV_DELETE_ERR, false); SqlCommand cmd = null; try { using (con = new SqlConnection(conStr)) { con.Open(); using (cmd = new SqlCommand(StaticData.DELETE_REVIEWER, con)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@reviewerid", rev.ReviewerId); cmd.ExecuteNonQuery(); } } retVal._success = true; retVal._message = FinTrackRes.REV_DELETE; } catch (Exception ex) { Logger.Log(Logger.LogType.Error, ex.ToString()); } return(retVal); }
public Info save(Reviewer rev) { Info retVal = new Info(FinTrackRes.REV_SAVE_ERR, false); SqlCommand cmd = null; try { using (con = new SqlConnection(conStr)) { con.Open(); using (cmd = new SqlCommand(StaticData.CREATE_REVIEWER, con)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@revieweeid", rev.RevieweeId); //Reviweeid's might come as an array of values. cmd.Parameters.AddWithValue("@reviwerid", rev.ReviewerId); cmd.Parameters.AddWithValue("@isprimary", rev.IsPrimary); cmd.ExecuteNonQuery(); } } retVal._success = true; retVal._message = FinTrackRes.REV_SAVE; } catch (Exception ex) { Logger.Log(Logger.LogType.Error, ex.ToString()); } return(retVal); }