private void InsertHistory(int type) { if (type == 1) { Schedule sch = new Schedule(); sch.Show = txt_showsearch.Text.Trim().ToString();; sch.SettlementDate = txtcreatedatesearch.Text.Trim().ToString();; sch.Presenter = txt_presentersearch.Text.Trim().ToString();; sch.Status = txt_status.Text.Trim().ToString();; sch.Venue = txt_venuesearch.Text.Trim().ToString();; sch.City = txt_metrosearch.Text.Trim().ToString();; objmst.SearchHistoryUpdate(userid, sch,null,null,null,null, type); } else if (type == 2) { PriceScaleDetail psc = new PriceScaleDetail(); psc.Seats = txtbxSeatFrom.Text.Trim().ToString();; psc.Single = txtbxSinglefrom.Text.Trim().ToString();; psc.Group = txttbxgroupfrom.Text.Trim().ToString();; psc.Subscription = txtbxsubscriptionfrom.Text.Trim().ToString();; objmst.SearchHistoryUpdate(userid, null, psc,null,null,null, type); } else if (type == 3) { BoxOfficeDetail bd = new BoxOfficeDetail(); bd.GroupSales=txtbxgrpSalesfrm.Text.Trim().ToString(); bd.DropCount = txtbxdrpcountfrom.Text.Trim().ToString(); bd.PaidAttendance = txtbxPAfrom.Text.Trim().ToString(); bd.Comp = txtbxCompFrom.Text.Trim().ToString(); bd.TSSubscription = txtbxtsSubFrom.Text.Trim().ToString(); bd.GRSubscription = txtbxgrSubFrom.Text.Trim().ToString(); bd.TSPhone = txtbxtsPhoFrom.Text.Trim().ToString(); bd.GRPhone=txtbxgrPhoFrom.Text.Trim().ToString(); bd.TSInternet=txtbxtsIntFrom.Text.Trim().ToString(); bd.GRInternet=txtbxgrIntFrom.Text.Trim().ToString(); bd.TSCreditCard=txtbxtsCreFrom.Text.Trim().ToString(); bd.GRCreditCard=txtbxgrCreFrom.Text.Trim().ToString(); bd.TSRemoteOutlet=txtbxtsRemFrom.Text.Trim().ToString(); bd.GRRemoteOutlet=txtbxgrRemFrom.Text.Trim().ToString(); bd.TSSingleTickets=txtbxtsSinFrom.Text.Trim().ToString(); bd.GRSingleTickets=txtbxgrSinFrom.Text.Trim().ToString(); bd.GRGroup1=txtbxgrGrp1From.Text.Trim().ToString(); bd.GRGroup2=txtbxgrGrp2From.Text.Trim().ToString(); bd.TSGroup1 = txtbxtsGrp1From.Text.Trim().ToString(); bd.TSGroup2 = txtbxtsGrp2From.Text.Trim().ToString(); objmst.SearchHistoryUpdate(userid, null, null, bd, null,null, type); } else if (type == 4) { DealDetail dd = new DealDetail(); dd.Royalty = txt_royalty.Text.Trim().ToString(); dd.Company =txt_companymonies.Text.Trim().ToString(); dd.Tax1 =txt_tax.Text.Trim().ToString(); dd.TaxFacilityFee =txt_facilityfee.Text.Trim().ToString(); dd.Guarantee =txt_guarantee.Text.Trim().ToString(); dd.Presenter =txt_presentermonies.Text.Trim().ToString(); dd.TaxFacilityFee =txt_boxoffice.Text.Trim().ToString(); dd.Cap =txt_middlecap.Text.Trim().ToString(); dd.TaxAmountOver =txt_taxover.Text.Trim().ToString(); dd.Producer =txt_producershare.Text.Trim().ToString(); dd.Budget =txt_taxbudget.Text.Trim().ToString(); dd.Subscription =txt_subscriptionsale.Text.Trim().ToString(); dd.SingleTickets =txt_singleticket.Text.Trim().ToString(); dd.Other1 =txt_miscellaneous1.Text.Trim().ToString(); dd.Actual =txt_taxactual.Text.Trim().ToString(); dd.Phone =txt_phonecommission.Text.Trim().ToString(); dd.Group1 =txt_groupsale1.Text.Trim().ToString(); dd.Presenter =txt_presentershare2.Text.Trim().ToString(); dd.Internet =txt_internetsale.Text.Trim().ToString(); dd.Group2 =txt_groupsale3.Text.Trim().ToString(); dd.Other2 =txt_miscellaneous5.Text.Trim().ToString(); dd.CreditCard =txt_cardsale.Text.Trim().ToString(); dd.StarRoyalty =txt_starroyalty1.Text.Trim().ToString(); dd.Remote = txt_remotesale1.Text.Trim().ToString(); objmst.SearchHistoryUpdate(userid,null,null,null,dd,null,type); } else if (type == 5) { ExpenseDetails ed = new ExpenseDetails(); ed.BUDAdvertisingGross =txtadvt_bud.Text.Trim().ToString(); ed.ACTAdvertisingGross=txtadvt_act.Text.Trim().ToString(); ed.BUDADAExpense=txtadaexp_bud.Text.Trim().ToString(); ed.ACTADAExpense=txtadaexp_act.Text.Trim().ToString(); ed.BUDLaborCatering=txtlabourcatering_bud.Text.Trim().ToString(); ed.ACTLaborCatering=txtlabourcatering_act.Text.Trim().ToString(); ed.BUDBoxOffice=txtboxoff_bud.Text.Trim().ToString(); ed.ACTBoxOffice=txtboxoff_act.Text.Trim().ToString(); ed.BUDMusicians=txtmusicians_bud.Text.Trim().ToString(); ed.ACTMusicians=txtmusicians_act.Text.Trim().ToString(); ed.BUDCatering=txtcatering_bud.Text.Trim().ToString(); ed.ACTCatering=txtcatering_act.Text.Trim().ToString(); ed.BUDEquipmentRental=txteqiprental_bud.Text.Trim().ToString(); ed.ACTEquipmentRental=txteqiprental_act.Text.Trim().ToString(); ed.BUDGroupSalesExpenses=txtgrpsaleexp_bud.Text.Trim().ToString(); ed.ACTGroupSalesExpenses=txtgrpsaleexp_act.Text.Trim().ToString(); ed.BUDshLoadIn=txtstatehandin_bud.Text.Trim().ToString(); ed.ACTshLoadIn=txtstatehandin_act.Text.Trim().ToString(); ed.BUDHouseStaff=txthousestaff_bud.Text.Trim().ToString(); ed.ACTHouseStaff=txthousestaff_act.Text.Trim().ToString(); ed.BUDshLoadOut=txtstatehandout_bud.Text.Trim().ToString(); ed.ACTshLoadOut=txtstatehandout_act.Text.Trim().ToString(); ed.BUDLeagueFees=txtleaguefee_bud.Text.Trim().ToString(); ed.ACTLeagueFees=txtleaguefee_act.Text.Trim().ToString(); ed.BUDshRunning=txtstatehandsrun_bud.Text.Trim().ToString(); ed.ACTshRunning=txtstatehandsrun_act.Text.Trim().ToString(); ed.BUDLicensesPermits=txtlicpermits_bud.Text.Trim().ToString(); ed.ACTLicensesPermits=txtlicpermits_act.Text.Trim().ToString(); ed.BUDLimosAuto=txtlimosauto_bud.Text.Trim().ToString(); ed.ACTLimosAuto=txtlimosauto_act.Text.Trim().ToString(); ed.BUDOrchestraShellRemoval=txtorchestrashellrml_bud.Text.Trim().ToString(); ed.ACTOrchestraShellRemoval=txtorchestrashellrml_act.Text.Trim().ToString(); ed.BUDwrLoadIn=txtwardrobehairin_bud.Text.Trim().ToString(); ed.ACTwrLoadOut=txtwardrobehairin_act.Text.Trim().ToString(); ed.BUDPresenterProfit=txtpresenterprofit_bud.Text.Trim().ToString(); ed.ACTPresenterProfit=txtpresenterprofit_act.Text.Trim().ToString(); ed.BUDwrLoadOut=txtwardrobehairout_bud.Text.Trim().ToString(); ed.ACTwrLoadOut=txtwardrobehairout_act.Text.Trim().ToString(); ed.BUDPoliceSecurityFireMarshall=txtpol_sec_fire_mar_bud.Text.Trim().ToString(); ed.ACTPoliceSecurityFireMarshall=txtpol_sec_fire_mar_act.Text.Trim().ToString(); ed.BUDwrRunning=txtwardrobehairrun_bud.Text.Trim().ToString(); ed.ACTwrRunning=txtwardrobehairrun_act.Text.Trim().ToString(); ed.BUDProgram=txtprogram_bud.Text.Trim().ToString(); ed.ACTProgram=txtprogram_act.Text.Trim().ToString(); ed.BUDRent=txtrent_bud.Text.Trim().ToString(); ed.ACTRent=txtrent_act.Text.Trim().ToString(); //=txtinsurnace_de_unit.Text.Trim().ToString(); //=txtinsurance_bud.Text.Trim().ToString(); //=txtinsurance_act.Text.Trim().ToString(); ed.BUDSoundLights=txtsoundlignt_bud.Text.Trim().ToString(); ed.ACTSoundLights=txtsoundlignt_act.Text.Trim().ToString(); // =txtticketprint_de_unit.Text.Trim().ToString(); // =txtticketprint_de_bud.Text.Trim().ToString(); // =txtticketprint_de_act.Text.Trim().ToString(); //=txtticketprint_le_bud.Text.Trim().ToString(); //=txtticketprint_le_act.Text.Trim().ToString(); ed.BUDTelephonesInternet=txttel_internet_bud.Text.Trim().ToString(); ed.ACTTelephonesInternet=txttel_internet_act.Text.Trim().ToString(); ed.BUDDryIceC02=txtdryice_bud.Text.Trim().ToString(); ed.ACTDryIceC02=txtdryice_act.Text.Trim().ToString(); //=txtother1_de_bud.Text.Trim().ToString(); //=txtother1_de_act.Text.Trim().ToString(); //=txtother2_de_bud.Text.Trim().ToString(); //=txtother2_de_act.Text.Trim().ToString(); //=txtother1_le_bud.Text.Trim().ToString(); //=txtother1_le_act.Text.Trim().ToString(); //=txtother2_le_bud.Text.Trim().ToString(); //=txtother2_le_act.Text.Trim().ToString(); //=txtother3_le_bud.Text.Trim().ToString(); //=txtother3_le_act.Text.Trim().ToString(); //=txtother4_le_bud.Text.Trim().ToString(); //=txtother4_le_act.Text.Trim().ToString(); //=txtother5_le_bud.Text.Trim().ToString(); //=txtother5_le_act.Text.Trim().ToString(); ed.BUDLocalFixed=txtlocalfixed_bud.Text.Trim().ToString(); ed.ACTLocalFixed=txtlocalfixed_act.Text.Trim().ToString(); } else if (type == 6) { Discount d = new Discount(); d.Sub = txtbxDSubscription.Text.Trim().ToString(); d.SubTkt = txtxsubTktto.Text.Trim().ToString(); d.Group = txtbxGSubFrom.Text.Trim().ToString(); d.Grptkt = txtbxGtktFrom.Text.Trim().ToString(); d.Misc = txtbxmis.Text.Trim().ToString(); d.MiscTkt = txtbxmisTfrom.Text.Trim().ToString(); objmst.SearchHistoryUpdate(userid, null, null, null, null, d, 5); } }
public ExpenseDetails GetExpenseDetailSearchHistory(int mode, string userid) { DataTable dt = new DataTable(); ExpenseDetails ed = null; SqlCommand cmd = new SqlCommand("spGetSearchHistory", dbconn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Mode", mode); cmd.Parameters.AddWithValue("@UserID", userid); cmd.CommandType = CommandType.StoredProcedure; try { if (dbconn.State == ConnectionState.Closed) { dbconn.Open(); } SqlDataReader dr = cmd.ExecuteReader(); dt.Load(dr); if (dt != null) { if (dt.Rows.Count > 0) { ed = new ExpenseDetails(); return ed; } } return ed; } catch (Exception ex) { throw ex; } finally { if (dbconn.State == ConnectionState.Open) { dbconn.Close(); } } }
private void LoadExpenseSearch(ExpenseDetails ed) { txtadvt_bud.Text = ed.ACTAdvertisingGross; txtadvt_act.Text = ed.ACTAdvertisingGross; txtadaexp_bud.Text= ed.BUDADAExpense ; txtadaexp_act.Text=ed.ACTADAExpense; txtlabourcatering_bud.Text= ed.BUDLaborCatering; txtlabourcatering_act.Text=ed.ACTLaborCatering; txtboxoff_bud.Text= ed.BUDBoxOffice ; txtboxoff_act.Text= ed.ACTBoxOffice; txtmusicians_bud.Text=ed.BUDMusicians; txtmusicians_act.Text= ed.ACTMusicians; txtcatering_bud.Text= ed.BUDCatering; txtcatering_act.Text=ed.ACTCatering; txteqiprental_bud.Text= ed.BUDEquipmentRental; txteqiprental_act.Text= ed.ACTEquipmentRental; txtgrpsaleexp_bud.Text =ed.BUDGroupSalesExpenses; txtgrpsaleexp_act.Text=ed.ACTGroupSalesExpenses; txtstatehandin_bud.Text= ed.BUDshLoadIn ; txtstatehandin_act.Text= ed.ACTshLoadIn; txthousestaff_bud.Text= ed.BUDHouseStaff; txthousestaff_act.Text = ed.ACTHouseStaff; //ed.BUDshLoadOut = txtstatehandout_bud.Text.Trim().ToString(); //ed.ACTshLoadOut = txtstatehandout_act.Text.Trim().ToString(); //ed.BUDLeagueFees = txtleaguefee_bud.Text.Trim().ToString(); //ed.ACTLeagueFees = txtleaguefee_act.Text.Trim().ToString(); //ed.BUDshRunning = txtstatehandsrun_bud.Text.Trim().ToString(); //ed.ACTshRunning = txtstatehandsrun_act.Text.Trim().ToString(); //ed.BUDLicensesPermits = txtlicpermits_bud.Text.Trim().ToString(); //ed.ACTLicensesPermits = txtlicpermits_act.Text.Trim().ToString(); //ed.BUDLimosAuto = txtlimosauto_bud.Text.Trim().ToString(); //ed.ACTLimosAuto = txtlimosauto_act.Text.Trim().ToString(); //ed.BUDOrchestraShellRemoval = txtorchestrashellrml_bud.Text.Trim().ToString(); //ed.ACTOrchestraShellRemoval = txtorchestrashellrml_act.Text.Trim().ToString(); //ed.BUDwrLoadIn = txtwardrobehairin_bud.Text.Trim().ToString(); //ed.ACTwrLoadOut = txtwardrobehairin_act.Text.Trim().ToString(); //ed.BUDPresenterProfit = txtpresenterprofit_bud.Text.Trim().ToString(); //ed.ACTPresenterProfit = txtpresenterprofit_act.Text.Trim().ToString(); //ed.BUDwrLoadOut = txtwardrobehairout_bud.Text.Trim().ToString(); //ed.ACTwrLoadOut = txtwardrobehairout_act.Text.Trim().ToString(); //ed.BUDPoliceSecurityFireMarshall = txtpol_sec_fire_mar_bud.Text.Trim().ToString(); //ed.ACTPoliceSecurityFireMarshall = txtpol_sec_fire_mar_act.Text.Trim().ToString(); //ed.BUDwrRunning = txtwardrobehairrun_bud.Text.Trim().ToString(); //ed.ACTwrRunning = txtwardrobehairrun_act.Text.Trim().ToString(); //ed.BUDProgram = txtprogram_bud.Text.Trim().ToString(); //ed.ACTProgram = txtprogram_act.Text.Trim().ToString(); //ed.BUDRent = txtrent_bud.Text.Trim().ToString(); //ed.ACTRent = txtrent_act.Text.Trim().ToString(); ////=txtinsurnace_de_unit.Text.Trim().ToString(); ////=txtinsurance_bud.Text.Trim().ToString(); ////=txtinsurance_act.Text.Trim().ToString(); //ed.BUDSoundLights = txtsoundlignt_bud.Text.Trim().ToString(); //ed.ACTSoundLights = txtsoundlignt_act.Text.Trim().ToString(); //// =txtticketprint_de_unit.Text.Trim().ToString(); //// =txtticketprint_de_bud.Text.Trim().ToString(); //// =txtticketprint_de_act.Text.Trim().ToString(); ////=txtticketprint_le_bud.Text.Trim().ToString(); ////=txtticketprint_le_act.Text.Trim().ToString(); //ed.BUDTelephonesInternet = txttel_internet_bud.Text.Trim().ToString(); //ed.ACTTelephonesInternet = txttel_internet_act.Text.Trim().ToString(); //ed.BUDDryIceC02 = txtdryice_bud.Text.Trim().ToString(); //ed.ACTDryIceC02 = txtdryice_act.Text.Trim().ToString(); ////=txtother1_de_bud.Text.Trim().ToString(); ////=txtother1_de_act.Text.Trim().ToString(); ////=txtother2_de_bud.Text.Trim().ToString(); ////=txtother2_de_act.Text.Trim().ToString(); ////=txtother1_le_bud.Text.Trim().ToString(); ////=txtother1_le_act.Text.Trim().ToString(); ////=txtother2_le_bud.Text.Trim().ToString(); ////=txtother2_le_act.Text.Trim().ToString(); ////=txtother3_le_bud.Text.Trim().ToString(); ////=txtother3_le_act.Text.Trim().ToString(); ////=txtother4_le_bud.Text.Trim().ToString(); ////=txtother4_le_act.Text.Trim().ToString(); ////=txtother5_le_bud.Text.Trim().ToString(); ////=txtother5_le_act.Text.Trim().ToString(); //ed.BUDLocalFixed = txtlocalfixed_bud.Text.Trim().ToString(); //ed.ACTLocalFixed = txtlocalfixed_act.Text.Trim().ToString(); }
public void SearchEngagementExpenseHistoryUpdate(string userid, ExpenseDetails ed) { SqlCommand cmd = new SqlCommand("sp_GetSearchExpenseDetails", dbconn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@UserID", userid); cmd.Parameters.AddWithValue("@Arg1 ", ed.BUDAdvertisingGross); cmd.Parameters.AddWithValue("@Arg2 ", ed.BUDLaborCatering); cmd.Parameters.AddWithValue("@Arg3 ", ed.BUDMusicians); cmd.Parameters.AddWithValue("@Arg4 ", ed.BUDshLoadIn); cmd.Parameters.AddWithValue("@Arg5 ", ed.BUDshLoadOut); cmd.Parameters.AddWithValue("@Arg6 ", ed.BUDshRunning); cmd.Parameters.AddWithValue("@Arg7 ", ed.BUDwrLoadIn); cmd.Parameters.AddWithValue("@Arg8 ", ed.BUDwrLoadOut); cmd.Parameters.AddWithValue("@Arg9 ", ed.BUDwrRunning); cmd.Parameters.AddWithValue("@Arg10 ", ed.BUDInsuranceOnDropCount); cmd.Parameters.AddWithValue("@Arg11 ", ed.BUDTicketPrinting); cmd.Parameters.AddWithValue("@Arg12 ", ed.BUDDOCOther1); cmd.Parameters.AddWithValue("@Arg13 ", ed.BUDDOCOther2); cmd.Parameters.AddWithValue("@Arg14 ", ed.BUD); cmd.Parameters.AddWithValue("@Arg15 ", ed.BUDADAExpense); cmd.Parameters.AddWithValue("@Arg16 ", ed.BUDBoxOffice); cmd.Parameters.AddWithValue("@Arg17 ", ed.BUDCatering); cmd.Parameters.AddWithValue("@Arg18 ", ed.BUDEquipmentRental); cmd.Parameters.AddWithValue("@Arg19 ", ed.BUDGroupSalesExpenses); cmd.Parameters.AddWithValue("@Arg20 ", ed.BUDHouseStaff); cmd.Parameters.AddWithValue("@Arg21 ", ed.BUDLeagueFees); cmd.Parameters.AddWithValue("@Arg22 ", ed.BUDLicensesPermits); cmd.Parameters.AddWithValue("@Arg23 ", ed.BUDLimosAuto); cmd.Parameters.AddWithValue("@Arg24 ", ed.BUDOrchestraShellRemoval); cmd.Parameters.AddWithValue("@Arg25 ", ed.BUDPresenterProfit); cmd.Parameters.AddWithValue("@Arg26 ", ed.BUDPoliceSecurityFireMarshall); cmd.Parameters.AddWithValue("@Arg27 ", ed.BUDProgram); cmd.Parameters.AddWithValue("@Arg28 ", ed.BUDRent); cmd.Parameters.AddWithValue("@Arg29 ", ed.BUDSoundLights); cmd.Parameters.AddWithValue("@Arg31 ", ed.BUDTelephonesInternet); cmd.Parameters.AddWithValue("@Arg32 ", ed.BUDDryIceC02); cmd.Parameters.AddWithValue("@Arg33 ", ed.BUDLOCOther1); cmd.Parameters.AddWithValue("@Arg34 ", ed.BUDLOCOther2); cmd.Parameters.AddWithValue("@Arg35 ", ed.BUDLOCOther3); cmd.Parameters.AddWithValue("@Arg36 ", ed.BUDLOCOther4); cmd.Parameters.AddWithValue("@Arg37 ", ed.BUDLOCOther5); cmd.Parameters.AddWithValue("@Arg38 ", ed.BUDLocalFixed); cmd.Parameters.AddWithValue("@Arg39 ", ed.ACTAdvertisingGross); cmd.Parameters.AddWithValue("@Arg40 ", ed.ACTLaborCatering); cmd.Parameters.AddWithValue("@Arg41 ", ed.ACTMusicians); cmd.Parameters.AddWithValue("@Arg42 ", ed.ACTshLoadIn); cmd.Parameters.AddWithValue("@Arg43 ", ed.ACTshLoadOut); cmd.Parameters.AddWithValue("@Arg44 ", ed.ACTshRunning); cmd.Parameters.AddWithValue("@Arg45 ", ed.ACTwrLoadIn); cmd.Parameters.AddWithValue("@Arg46 ", ed.ACTwrLoadOut); cmd.Parameters.AddWithValue("@Arg47 ", ed.ACTwrRunning); cmd.Parameters.AddWithValue("@Arg48 ", ed.ACTInsuranceOnDropCount); cmd.Parameters.AddWithValue("@Arg49 ", ed.ACTTicketPrinting); cmd.Parameters.AddWithValue("@Arg50 ", ed.ACTDOCOther1); cmd.Parameters.AddWithValue("@Arg51 ", ed.ACTDOCOther2); cmd.Parameters.AddWithValue("@Arg52 ", ed.ACT); cmd.Parameters.AddWithValue("@Arg53 ", ed.ACTADAExpense); cmd.Parameters.AddWithValue("@Arg54 ", ed.ACTBoxOffice); cmd.Parameters.AddWithValue("@Arg55 ", ed.ACTCatering); cmd.Parameters.AddWithValue("@Arg56 ", ed.ACTEquipmentRental); cmd.Parameters.AddWithValue("@Arg57 ", ed.ACTGroupSalesExpenses); cmd.Parameters.AddWithValue("@Arg58 ", ed.ACTHouseStaff); cmd.Parameters.AddWithValue("@Arg59 ", ed.ACTLeagueFees); cmd.Parameters.AddWithValue("@Arg60 ", ed.ACTLicensesPermits); cmd.Parameters.AddWithValue("@Arg61 ", ed.ACTLimosAuto); cmd.Parameters.AddWithValue("@Arg62 ", ed.ACTOrchestraShellRemoval); cmd.Parameters.AddWithValue("@Arg63 ", ed.ACTPresenterProfit); cmd.Parameters.AddWithValue("@Arg64 ", ed.ACTPoliceSecurityFireMarshall); cmd.Parameters.AddWithValue("@Arg65 ", ed.ACTProgram); cmd.Parameters.AddWithValue("@Arg66 ", ed.ACTRent); cmd.Parameters.AddWithValue("@Arg67 ", ed.ACTSoundLights); cmd.Parameters.AddWithValue("@Arg69 ", ed.ACTTelephonesInternet); cmd.Parameters.AddWithValue("@Arg70 ", ed.ACTDryIceC02); cmd.Parameters.AddWithValue("@Arg71 ", ed.ACTLOCOther1); cmd.Parameters.AddWithValue("@Arg72 ", ed.ACTLOCOther2); cmd.Parameters.AddWithValue("@Arg73 ", ed.ACTLOCOther3); cmd.Parameters.AddWithValue("@Arg74 ", ed.ACTLOCOther4); cmd.Parameters.AddWithValue("@Arg75 ", ed.ACTLOCOther5); cmd.Parameters.AddWithValue("@Arg76 ", ed.ACTLocalFixed); try { if (dbconn.State == ConnectionState.Closed) { dbconn.Open(); } cmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { if (dbconn.State == ConnectionState.Open) { dbconn.Close(); } } }