public static void Insert_PresScreen_test(PreScreenH value, out int ProspectID)
{
SqlParameter pOut = new SqlParameter("@ProspectID", SqlDbType.Int, 4);
pOut.Direction = ParameterDirection.Output;
//--P, O, C
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@valueID", value.ValueID),
new SqlParameter("@ValueType", value.ValueType),
new SqlParameter("@TransDate", value.TransDate),
new SqlParameter("@TransResult", value.TransResult),
new SqlParameter("@TranScore", value.TransScore),
new SqlParameter("@UserName", value.UserName)
,pOut
};
//I am pointing to the practice database
//prospectId = (int)SqlHelper.ExecuteScalar(Helper.ConnectionString, CommandType.StoredProcedure, "usp_Insert_tbl_PreScreenHistory", param);
SqlHelper.ExecuteScalar(Helper.ConnectionStringThird, CommandType.StoredProcedure, "usp_Insert_tbl_PreScreenHistory_test", param);
ProspectID = Helper.ToInt32(pOut.Value);
}
//Step [4]
//tbl_PreScreenHistory
void SaveResults_TUNA_test()
{
if (ProspectId > 0)
{
PreScreenH item = new PreScreenH();
item.ValueID = ProspectId; //Prospect### or Owner###
item.ValueType = "P";
item.TransDate = DateTime.Now;
item.TransResult = hdnResultTUNA.Value.Trim();
item.TransScore = hdn_SC_ValueTUNA.Value.Trim();
item.UserName = varSystemUser.Trim();
//itemPersonnel.TitleID = Helper.ToInt32(TitleID);
//step 4. Assign Personnel
//Response.Write(itemPersonnel.TourID+ 1+ 1+1);
int ProspectID = 0;
PreScreenHDB.Insert_PresScreen_test(item, out ProspectID);
//PreScreenHDB.Insert_PresScreen(item);
this.hdnNewAddition_TUNA.Value = ProspectID.ToString();
}
}
//Step [4]
//tbl_PreScreenHistory
void SaveResults()
{
if (lblValueID.Text != "") { }
PreScreenH item = new PreScreenH();
item.ValueID = Helper.ToInt32(lblValueID.Text); //Prospect### or Owner###
item.ValueType = lblValueType.Text.Trim();
item.TransDate = Helper.ToDateTime(lblTransDate.Text);
item.TransResult = lblResult.Text.Trim();
item.TransScore = lblScore.Text.Trim();
item.UserName = lblUserName.Text;
//itemPersonnel.TitleID = Helper.ToInt32(TitleID);
//step 4. Assign Personnel
//Response.Write(itemPersonnel.TourID+ 1+ 1+1);
int ProspectID = 0;
PreScreenHDB.Insert_PresScreen_test(item, out ProspectID);
//PreScreenHDB.Insert_PresScreen(item);
lblNewAddition.Text = ProspectID.ToString();
}
