private void ClientInfo_Load(object sender, EventArgs e)
{
string sql = @" select cp.*, ccd.FirstCheckDate from ClientPayroll cp left join ClientCheckDate ccd on cp.AccNum=ccd.AccNum ";
dt_clients = DBOperator.QuerySql(sql);
//ClientPayrolls = DBOperator.getListFromTable<Model.ClientPayroll>(dt);
var acclist = from ac in dt_clients.AsEnumerable()
select ac[0].ToString();
AccNumList.DataSource = acclist.ToArray();
var enList = from ac in dt_clients.AsEnumerable()
select ac[5].ToString();
comboBox2.DataSource = enList.ToArray();
this.comboBox2.SelectedIndexChanged += new System.EventHandler(this.comboBox2_SelectedIndexChanged);
editControls(true);
if (Main.cUser.UserLevel >= 10)
{
tAccRep.Enabled = false;
tPayRep.Enabled = false;
tCkRep.Enabled = false;
}
else
{
dFirstCheckDate.Enabled = false;
tAccRep.Enabled = false;
tPayRep.Enabled = false;
tCkRep.Enabled = false;
}
dFirstCheckDate.Enabled = true;
}
private void dFirstCheckDate_ValueChanged(object sender, EventArgs e)
{
string accNum = tAccNum.Text;
string sql = "delete ClientCheckDate where AccNum='" + accNum + @"';
insert into ClientCheckDate values('" + accNum + "','" + dFirstCheckDate.Text + "');";
DBOperator.ExecuteSql(sql);
sql = " select cp.*, ccd.FirstCheckDate from ClientPayroll cp left join ClientCheckDate ccd on cp.AccNum = ccd.AccNum ";
dt_clients = DBOperator.QuerySql(sql);
}
public static void SetComboxRepDataFirstName(ComboBox comb)
{
string sql = "select Rep, FirstName as 'Name' from Representative order by FirstName, LastName";
DataTable dt = DBOperator.QuerySql(sql);
DataRow dr = dt.NewRow();
dr["Rep"] = "All";
dr["Name"] = "All";
dt.Rows.InsertAt(dr, 0);
comb.DataSource = dt;
comb.ValueMember = "Rep";
comb.DisplayMember = "Name";
}
private void saveCurentItem()
{
string sql = "update ClientPayroll set EIN='" + tEIN.Text.Replace("'", "''") + "', AccRep='" + tAccRep.Text + "', PayRep='" + tPayRep.Text + "', CkRep='" + tCkRep.Text + "', Entity='" + tEntity.Text.Replace("'", "''") + "', TradeName='" + tTradeName.Text.Replace("'", "''") + "', BusAdd1='" + tBusAdd1.Text + "', BusAdd2='" + tBusAdd2.Text + "', BusCity='" + tBusCity.Text + "', BusSt='" + tBusSt.Text + "', BusZip='" + tBusZip.Text + @"',
MailAdd1 = '" + tMailAdd1.Text + "', MailAdd2 = '" + tMailAdd2.Text + "', MailCity = '" + tMailCity.Text + "', MailSt = '" + tMailSt.Text + "', MailZip = '" + tMailZip.Text + "', HomeAdd = '" + tHomeAdd.Text + "', Contact1 = '" + tContact1.Text + "', Contact1Tel1 = '" + tContact1Tel1.Text + "', Contact1Tel2 = '" + tContact1Tel2.Text + "', Contact2 = '" + tContact2.Text + "', Contact2Tel1 = '" + tContact2Tel1.Text + @"',
Contact2Tel2 = '" + tContact2Tel2.Text + "', Fax = '" + tFax.Text + "', Email = '" + tEmail.Text + "', Lauguage = '" + tLanguage.Text + "', PayStartDate = '" + tpayStartDate.Text + "', PayType = '" + cPayType.Text + "', PayFreq = '" + cPayFreq.Text + "', TaxDepType = '" + cTaxDepType.Text + "', Bank = '" + tBank.Text + "', BankRtg = '" + tBankRtg.Text + "', BankAcc = '" + tBankAcc.Text + "', BankStartDate = '" + tbankStartDate.Text + @"',
DateIn = '" + cDateIn.Text + "', DateOut = '" + cDateOut.Text + "', TimeToDone = '" + tTimeToDone.Text + "', AveNumEE = '" + tAveNumEE.Text + "', PayClosedDate = '" + tpayCloseDate.Text + "', Note = '" + tNote.Text.Replace("'", "''") + "', FedTaxFreq = '" + cFedTaxFreq.Text + "', EFTPS = '" + tEFTPS.Text + "', F8655 = '" + cF8655.Text + "', EFTPSPin = '" + tEFTPSPin.Text + "', EFTPSPw = '" + tEFTPSPw.Text + "', PhilaNum = '" + tPhilaNum.Text + @"',
PhilaTaxFreq = '" + cPhilaTaxFreq.Text + "', PhilaPayType = '" + cPhilaPayType.Text + "', PhilaEZReportNum = '" + tPhilaEZReportN.Text + "', PhilaEZPw = '" + tPhilaEZPw.Text + "', PhilaOnlinePin = '" + tPhilaOnlinePin.Text + "', Local = '" + tLocal.Text + "', LocalPSD = '" + tLocalPSD.Text + "', LocalCollector = '" + tLocalCollector.Text + "', LocalTaxFreq = '" + tLocalTaxFreq.Text + @"',
LocalPayType = '" + cLocalPayType.Text + "', LocalUser = '******', LocalPw = '" + tLocalPw.Text + "', LST = '" + tLST.Text + "', LSTCollector = '" + tLSTCollector.Text + "', LSTTaxFreq = '" + tLSTTaxFreq.Text + "', LSTPayType = '" + cLSTPayType.Text + "', LSTUser = '******', LSTPw = '" + tLSTPW.Text + "', UC = '" + tUC.Text + "', UCNum = '" + tUCNum.Text + "', UCPayType = '" + cUCPayType.Text + @"',
UCUsername = '******', UCPassword = '******', UCContaceEM = '" + tUCContactEm.Text + "', PAUCQ1 = '" + tPAUCQ1.Text.Replace("'", "''") + "', PAUCQ2 = '" + tPAUCQ2.Text.Replace("'", "''") + "', PAUCQ3 = '" + tPAUCQ3.Text.Replace("'", "''") + "', State = '" + tState.Text + @"',
StateTaxFreq = '" + cStateTaxFreq.Text + "', StateWH = '" + tStateWH.Text + "', StateUser = '******', StatePw = '" + tStatePw.Text + @"'
where AccNum = '" + tAccNum.Text + "'";
DBOperator.ExecuteSql(sql);
sql = " select cp.*, ccd.FirstCheckDate from ClientPayroll cp left join ClientCheckDate ccd on cp.AccNum = ccd.AccNum ";
dt_clients = DBOperator.QuerySql(sql);
}
