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