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