public void InsertVendorStatutory(Vendor.BusinessLayer.StatutoryBL argStatutory)
{
SqlConnection conn;
conn = new SqlConnection();
conn = BsfGlobal.OpenVendorAnalDB();
SqlTransaction tran = conn.BeginTransaction();
try
{
SqlCommand Command = new SqlCommand("Insert_Statutory", conn, tran);
Command.CommandType = CommandType.StoredProcedure;
Command.Parameters.Clear();
Command.Parameters.AddWithValue("@VendorId", argStatutory.VendorId);
Command.Parameters.AddWithValue("@FirmType", argStatutory.FirmType);
Command.Parameters.AddWithValue("@EYear", argStatutory.EYear);
Command.Parameters.AddWithValue("@PANNo", argStatutory.PANNo);
Command.Parameters.AddWithValue("@TANNo", argStatutory.TANNo);
Command.Parameters.AddWithValue("@CSTNo", argStatutory.CSTNo);
Command.Parameters.AddWithValue("@TINNo", argStatutory.TINNo);
Command.Parameters.AddWithValue("@BankAccountNo", argStatutory.BankAccountNo);
Command.Parameters.AddWithValue("@AccountType", argStatutory.AccountType);
Command.Parameters.AddWithValue("@BankName", argStatutory.BankName);
Command.Parameters.AddWithValue("@BranchName", argStatutory.BranchName);
Command.Parameters.AddWithValue("@BranchCode", argStatutory.BranchCode);
Command.Parameters.AddWithValue("@ServiceTaxNo", argStatutory.ServiceTaxNo);
Command.Parameters.AddWithValue("@TNGSTNo", argStatutory.TNGSTNo);
Command.Parameters.AddWithValue("@MICRCode", argStatutory.MICRCode);
Command.Parameters.AddWithValue("@IFSCCode", argStatutory.IFSCCode);
//SSIREGDNo,ServiceTaxCir,EPFNo,ESINo,ExciseVendor,ExciseRegNo,Excisedivision,ExciseRange,ECCno
Command.Parameters.AddWithValue("@SSIREGDNo", argStatutory.SSIREGDNo);
Command.Parameters.AddWithValue("@ServiceTaxCir", argStatutory.ServiceTaxCir);
Command.Parameters.AddWithValue("@EPFNo", argStatutory.EPFNo);
Command.Parameters.AddWithValue("@ESINo", argStatutory.ESINo);
Command.Parameters.AddWithValue("@ExciseVendor", argStatutory.ExciseVendor);
Command.Parameters.AddWithValue("@ExciseRegNo", argStatutory.ExciseRegNo);
Command.Parameters.AddWithValue("@Excisedivision", argStatutory.Excisedivision);
Command.Parameters.AddWithValue("@ExciseRange", argStatutory.ExciseRange);
Command.Parameters.AddWithValue("@ECCno", argStatutory.ECCno);
Command.ExecuteNonQuery();
tran.Commit();
}
catch
{
tran.Rollback();
}
finally
{
conn.Close();
}
}
public void InsertVendorStatutory(Vendor.BusinessLayer.StatutoryBL argStatutory)
{
m_oStatutory.InsertVendorStatutory(argStatutory);
}
