public int SaveUpdateBillAccount(BillAccount obBillAcc, SqlConnection con, SqlTransaction trans)
{
int ID = 0;
SqlCommand com = null;
try
{
com = new SqlCommand("", con, trans);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@SlNo", SqlDbType.Int).Value = obBillAcc.SlNo;
com.Parameters.Add("@BillID", SqlDbType.Int).Value = obBillAcc.BillID;
com.Parameters.Add("@AccountID", SqlDbType.Int).Value = obBillAcc.AccountID;
//com.Parameters.Add("@DrCr", SqlDbType.VarChar, 50).Value = obBillAcc.DrCr;
com.Parameters.Add("@Particulars", SqlDbType.VarChar, 500).Value = obBillAcc.Particulars;
//com.Parameters.Add("@Amount", SqlDbType.Money).Value = obBillAcc.Amount;
com.ExecuteNonQuery();
if (obBillAcc.SlNo == 0)
{
SqlCommand cmd = new SqlCommand("SELECT ISNULL(MAX(SINo),0) FROM T_Export_Bill", con, trans);
ID = Convert.ToInt32(cmd.ExecuteScalar());
}
else
{
ID = obBillAcc.SlNo;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(ID);
}
public int SaveUpdateBillAccount(BillAccount obBillAcc, SqlConnection con, SqlTransaction trans)
{
int ID = 0;
SqlCommand com = null;
try
{
com = new SqlCommand("spSaveUpdateBillAccount", con, trans);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@SlNo", SqlDbType.Int).Value = obBillAcc.SlNo;
com.Parameters.Add("@BillID", SqlDbType.Int).Value = obBillAcc.BillID;
com.Parameters.Add("@AccountID", SqlDbType.Int).Value = obBillAcc.AccountID;
com.Parameters.Add("@Particulars", SqlDbType.VarChar, 500).Value = obBillAcc.Particulars;
com.Parameters.Add("@DebitAmount", SqlDbType.Money).Value = obBillAcc.DebitAmount;
com.Parameters.Add("@CreditAmount", SqlDbType.Money).Value = obBillAcc.CreditAmount;
com.Parameters.Add("@posted", SqlDbType.Int).Value = obBillAcc.Posted;
com.Parameters.Add("@Ref", SqlDbType.VarChar, 50).Value = obBillAcc.Reference;
com.Parameters.Add("@VoucherType", SqlDbType.VarChar, 100).Value = obBillAcc.VoucherType;
com.Parameters.Add("@VoucherSlNo", SqlDbType.Int).Value = obBillAcc.VoucherSlNo;
com.ExecuteNonQuery();
//if (obBillAcc.SlNo == 0)
//{
// SqlCommand cmd = new SqlCommand("SELECT ISNULL(MAX(SINo),0) FROM T_Bill_Accounts", con, trans);
// ID = Convert.ToInt32(cmd.ExecuteScalar());
//}
//else
// ID = obBillAcc.SlNo;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(ID);
}
public int Save(BillAccount billaccount)
{
using (var db = GetDbContext())
{
db.BillAccounts.Add(billaccount);
db.SaveChanges();
return(billaccount.ID);
}
}
public BillAccountForm(BillAccount account)
{
InitializeComponent();
this.BillAccount = account;
}
