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