public static int SavePACAgreement(PACAgreement pacAgreement)
{
const string METHOD_NAME = "SavePACAgreement";
int pacId = 0;
try {
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) {
string procName = "pacAgreement_Save";
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
System.Data.SqlClient.SqlParameter[] spParams = SqlHelperParameterCache.GetSpParameterSet(conn, procName, false);
spParams[1].Value = pacAgreement.SHID;
spParams[2].Value = pacAgreement.Contribution;
spParams[3].Value = pacAgreement.PACDate;
spParams[4].Value = pacAgreement.PACCropYear;
spParams[5].Value = pacAgreement.IndividualsString;
using (SqlTransaction tran = conn.BeginTransaction()) {
try {
SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, procName, spParams);
tran.Commit();
pacId = Convert.ToInt16(spParams[0].Value);
} catch (SqlException sqlEx) {
if (tran != null)
{
tran.Rollback();
}
if (sqlEx.Number == Convert.ToInt32(WSCIEMP.Common.CException.KnownError.DataWarning))
{
WSCIEMP.Common.CWarning wscWarn = new WSCIEMP.Common.CWarning(sqlEx.Message, sqlEx);
throw (wscWarn);
}
else
{
string errMsg = MOD_NAME;
WSCIEMP.Common.CException wscEx = new WSCIEMP.Common.CException(errMsg, sqlEx);
throw (wscEx);
}
}
}
}
}
catch (System.Exception e)
{
string errMsg = MOD_NAME + METHOD_NAME;
WSCIEMP.Common.CException wscEx = new WSCIEMP.Common.CException(errMsg, e);
throw (wscEx);
}
return(pacId);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (this.MySHID != null && this.MySHID.Length > 0)
{
UpdateIndTable();
if (pACDate.Text == null || pACDate.Text.Length == 0)
pACDate.Text = DateTime.Now.ToString("MM/dd/yyyy");
if (pACContibution.Text == null || pACContibution.Text.Length == 0)
pACContibution.Text = "0";
if (this.IndTable != null && this.MySHID != null && this.MySHID.Length > 0)
{
PACAgreement pacAgreement = new PACAgreement(this.MySHID, Convert.ToDouble(pACContibution.Text), pACDate.Text, Convert.ToInt16(ddlCropYear.Text), this.IndTable);
PACData.SavePACAgreement(pacAgreement);
}
btnResolveShid_Click(sender, e);
pacMessages.InnerText = "PAC Agreement Saved";
btnDownloadPACAgreement.Enabled = true;
}
}
public static PACAgreement GetPACAgreement(string shid, int crop_year)
{
const string METHOD_NAME = "GetPACAgreement";
PACAgreement pacAgreement = null;
try {
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) {
string procName = "pacAgreement_Get";
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
System.Data.SqlClient.SqlParameter[] spParams = SqlHelperParameterCache.GetSpParameterSet(conn, procName, false);
spParams[0].Value = shid;
spParams[1].Value = crop_year;
try {
using (SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, procName, spParams)) {
int iShid = dr.GetOrdinal("shid");
int iPacContribution = dr.GetOrdinal("pacContribution");
int iPacDate = dr.GetOrdinal("pacDate");
int iPacCropYear = dr.GetOrdinal("crop_year");
int iPacIndividuals = dr.GetOrdinal("pacIndividuals");
while (dr.Read())
{
if (!dr.IsDBNull(iShid))
{
string pacIndividuals = "";
string pacDate = "";
double pacContribution = 0;
int pacCropYear = 0;
if (!dr.IsDBNull(iPacIndividuals))
{
pacIndividuals = dr.GetString(iPacIndividuals);
}
if (!dr.IsDBNull(iPacDate))
{
pacDate = dr.GetDateTime(iPacDate).ToString("MM/dd/yyyy");
}
if (!dr.IsDBNull(iPacContribution))
{
pacContribution = Convert.ToDouble(dr.GetDecimal(iPacContribution));
}
pacCropYear = dr.GetInt32(iPacCropYear);
pacAgreement = new PACAgreement(shid, pacContribution, pacDate, pacCropYear, pacIndividuals);
}
}
}
}
catch (SqlException sqlEx)
{
if (sqlEx.Number == Convert.ToInt32(WSCIEMP.Common.CException.KnownError.DataWarning))
{
WSCIEMP.Common.CWarning wscWarn = new WSCIEMP.Common.CWarning(sqlEx.Message, sqlEx);
throw (wscWarn);
}
else
{
string errMsg = MOD_NAME + METHOD_NAME;
WSCIEMP.Common.CException wscEx = new WSCIEMP.Common.CException(errMsg, sqlEx);
throw (wscEx);
}
}
}
}
catch (System.Exception e)
{
string errMsg = MOD_NAME + METHOD_NAME;
WSCIEMP.Common.CException wscEx = new WSCIEMP.Common.CException(errMsg, e);
throw (wscEx);
}
return(pacAgreement);
}
