private void SaveOverride(int boid)
{
BoxofficeOvrr bo = new BoxofficeOvrr();
bo.bo_override = "Y";
// Subscription
bo.bo_sub_ff =objcf.ToDecimal(lblSubscriptionfacilityfee.Text);
bo.bo_sub_tax1 =objcf.ToDecimal(lblSubscriptionAmusementtax.Text);
bo.bo_sub_net_comm =objcf.ToDecimal(lblSubsSalesNetcommission.Text);
bo.bo_sub_tax_ff_comm =objcf.ToDecimal(lblSubsTaxfacltycomsn.Text);
// Phone
bo.bo_ph_ff =objcf.ToDecimal(lblPhoneFacilityfee.Text);
bo.bo_ph_tax1 =objcf.ToDecimal(lblPhoneAmusementtax.Text);
bo.bo_ph_net_comm =objcf.ToDecimal(lblPhoneNetCommsn.Text);
bo.bo_ph_tax_ff_comm =objcf.ToDecimal(lblTaxfacltyfeecmssn.Text);
// Internet
bo.bo_web_ff =objcf.ToDecimal(lblInternetFacltyFee.Text);
bo.bo_web_tax1 =objcf.ToDecimal(lblInternetAmusemntTax.Text);
bo.bo_web_net_comm =objcf.ToDecimal(lblInternetNetCommsn.Text);
bo.bo_web_tax_ff_comm=objcf.ToDecimal(lblInternetFacltyfeecmssn.Text);
// Credit Card
bo.bo_cc_ff =objcf.ToDecimal(lblCreditfacilityfee.Text);
bo.bo_cc_tax1 =objcf.ToDecimal(lblCreditAmusementtax.Text);
bo.bo_cc_net_comm =objcf.ToDecimal(lblCreditNetCommsn.Text);
bo.bo_cc_tax_ff_comm=objcf.ToDecimal(lblCreditTaxFacltyfeecmssn.Text);
// Remote/Outlet
bo.bo_outlet_ff =objcf.ToDecimal(lblRemotefacilityfee.Text);
bo.bo_outlet_tax1 =objcf.ToDecimal(lblRemoteAmusementtax.Text);
bo.bo_outlet_net_comm =objcf.ToDecimal(lblRemoteNetCommsn.Text);
bo.bo_outlet_tax_ff_comm=objcf.ToDecimal(lblRemoteTaxFacltyfeecmssn.Text);
// Single Ticket
bo.bo_single_tix_ff =objcf.ToDecimal(lblSingletixfacilityfee.Text);
bo.bo_single_tix_tax1 =objcf.ToDecimal(lblSingletixAmusementtax.Text);
bo.bo_single_tix_net_comm =objcf.ToDecimal(lblSingletixNetCommsn.Text);
bo.bo_single_tax_ff_comm=objcf.ToDecimal( lblSingletixtaxfacltyfeecmssn.Text);
// Group 1
bo.bo_small_group_ff =objcf.ToDecimal(lblGroupsfacilityfee.Text);
bo.bo_small_group_tax1 =objcf.ToDecimal(lblGroupAmusementtax.Text);
bo.bo_small_group_net_comm =objcf.ToDecimal(lblNetCommsn.Text);
bo.bo_small_tax_ff_comm = objcf.ToDecimal(lblGroupfeecmssn.Text);
// Group 2
bo.bo_large_group_ff =objcf.ToDecimal(lblGroup1facilityfee.Text);
bo.bo_large_group_tax1 =objcf.ToDecimal(lblGroup1Amusementtax.Text);
bo.bo_large_group_net_comm=objcf.ToDecimal(lblGroup1NetCommsn.Text);
bo.bo_large_tax_ff_comm=objcf.ToDecimal(lblGroup1facltyfeecmssn.Text);
// bo.bo_large_tax_ff_tot_comm=objcf.ToDecimal(
bo.bo_other_per_ff=objcf.ToDecimal(lblOtherPercfacilityfee.Text);
bo.bo_other_per_tax1 =objcf.ToDecimal(lblOtherPercAmusementtax.Text);
bo.bo_other_per_net_comm=objcf.ToDecimal(lblOtherPercNetCommsn.Text);
bo.bo_other_usd_ff=objcf.ToDecimal(lblOtherDollfacilityfee.Text);
bo.bo_other_usd_tax1=objcf.ToDecimal(lblOtherDollAmusementtax.Text);
bo.bo_other_usd_net_comm=objcf.ToDecimal(lblOOtherDollNetCommsn.Text);
bo.bo_other3_t_sold =(txtOther3TcktSold.Text != "") ? Convert.ToInt32(txtOther3TcktSold.Text) : 0;
bo.bo_other3_gross_rcpt = (txtOther3GrossReceipts.Text != "") ? objcf.ToDecimal(txtOther3GrossReceipts.Text) : 0;
bo.bo_other3_ff = (lblOther3facilityfee.Text!= "") ? objcf.ToDecimal(lblOther3facilityfee.Text) : 0;
bo.bo_other3_tax1 = (lblOther3Amusementtax.Text != "") ? objcf.ToDecimal(lblOther3Amusementtax.Text) : 0;
bo.bo_other3_net_comm = (lblOOther3NetCommsn.Text != "") ? objcf.ToDecimal(lblOOther3NetCommsn.Text) : 0;
bo.bo_other4_t_sold = (txtOther4TcktSold.Text != "") ? Convert.ToInt32(txtOther4TcktSold.Text) : 0;
bo.bo_other4_gross_rcpt = (txtOther4GrossReceipts.Text != "") ? objcf.ToDecimal(txtOther4GrossReceipts.Text) : 0;
bo.bo_other4_ff = (lblOther4facilityfee.Text != "") ? objcf.ToDecimal(lblOther4facilityfee.Text) :0 ;
bo.bo_other4_tax1 = (lblOther4Amusementtax.Text != "") ? objcf.ToDecimal(lblOther4Amusementtax.Text) :0;
bo.bo_other4_net_comm = (lblOOther4NetCommsn.Text != "") ? objcf.ToDecimal(lblOOther4NetCommsn.Text) : 0;
bo.bo_other5_t_sold = (txtOther5TcktSold.Text !="") ? Convert.ToInt32(txtOther5TcktSold.Text) : 0;
bo.bo_other5_gross_rcpt = (txtOther5GrossReceipts.Text != "") ? objcf.ToDecimal(txtOther5GrossReceipts.Text) : 0;
bo.bo_other5_ff = (lblOther5facilityfee.Text != "") ? objcf.ToDecimal(lblOther5facilityfee.Text) : 0;
bo.bo_other5_tax1 = (lblOther5Amusementtax.Text != "" ) ? objcf.ToDecimal(lblOther5Amusementtax.Text) : 0;
bo.bo_other5_net_comm = (lblOOther5NetCommsn.Text != "") ? objcf.ToDecimal(lblOOther5NetCommsn.Text) : 0;
ofcobj.BoxOfficeOverrde_Insert(boid, bo);
}
public BoxofficeOvrr Getboxofcoverridedat(int boid)
{
BoxofficeOvrr bo = new BoxofficeOvrr();
CommonFun objcf = new CommonFun();
SqlCommand cmd = new SqlCommand("sp_getBoxOfficeOverride", dbconn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@ID", boid);
DataTable dt = new DataTable();
try
{
dbconn.Open();
SqlDataReader dr = cmd.ExecuteReader();
dt.Load(dr);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0 ; i< dt.Rows.Count ;i++)
{
bo.bo_override = (Convert.ToString(dt.Rows[i]["bo_override"]));
bo.bo_sub_ff = objcf.ToDecimal(Convert.ToString(dt.Rows[i][1]));
bo.bo_sub_tax1 = objcf.ToDecimal(Convert.ToString(dt.Rows[i][2]));
bo.bo_sub_net_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i][3]));
bo.bo_sub_tax_ff_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i][4]));
bo.bo_ph_ff = objcf.ToDecimal(Convert.ToString(dt.Rows[i][5]));
bo.bo_ph_tax1 = objcf.ToDecimal(Convert.ToString(dt.Rows[i][6]));
bo.bo_ph_net_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i][7]));
bo.bo_ph_tax_ff_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i][8]));
bo.bo_web_ff = objcf.ToDecimal(Convert.ToString(dt.Rows[i][9]));
bo.bo_web_tax1 = objcf.ToDecimal(Convert.ToString(dt.Rows[i][10]));
bo.bo_web_net_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i][11]));
bo.bo_web_tax_ff_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i][12]));
bo.bo_cc_ff = objcf.ToDecimal(Convert.ToString(dt.Rows[i][13]));
bo.bo_cc_tax1 = objcf.ToDecimal(Convert.ToString(dt.Rows[i][14]));
bo.bo_cc_net_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i][15]));
bo.bo_cc_tax_ff_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i][16]));
bo.bo_outlet_ff = objcf.ToDecimal(Convert.ToString(dt.Rows[i][17]));
bo.bo_outlet_tax1 = objcf.ToDecimal(Convert.ToString(dt.Rows[i][18]));
bo.bo_outlet_net_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i][19]));
bo.bo_outlet_tax_ff_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i][20]));
bo.bo_single_tix_ff = objcf.ToDecimal(Convert.ToString(dt.Rows[i][21]));
bo.bo_single_tix_tax1 = objcf.ToDecimal(Convert.ToString(dt.Rows[i][22]));
bo.bo_single_tix_net_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i][23]));
bo.bo_single_tax_ff_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i][24]));
bo.bo_small_group_ff = objcf.ToDecimal(Convert.ToString(dt.Rows[i][25]));
bo.bo_small_group_tax1 = objcf.ToDecimal(Convert.ToString(dt.Rows[i][26]));
bo.bo_small_group_net_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i][27]));
bo.bo_small_tax_ff_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i][28]));
bo.bo_large_group_ff = objcf.ToDecimal(Convert.ToString(dt.Rows[i][29]));
bo.bo_large_group_tax1 = objcf.ToDecimal(Convert.ToString(dt.Rows[i][30]));
bo.bo_large_group_net_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i][31]));
bo.bo_large_tax_ff_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i][32]));
bo.bo_other_per_ff = objcf.ToDecimal(Convert.ToString(dt.Rows[i]["bo_other_per_ff"]));
bo.bo_other_per_tax1 = objcf.ToDecimal(Convert.ToString(dt.Rows[i]["bo_other_per_tax1"]));
bo.bo_other_per_net_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i]["bo_other_per_net_comm"]));
bo.bo_other_usd_ff = objcf.ToDecimal(Convert.ToString(dt.Rows[i]["bo_other_usd_ff"]));
bo.bo_other_usd_tax1 = objcf.ToDecimal(Convert.ToString(dt.Rows[i]["bo_other_usd_tax1"]));
bo.bo_other_usd_net_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i]["bo_other_usd_net_comm"]));
bo.bo_other3_t_sold = Convert.ToInt16(dt.Rows[i]["bo_other3_t_sold"]);
bo.bo_other3_gross_rcpt = objcf.ToDecimal(Convert.ToString(dt.Rows[i]["bo_other3_gross_rcpt"]));
bo.bo_other3_ff = objcf.ToDecimal(Convert.ToString(dt.Rows[i]["bo_other3_ff"]));
bo.bo_other3_tax1 = objcf.ToDecimal(Convert.ToString(dt.Rows[i]["bo_other3_tax1"]));
bo.bo_other3_net_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i]["bo_other3_net_comm"]));
bo.bo_other4_t_sold = Convert.ToInt16(dt.Rows[i]["bo_other4_t_sold"]);
bo.bo_other4_gross_rcpt = objcf.ToDecimal(Convert.ToString(dt.Rows[i]["bo_other4_gross_rcpt"]));
bo.bo_other4_ff = objcf.ToDecimal(Convert.ToString(dt.Rows[i]["bo_other4_ff"]));
bo.bo_other4_tax1 = objcf.ToDecimal(Convert.ToString(dt.Rows[i]["bo_other4_tax1"]));
bo.bo_other4_net_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i]["bo_other4_net_comm"]));
bo.bo_other5_t_sold = Convert.ToInt16(dt.Rows[i]["bo_other5_t_sold"]);
bo.bo_other5_gross_rcpt = objcf.ToDecimal(Convert.ToString(dt.Rows[i]["bo_other5_gross_rcpt"]));
bo.bo_other5_ff = objcf.ToDecimal(Convert.ToString(dt.Rows[i]["bo_other5_ff"]));
bo.bo_other5_tax1 = objcf.ToDecimal(Convert.ToString(dt.Rows[i]["bo_other5_tax1"]));
bo.bo_other5_net_comm = objcf.ToDecimal(Convert.ToString(dt.Rows[i]["bo_other5_net_comm"]));
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dbconn.State == ConnectionState.Open) { dbconn.Close(); }
}
return bo;
}
private void rewriteOverrideValues(int boid)
{
BoxofficeOvrr bo = new BoxofficeOvrr ();
bo = ofcobj.Getboxofcoverridedat(boid);
if (bo.bo_override == "Y")
{
chkboxOverride.Checked = true;
isCheckOverride(false);
hdn_checkoverride.Value = "y";
lblSubscriptionfacilityfee.Text = Convert.ToString(bo.bo_sub_ff);
lblSubscriptionAmusementtax.Text = Convert.ToString(bo.bo_sub_tax1);
lblSubsSalesNetcommission.Text = Convert.ToString(bo.bo_sub_net_comm);
lblSubsTaxfacltycomsn.Text = Convert.ToString(bo.bo_sub_tax_ff_comm);
lblPhoneFacilityfee.Text = Convert.ToString(bo.bo_ph_ff);
lblPhoneAmusementtax.Text = Convert.ToString(bo.bo_ph_tax1);
lblPhoneNetCommsn.Text = Convert.ToString(bo.bo_ph_net_comm);
lblTaxfacltyfeecmssn.Text = Convert.ToString(bo.bo_ph_tax_ff_comm);
lblInternetFacltyFee.Text = Convert.ToString(bo.bo_web_ff);
lblInternetAmusemntTax.Text = Convert.ToString(bo.bo_web_tax1);
lblInternetNetCommsn.Text = Convert.ToString(bo.bo_web_net_comm);
lblInternetFacltyfeecmssn.Text = Convert.ToString(bo.bo_web_tax_ff_comm);
lblCreditfacilityfee.Text = Convert.ToString(bo.bo_cc_ff);
lblCreditAmusementtax.Text = Convert.ToString(bo.bo_cc_tax1);
lblCreditNetCommsn.Text = Convert.ToString(bo.bo_cc_net_comm);
lblCreditTaxFacltyfeecmssn.Text = Convert.ToString(bo.bo_cc_tax_ff_comm);
lblRemotefacilityfee.Text = Convert.ToString(bo.bo_outlet_ff);
lblRemoteAmusementtax.Text = Convert.ToString(bo.bo_outlet_tax1);
lblRemoteNetCommsn.Text = Convert.ToString(bo.bo_outlet_net_comm);
lblRemoteTaxFacltyfeecmssn.Text = Convert.ToString(bo.bo_outlet_tax_ff_comm);
lblSingletixfacilityfee.Text = Convert.ToString(bo.bo_single_tix_ff);
lblSingletixAmusementtax.Text = Convert.ToString(bo.bo_single_tix_tax1);
lblSingletixNetCommsn.Text = Convert.ToString(bo.bo_single_tix_net_comm);
lblSingletixtaxfacltyfeecmssn.Text = Convert.ToString(bo.bo_single_tax_ff_comm);
lblGroupsfacilityfee.Text = Convert.ToString(bo.bo_small_group_ff);
lblGroupAmusementtax.Text = Convert.ToString(bo.bo_small_group_tax1);
lblNetCommsn.Text = Convert.ToString(bo.bo_small_group_net_comm);
lblGroupfeecmssn.Text = Convert.ToString(bo.bo_small_tax_ff_comm);
lblGroup1facilityfee.Text = Convert.ToString(bo.bo_large_group_ff);
lblGroup1Amusementtax.Text = Convert.ToString(bo.bo_large_group_tax1);
lblGroup1NetCommsn.Text = Convert.ToString(bo.bo_large_group_net_comm);
lblGroup1facltyfeecmssn.Text = Convert.ToString(bo.bo_large_tax_ff_comm);
}
lblOtherPercfacilityfee.Text = Convert.ToString(bo.bo_other_per_ff);
lblOtherPercAmusementtax.Text = Convert.ToString(bo.bo_other_per_tax1);
lblOtherPercNetCommsn.Text = Convert.ToString(bo.bo_other_per_net_comm);
lblOtherDollfacilityfee.Text = Convert.ToString(bo.bo_other_usd_ff);
lblOtherDollAmusementtax.Text = Convert.ToString(bo.bo_other_usd_tax1);
lblOOtherDollNetCommsn.Text = Convert.ToString(bo.bo_other_usd_net_comm);
txtOther3TcktSold.Text = Convert.ToString(bo.bo_other3_t_sold);
txtOther3GrossReceipts.Text = Convert.ToString(bo.bo_other3_gross_rcpt);
lblOther3facilityfee.Text = Convert.ToString(bo.bo_other3_ff);
lblOther3Amusementtax.Text = Convert.ToString(bo.bo_other3_tax1);
lblOOther3NetCommsn.Text = Convert.ToString(bo.bo_other3_net_comm);
txtOther4TcktSold.Text = Convert.ToString(bo.bo_other4_t_sold);
txtOther4GrossReceipts.Text = Convert.ToString(bo.bo_other4_gross_rcpt);
lblOther4facilityfee.Text = Convert.ToString(bo.bo_other4_ff);
lblOther4Amusementtax.Text = Convert.ToString(bo.bo_other4_tax1);
lblOOther4NetCommsn.Text = Convert.ToString(bo.bo_other4_net_comm);
txtOther5TcktSold.Text = Convert.ToString(bo.bo_other5_t_sold);
txtOther5GrossReceipts.Text = Convert.ToString(bo.bo_other5_gross_rcpt);
lblOther5facilityfee.Text = Convert.ToString(bo.bo_other5_ff);
lblOther5Amusementtax.Text = Convert.ToString(bo.bo_other5_tax1);
lblOOther5NetCommsn.Text = Convert.ToString(bo.bo_other5_net_comm);
}
public void BoxOfficeOverrde_Insert(int boiid,BoxofficeOvrr bo)
{
SqlCommand cmd = new SqlCommand("spBoxOfficeOveride", dbconn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@bo_Id", boiid);
cmd.Parameters.AddWithValue("@bo_override", bo.bo_override);
cmd.Parameters.AddWithValue( "@bo_sub_ff" ,bo.bo_sub_ff );
cmd.Parameters.AddWithValue( "@bo_sub_tax1" ,bo.bo_sub_tax1 );
cmd.Parameters.AddWithValue( "@bo_sub_net_comm" ,bo.bo_sub_net_comm );
cmd.Parameters.AddWithValue( "@bo_sub_tax_ff_comm" ,bo.bo_sub_tax_ff_comm );
cmd.Parameters.AddWithValue( "@bo_ph_ff" ,bo.bo_ph_ff);
cmd.Parameters.AddWithValue( "@bo_ph_tax1" ,bo.bo_ph_tax1 );
cmd.Parameters.AddWithValue( "@bo_ph_net_comm" ,bo.bo_ph_net_comm );
cmd.Parameters.AddWithValue( "@bo_ph_tax_ff_comm" ,bo.bo_ph_tax_ff_comm );
cmd.Parameters.AddWithValue( "@bo_web_ff" ,bo.bo_web_ff);
cmd.Parameters.AddWithValue( "@bo_web_tax1" ,bo.bo_web_tax1 );
cmd.Parameters.AddWithValue( "@bo_web_net_comm" ,bo.bo_web_net_comm );
cmd.Parameters.AddWithValue( "@bo_web_tax_ff_comm" ,bo.bo_web_tax_ff_comm);
cmd.Parameters.AddWithValue( "@bo_cc_ff" ,bo.bo_cc_ff );
cmd.Parameters.AddWithValue( "@bo_cc_tax1" ,bo.bo_cc_tax1 );
cmd.Parameters.AddWithValue( "@bo_cc_net_comm" ,bo.bo_cc_net_comm );
cmd.Parameters.AddWithValue( "@bo_cc_tax_ff_comm" ,bo.bo_cc_tax_ff_comm);
cmd.Parameters.AddWithValue( "@bo_outlet_ff" ,bo.bo_outlet_ff );
cmd.Parameters.AddWithValue( "@bo_outlet_tax1" ,bo.bo_outlet_tax1 );
cmd.Parameters.AddWithValue( "@bo_outlet_net_comm" ,bo.bo_outlet_net_comm );
cmd.Parameters.AddWithValue( "@bo_outlet_tax_ff_comm" ,bo.bo_outlet_tax_ff_comm);
cmd.Parameters.AddWithValue( "@bo_single_tix_ff" ,bo.bo_single_tix_ff);
cmd.Parameters.AddWithValue( "@bo_single_tix_tax1" ,bo.bo_single_tix_tax1 );
cmd.Parameters.AddWithValue( "@bo_single_tix_net_comm" ,bo.bo_single_tix_net_comm );
cmd.Parameters.AddWithValue( "@bo_single_tax_ff_comm" ,bo.bo_single_tax_ff_comm);
cmd.Parameters.AddWithValue( "@bo_small_group_ff" ,bo.bo_small_group_ff );
cmd.Parameters.AddWithValue( "@bo_small_group_tax1" ,bo.bo_small_group_tax1 );
cmd.Parameters.AddWithValue( "@bo_small_group_net_comm" ,bo.bo_small_group_net_comm );
cmd.Parameters.AddWithValue( "@bo_small_tax_ff_comm" ,bo.bo_small_tax_ff_comm);
cmd.Parameters.AddWithValue( "@bo_large_group_ff" ,bo.bo_large_group_ff );
cmd.Parameters.AddWithValue( "@bo_large_group_tax1" ,bo.bo_large_group_tax1 );
cmd.Parameters.AddWithValue( "@bo_large_group_net_comm" ,bo.bo_large_group_net_comm);
cmd.Parameters.AddWithValue( "@bo_large_tax_ff_comm" ,bo.bo_large_tax_ff_comm);
cmd.Parameters.AddWithValue( "@bo_large_tax_ff_tot_comm" ,bo.bo_large_tax_ff_tot_comm);
cmd.Parameters.AddWithValue( "@bo_other_per_ff" ,bo.bo_other_per_ff);
cmd.Parameters.AddWithValue( "@bo_other_per_tax1" ,bo.bo_other_per_tax1 );
cmd.Parameters.AddWithValue( "@bo_other_per_net_comm" ,bo.bo_other_per_net_comm);
cmd.Parameters.AddWithValue( "@bo_other_usd_ff" ,bo.bo_other_usd_ff);
cmd.Parameters.AddWithValue( "@bo_other_usd_tax1" ,bo.bo_other_usd_tax1);
cmd.Parameters.AddWithValue( "@bo_other_usd_net_comm" ,bo.bo_other_usd_net_comm);
cmd.Parameters.AddWithValue( "@bo_other3_t_sold" ,bo.bo_other3_t_sold);
cmd.Parameters.AddWithValue( "@bo_other3_gross_rcpt" ,bo.bo_other3_gross_rcpt );
cmd.Parameters.AddWithValue( "@bo_other3_ff" ,bo.bo_other3_ff);
cmd.Parameters.AddWithValue( "@bo_other3_tax1" ,bo.bo_other3_tax1);
cmd.Parameters.AddWithValue( "@bo_other3_net_comm" ,bo.bo_other3_net_comm);
cmd.Parameters.AddWithValue( "@bo_other4_t_sold" ,bo.bo_other4_t_sold);
cmd.Parameters.AddWithValue( "@bo_other4_gross_rcpt" ,bo.bo_other4_gross_rcpt);
cmd.Parameters.AddWithValue( "@bo_other4_ff" ,bo.bo_other4_ff);
cmd.Parameters.AddWithValue( "@bo_other4_tax1" ,bo.bo_other4_tax1);
cmd.Parameters.AddWithValue( "@bo_other4_net_comm" ,bo.bo_other4_net_comm);
cmd.Parameters.AddWithValue( "@bo_other5_t_sold" ,bo.bo_other5_t_sold);
cmd.Parameters.AddWithValue( "@bo_other5_gross_rcpt" ,bo.bo_other5_gross_rcpt);
cmd.Parameters.AddWithValue( "@bo_other5_ff" ,bo.bo_other5_ff);
cmd.Parameters.AddWithValue( "@bo_other5_tax1" ,bo.bo_other5_tax1);
cmd.Parameters.AddWithValue( "@bo_other5_net_comm" ,bo.bo_other5_net_comm);
try
{
if (dbconn.State == ConnectionState.Closed)
{
dbconn.Open();
}
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dbconn.State == ConnectionState.Open)
{
dbconn.Close();
}
}
}