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