public bool InsertGrNomimast()
{
try
{
DataTable dtSlab = new DataTable();
cmd = new SqlCommand("", lConnect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertGrNomimast";
//cmd.Parameters.AddWithValue("@id", this.id);
cmd.Parameters.AddWithValue("@compcode", this.compcode);
cmd.Parameters.AddWithValue("@empno", this.empno);
cmd.Parameters.AddWithValue("@NomiName", this.NomiName);
cmd.Parameters.AddWithValue("@rel", this.rel);
cmd.Parameters.AddWithValue("@dob", this.dob);
cmd.Parameters.AddWithValue("@share", this.share);
cmd.Parameters.AddWithValue("@tDeleteRecords", this._tDeleteRecords);
cmd.CommandTimeout = 1000000000;
int iResult = cmd.ExecuteNonQuery();
if (iResult != -1)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
return(false);
}
finally
{
cn.CloseConnection();
}
}
internal bool InsertSATranIn()
{
try
{
DataTable dtSlab = new DataTable();
cmd = new SqlCommand("", lConnect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertSATranIn";
cmd.Parameters.AddWithValue("@srno", this.Srno);
cmd.Parameters.AddWithValue("@compcode", this.Compcode);
cmd.Parameters.AddWithValue("@Empno", this.Empno);
cmd.Parameters.AddWithValue("@EmpName", this.Empname);
cmd.Parameters.AddWithValue("@YearCode", this.Yearcode);
cmd.Parameters.AddWithValue("@Month", this.Month);
cmd.Parameters.AddWithValue("@Year", this.Year);
cmd.Parameters.AddWithValue("@Amount", this.Amount);
cmd.Parameters.AddWithValue("@tDeleteRecords", this._tDeleteRecords);
cmd.CommandTimeout = 1000000000;
int iResult = cmd.ExecuteNonQuery();
if (iResult != -1)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
return(false);
}
finally
{
cn.CloseConnection();
}
}
public bool InsertSAMaster()
{
try
{
DataTable dtSlab = new DataTable();
cmd = new SqlCommand("", lConnect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertSAMaster";
cmd.Parameters.AddWithValue("@Srno", this.Srno);
cmd.Parameters.AddWithValue("@Compcode", this.Compcode);
cmd.Parameters.AddWithValue("@Empno", this.Empno);
cmd.Parameters.AddWithValue("@SANo", this.SANo);
cmd.Parameters.AddWithValue("@Empname", this.Empname);
cmd.Parameters.AddWithValue("@SaDom", this.sa_dom);
cmd.Parameters.AddWithValue("@tDeleteRecords", this._tDeleteRecords);
cmd.CommandTimeout = 1000000000;
int iResult = cmd.ExecuteNonQuery();
if (iResult != -1)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
return(false);
}
finally
{
cn.CloseConnection();
}
}
public bool InsertSAInterest()
{
try
{
DataTable dtSlab = new DataTable();
cmd = new SqlCommand("", lConnect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertSAInterest";
cmd.Parameters.AddWithValue("@Compcode", this.Compcode);
cmd.Parameters.AddWithValue("@Empno", this.Empno);
cmd.Parameters.AddWithValue("@Empname", this.Empname);
cmd.Parameters.AddWithValue("@Sa_Int", this.SAInT);
cmd.Parameters.AddWithValue("@Ex_Employer_Int", this.Ex_Employer);
cmd.Parameters.AddWithValue("@Uptodate", this.Uptodate);
cmd.Parameters.AddWithValue("@Yearcode", this.Yearcode);
cmd.Parameters.AddWithValue("@tDeleteRecords", this._tDeleteRecords);
cmd.CommandTimeout = 1000000000;
int iResult = cmd.ExecuteNonQuery();
if (iResult != -1)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
return(false);
}
finally
{
cn.CloseConnection();
}
}
public bool Insert()
{
try
{
DataTable dtSlab = new DataTable();
cmd = new SqlCommand("", lConnect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertNRWRefund";
cmd.Parameters.AddWithValue("@COMPCODE", this.COMPCODE);
cmd.Parameters.AddWithValue("@YEARCODE", this.YEARCODE);
cmd.Parameters.AddWithValue("@EMPNO", this.EMPNO);
cmd.Parameters.AddWithValue("@NRWTYPE", this.NRWTYPE);
cmd.Parameters.AddWithValue("@AVAILDT", this.AVAILDT);
cmd.Parameters.AddWithValue("@AVAILNRW", this.AVAILNRW);
cmd.Parameters.AddWithValue("@VCHNO", this.VCHNO);
cmd.Parameters.AddWithValue("@REFUNDDT", this.REFUNDDT);
cmd.Parameters.AddWithValue("@EFFDATE", this.EFFDATE);
cmd.Parameters.AddWithValue("@CHQNO", this.CHQNO);
cmd.Parameters.AddWithValue("@NRWREFAMT", this.NRWREFAMT);
cmd.Parameters.AddWithValue("@BKCODE", this.BKCODE);
cmd.Parameters.AddWithValue("@COMPPF", this.COMPPF);
cmd.Parameters.AddWithValue("@OWNPF", this.OWNPF);
cmd.Parameters.AddWithValue("@VOLPF", this.VOLPF);
cmd.Parameters.AddWithValue("@TOTALREFAMT", this.TOTALREFAMT);
cmd.Parameters.AddWithValue("@CHQDT", this.CHQDT);
cmd.Parameters.AddWithValue("@REMARKS", this.REMARKS);
cmd.Parameters.AddWithValue("@APPROVED", this.APPROVED);
cmd.Parameters.AddWithValue("@APPROVUSER", this.APPROVUSER);
cmd.Parameters.AddWithValue("@APPROVDT", this.APPROVDT);
cmd.Parameters.AddWithValue("@TAG", this.TAG);
cmd.Parameters.AddWithValue("@USER01", this.USER01);
cmd.Parameters.AddWithValue("@LOGDT01", this.LOGDT01);
cmd.Parameters.AddWithValue("@USER02", this.USER02);
cmd.Parameters.AddWithValue("@LOGDT02", this.LOGDT02);
cmd.Parameters.AddWithValue("@AUTOSERIAL", this.AUTOSERIAL);
cmd.Parameters.AddWithValue("@loantype", this.loantype);
cmd.Parameters.AddWithValue("@intcomppf", this.intcomppf);
cmd.Parameters.AddWithValue("@intownpf", this.intownpf);
cmd.Parameters.AddWithValue("@intvolpf", this.intvolpf);
cmd.Parameters.AddWithValue("@RefundIntt", this.RefundIntt);
cmd.Parameters.AddWithValue("@RefLoanVch", this.RefLoanVch);
cmd.Parameters.AddWithValue("@tDeleteRecords", this.TDeleteRecords);
cmd.CommandTimeout = 1000000000;
int iResult = cmd.ExecuteNonQuery();
if (iResult != -1)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
return(false);
}
finally
{
cn.CloseConnection();
}
}
public bool InsertEmpInterest()
{
try
{
DataTable dtSlab = new DataTable();
cmd = new SqlCommand("", lConnect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertEmpInterest";
cmd.Parameters.AddWithValue("@compcode", this.Compcode);
cmd.Parameters.AddWithValue("@Empno", this.Empno);
cmd.Parameters.AddWithValue("@EmpName", this.EmpName);
cmd.Parameters.AddWithValue("@OWNINTT", this.OWNINTT);
cmd.Parameters.AddWithValue("@VOLINTT", this.VOLINTT);
cmd.Parameters.AddWithValue("@COMPINTT", this.COMPINTT);
cmd.Parameters.AddWithValue("@uptodate", Convert.ToDateTime(this.Uptodate));
cmd.Parameters.AddWithValue("@YearCode", this.YearCode);
cmd.Parameters.AddWithValue("@tDeleteRecords", this._tDeleteRecords);
cmd.CommandTimeout = 1000000000;
int iResult = cmd.ExecuteNonQuery();
if (iResult != -1)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
return(false);
}
finally
{
cn.CloseConnection();
}
}
public bool InsertSAOpeningBalance()
{
try
{
DataTable dtSlab = new DataTable();
cmd = new SqlCommand("", lConnect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertSAOpeningBalance";
cmd.Parameters.AddWithValue("@srno", this.SrNo);
cmd.Parameters.AddWithValue("@compcode", this.Compcode);
cmd.Parameters.AddWithValue("@Empno", this.Empno);
cmd.Parameters.AddWithValue("@EmpName", this.Empname);
cmd.Parameters.AddWithValue("@YearCode", this.Yearcode);
cmd.Parameters.AddWithValue("@CEO_Bal", this.CEO_Bal);
cmd.Parameters.AddWithValue("@XEO_Bal", this.XEO_Bal);
cmd.Parameters.AddWithValue("@tDeleteRecords", this._tDeleteRecords);
cmd.CommandTimeout = 1000000000;
int iResult = cmd.ExecuteNonQuery();
if (iResult != -1)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
return(false);
}
finally
{
cn.CloseConnection();
}
}
public bool ExeUserLogin()
{
try
{
DataTable dtSlab = new DataTable();
cmd = new SqlCommand("", lConnect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "ExeUserLogin";
cmd.Parameters.AddWithValue("@userName", this.Username);
cmd.Parameters.AddWithValue("@password", this.Password);
SqlParameter IsAuthenticated = new SqlParameter();
IsAuthenticated.ParameterName = "@isAuthenticated";
IsAuthenticated.Direction = ParameterDirection.Output;
IsAuthenticated.SqlDbType = SqlDbType.Bit;
cmd.Parameters.Add(IsAuthenticated);
cmd.CommandTimeout = 1000000000;
int iResult = cmd.ExecuteNonQuery();
return(Convert.ToBoolean(cmd.Parameters["@isAuthenticated"].Value));
}
catch (Exception ex)
{
return(false);
}
finally
{
cn.CloseConnection();
}
}
public bool InsertPFLedgerall()
{
try
{
DataTable dtSlab = new DataTable();
cmd = new SqlCommand("", lConnect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertPFLedgerall";
cmd.Parameters.AddWithValue("@COMPCODE", this.COMPCODE);
cmd.Parameters.AddWithValue("@YEARCODE", this.YEARCODE);
cmd.Parameters.AddWithValue("@USERNAME", this.USERNAME);
cmd.Parameters.AddWithValue("@EMPNO", this.EMPNO);
cmd.Parameters.AddWithValue("@MONTHNAME", this.MONTHNAME);
cmd.Parameters.AddWithValue("@UPTODATE", this.UPTODATE);
cmd.Parameters.AddWithValue("@Serial", this.Serial);
cmd.Parameters.AddWithValue("@OwnCont", this.OwnCont);
cmd.Parameters.AddWithValue("@CoCont", this.CoCont);
cmd.Parameters.AddWithValue("@VolCont", this.VolCont);
cmd.Parameters.AddWithValue("@OwnInt", this.OwnInt);
cmd.Parameters.AddWithValue("@CoInt", this.CoInt);
cmd.Parameters.AddWithValue("@VolInt", this.VolInt);
cmd.Parameters.AddWithValue("@Total", this.Total);
cmd.Parameters.AddWithValue("@Col8", this.Col8);
cmd.Parameters.AddWithValue("@Col9", this.Col9);
cmd.Parameters.AddWithValue("@Col10", this.Col10);
cmd.Parameters.AddWithValue("@Ibbowtot", this.Ibbowtot);
cmd.Parameters.AddWithValue("@Ibbcotot", this.Ibbcotot);
cmd.Parameters.AddWithValue("@Ibbvoltot", this.Ibbvoltot);
cmd.Parameters.AddWithValue("@Tag", this.Tag);
cmd.Parameters.AddWithValue("@NoOfMonth", this.NoOfMonth);
cmd.Parameters.AddWithValue("@MonthA", this.MonthA);
cmd.Parameters.AddWithValue("@EmpSerial", this.EmpSerial);
cmd.Parameters.AddWithValue("@monthdesc", this.monthdesc);
cmd.Parameters.AddWithValue("@EmpName", this.EmpName);
cmd.Parameters.AddWithValue("@TranCode", this.TranCode);
cmd.Parameters.AddWithValue("@PfCode", this.PfCode);
cmd.Parameters.AddWithValue("@CFPF", this.CFPF);
cmd.Parameters.AddWithValue("@VCHNO", this.VCHNO);
cmd.Parameters.AddWithValue("@Autoserial", this.Autoserial);
cmd.Parameters.AddWithValue("@tDeleteRecords", this._tDeleteRecords);
cmd.CommandTimeout = 1000000000;
int iResult = cmd.ExecuteNonQuery();
if (iResult != -1)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
return(false);
}
finally
{
cn.CloseConnection();
}
}
public int InsertHostel(string HostelNo, string HostelName, string Username, string Date)
{
string QueryString = "Insert into Mst_Hostel(Hostel_No,HostelName,EnteredBy,EnteredDate) values('" + HostelNo + "','" + HostelName + "','" + Username + "',convert(datetime,'" + Date + "',103))";
cmd.CommandText = QueryString;
connect.OpenConnection();
int check = cmd.ExecuteNonQuery();
connect.CloseConnection();
return(check);
}
public bool InsertSAContribution()
{
try
{
DataTable dtSlab = new DataTable();
cmd = new SqlCommand("", lConnect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertSAContribution";
cmd.Parameters.AddWithValue("@Srno", this.Srno);
cmd.Parameters.AddWithValue("@Compcode", this.Compcode);
cmd.Parameters.AddWithValue("@Empno", this.Empno);
cmd.Parameters.AddWithValue("@Empname", this.Empname);
cmd.Parameters.AddWithValue("@April", this.April);
cmd.Parameters.AddWithValue("@May", this.May);
cmd.Parameters.AddWithValue("@June", this.June);
cmd.Parameters.AddWithValue("@July", this.July);
cmd.Parameters.AddWithValue("@August", this.August);
cmd.Parameters.AddWithValue("@September", this.September);
cmd.Parameters.AddWithValue("@October", this.October);
cmd.Parameters.AddWithValue("@November", this.November);
cmd.Parameters.AddWithValue("@December", this.December);
cmd.Parameters.AddWithValue("@January", this.January);
cmd.Parameters.AddWithValue("@February", this.February);
cmd.Parameters.AddWithValue("@March", this.March);
cmd.Parameters.AddWithValue("@Uptodate", this.Uptodate);
cmd.Parameters.AddWithValue("@Yearcode", this.Yearcode);
cmd.Parameters.AddWithValue("@tDeleteRecords", this._tDeleteRecords);
cmd.CommandTimeout = 1000000000;
int iResult = cmd.ExecuteNonQuery();
if (iResult != -1)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
return(false);
}
finally
{
cn.CloseConnection();
}
}
public DataTable GetAllYears()
{
try
{
DataTable dtSlab = new DataTable();
cmd.CommandText = "GetAllYears";
reader = cmd.ExecuteReader();
dtSlab.Load(reader);
return(dtSlab);
}
catch (Exception ex)
{
throw ex;
}
finally
{
cn.CloseConnection();
}
}
public bool Insert()
{
try
{
DataTable dtSlab = new DataTable();
cmd = new SqlCommand("", lConnect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertSETTLEMENT";
cmd.Parameters.AddWithValue("@CompCode", this.CompCode);
cmd.Parameters.AddWithValue("@YearCode", this.YearCode);
cmd.Parameters.AddWithValue("@EmpNo", this.EmpNo);
cmd.Parameters.AddWithValue("@BKCODE", this.BKCODE);
cmd.Parameters.AddWithValue("@Settle_Trans", this.Settle_Trans);
cmd.Parameters.AddWithValue("@ChequePrint", this.ChequePrint);
cmd.Parameters.AddWithValue("@PayTo", this.PayTo);
cmd.Parameters.AddWithValue("@PBankAccNo", this.PBankAccNo);
cmd.Parameters.AddWithValue("@SettleDt", this.SettleDt);
cmd.Parameters.AddWithValue("@Chqno", this.Chqno);
cmd.Parameters.AddWithValue("@ChqDt", this.ChqDt);
cmd.Parameters.AddWithValue("@Remarks", this.Remarks);
cmd.Parameters.AddWithValue("@Vchno", this.Vchno);
cmd.Parameters.AddWithValue("@VchDt", this.VchDt);
cmd.Parameters.AddWithValue("@OWNPF", this.OWNPF);
cmd.Parameters.AddWithValue("@VOLPF", this.VOLPF);
cmd.Parameters.AddWithValue("@COMPPF", this.COMPPF);
cmd.Parameters.AddWithValue("@OWNINT", this.OWNINT);
cmd.Parameters.AddWithValue("@VOLINT", this.VOLINT);
cmd.Parameters.AddWithValue("@COMPINT", this.COMPINT);
cmd.Parameters.AddWithValue("@NONREFLOAN", this.NONREFLOAN);
cmd.Parameters.AddWithValue("@TDSAMT", this.TDSAMT);
cmd.Parameters.AddWithValue("@SETTLEAMT", this.SETTLEAMT);
cmd.Parameters.AddWithValue("@REFLOAN", this.REFLOAN);
cmd.Parameters.AddWithValue("@LOANBAL", this.LOANBAL);
cmd.Parameters.AddWithValue("@NEGSAL", this.NEGSAL);
cmd.Parameters.AddWithValue("@TRANSTOOTHFUNDS", this.TRANSTOOTHFUNDS);
cmd.Parameters.AddWithValue("@RTGS", this.RTGS);
cmd.Parameters.AddWithValue("@SET_PRINT", this.SET_PRINT);
cmd.Parameters.AddWithValue("@PRINTDT", this.PRINTDT);
cmd.Parameters.AddWithValue("@MAKER", this.MAKER);
cmd.Parameters.AddWithValue("@MAKEDT", this.MAKEDT);
cmd.Parameters.AddWithValue("@CHECKED", this.CHECKED);
cmd.Parameters.AddWithValue("@CHECKER", this.CHECKER);
cmd.Parameters.AddWithValue("@CHECKDT", this.CHECKDT);
cmd.Parameters.AddWithValue("@APPROVED", this.APPROVED);
cmd.Parameters.AddWithValue("@APPROVEUSER", this.APPROVEUSER);
cmd.Parameters.AddWithValue("@APPROVEDT", this.APPROVEDT);
cmd.Parameters.AddWithValue("@CONFIRMEMAILDT", this.CONFIRMEMAILDT);
cmd.Parameters.AddWithValue("@INT_TRF_EMPNO", this.INT_TRF_EMPNO);
cmd.Parameters.AddWithValue("@cFiller01", this.cFiller01);
cmd.Parameters.AddWithValue("@cFiller02", this.cFiller02);
cmd.Parameters.AddWithValue("@NFiller01", this.NFiller01);
cmd.Parameters.AddWithValue("@NFiller02", this.NFiller02);
cmd.Parameters.AddWithValue("@Tag", this.Tag);
cmd.Parameters.AddWithValue("@autoserial", this.autoserial);
cmd.Parameters.AddWithValue("@NoofServYear", this.NoofServYear);
cmd.Parameters.AddWithValue("@CompContDed", this.CompContDed);
cmd.Parameters.AddWithValue("@CompIntDed", this.CompIntDed);
cmd.Parameters.AddWithValue("@RateofDed", this.RateofDed);
cmd.Parameters.AddWithValue("@DEATHNAME", this.DEATHNAME);
cmd.Parameters.AddWithValue("@DEATHNAME1", this.DEATHNAME1);
cmd.Parameters.AddWithValue("@DEATHNAME2", this.DEATHNAME2);
cmd.Parameters.AddWithValue("@DEATHNAME3", this.DEATHNAME3);
cmd.Parameters.AddWithValue("@DEATHNAME4", this.DEATHNAME4);
cmd.Parameters.AddWithValue("@DEATH", this.DEATH);
cmd.Parameters.AddWithValue("@DisallowAmount", this.DisallowAmount);
cmd.Parameters.AddWithValue("@itax", this.itax);
cmd.Parameters.AddWithValue("@itaxcess", this.itaxcess);
cmd.Parameters.AddWithValue("@itaxSurcharge", this.itaxSurcharge);
cmd.Parameters.AddWithValue("@PFTPrint", this.PFTPrint);
cmd.Parameters.AddWithValue("@TDSPERC", this.TDSPERC);
cmd.Parameters.AddWithValue("@DED24GENERATED", this.DED24GENERATED);
cmd.Parameters.AddWithValue("@TDS_USERNAME", this.TDS_USERNAME);
cmd.Parameters.AddWithValue("@TDS_LOGDATE", this.TDS_LOGDATE);
cmd.Parameters.AddWithValue("@TDS_AMOUNT", this.TDS_AMOUNT);
cmd.Parameters.AddWithValue("@tDeleteRecords", this.TDeleteRecords);
cmd.CommandTimeout = 1000000000;
int iResult = cmd.ExecuteNonQuery();
if (iResult != -1)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
return(false);
}
finally
{
cn.CloseConnection();
}
}
public bool Insert()
{
try
{
DataTable dtSlab = new DataTable();
cmd = new SqlCommand("", lConnect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertVCHDETL";
cmd.Parameters.AddWithValue("@COMPCODE", this.COMPCODE);
cmd.Parameters.AddWithValue("@YEARCODE", this.YEARCODE);
cmd.Parameters.AddWithValue("@VCHNO", this.VCHNO);
cmd.Parameters.AddWithValue("@VCHDATE", this.VCHDATE);
cmd.Parameters.AddWithValue("@YEARMONTH", this.YEARMONTH);
cmd.Parameters.AddWithValue("@EMPNO", this.EMPNO);
cmd.Parameters.AddWithValue("@LOCCD", this.LOCCD);
cmd.Parameters.AddWithValue("@BASIC", this.BASIC);
cmd.Parameters.AddWithValue("@GROSS", this.GROSS);
cmd.Parameters.AddWithValue("@EPF", this.EPF);
cmd.Parameters.AddWithValue("@EFPF", this.EFPF);
cmd.Parameters.AddWithValue("@CPF", this.CPF);
cmd.Parameters.AddWithValue("@CFPF", this.CFPF);
cmd.Parameters.AddWithValue("@VPF", this.VPF);
cmd.Parameters.AddWithValue("@PFLOANRECO", this.PFLOANRECO);
cmd.Parameters.AddWithValue("@LOTNO", this.LOTNO);
cmd.Parameters.AddWithValue("@CFILLER01", this.CFILLER01);
cmd.Parameters.AddWithValue("@NFILLER01", this.NFILLER01);
cmd.Parameters.AddWithValue("@NFILLER02", this.NFILLER02);
cmd.Parameters.AddWithValue("@DFILLER01", this.DFILLER01);
cmd.Parameters.AddWithValue("@TAG", this.TAG);
cmd.Parameters.AddWithValue("@User01", this.User01);
cmd.Parameters.AddWithValue("@LogDt01", this.LogDt01);
cmd.Parameters.AddWithValue("@ORGFILENAME", this.ORGFILENAME);
cmd.Parameters.AddWithValue("@USER02", this.USER02);
cmd.Parameters.AddWithValue("@LOGDT02", this.LOGDT02);
cmd.Parameters.AddWithValue("@UPDATEFILENAME", this.UPDATEFILENAME);
cmd.Parameters.AddWithValue("@Imported", this.Imported);
cmd.Parameters.AddWithValue("@ImportUser", this.ImportUser);
cmd.Parameters.AddWithValue("@ImportDate", this.ImportDate);
cmd.Parameters.AddWithValue("@autoserial", this.autoserial);
cmd.Parameters.AddWithValue("@SA_Contribution", this.SA_Contribution);
cmd.Parameters.AddWithValue("@noofmon", this.noofmon);
cmd.Parameters.AddWithValue("@PFLOANINT", this.PFLOANINT);
cmd.Parameters.AddWithValue("@SplPay", this.SplPay);
cmd.Parameters.AddWithValue("@PenSalary", this.PenSalary);
cmd.Parameters.AddWithValue("@EDLISalary", this.EDLISalary);
cmd.Parameters.AddWithValue("@Prnt", this.Prnt);
cmd.Parameters.AddWithValue("@lossofpay", this.lossofpay);
cmd.Parameters.AddWithValue("@Sa_Vpf", this.Sa_Vpf);
cmd.Parameters.AddWithValue("@DepositDate", this.DepositDate);
cmd.Parameters.AddWithValue("@tDeleteRecords", this.TDeleteRecords);
cmd.CommandTimeout = 1000000000;
int iResult = cmd.ExecuteNonQuery();
if (iResult != -1)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
return(false);
}
finally
{
cn.CloseConnection();
}
}
