private void btnUpdate_Click(object sender, EventArgs e)
{
ContraVoucherModel objcontra = new ContraVoucherModel();
if (tbxVoucherNo.Text.Trim() == "")
{
MessageBox.Show("Voucher Number Can Not Be Blank!");
return;
}
objcontra.Voucher_Series = tbxVoucherSeries.SelectedItem.ToString();
objcontra.Voucher_Number = Convert.ToInt64(tbxVoucherNo.Text.Trim());
objcontra.CV_Date = Convert.ToDateTime(dtDate.Text.Trim());
objcontra.PDCDate = Convert.ToDateTime(dtPdc.Text.Trim());
objcontra.Type = cbxType.SelectedItem.ToString();
objcontra.LongNarration = tbxLongNarration.Text.Trim();
objcontra.TotalCreditAmount = Convert.ToDecimal(colCredit.SummaryItem.SummaryValue);
objcontra.TotalDebitAmount = Convert.ToDecimal(colDebit.SummaryItem.SummaryValue);
//Contra Account Details
AccountModel objacc;
List <AccountModel> lstAccounts = new List <AccountModel>();
for (int i = 0; i < dvgContraDetails.DataRowCount; i++)
{
DataRow row = dvgContraDetails.GetDataRow(i);
objacc = new AccountModel();
objacc.DC = row["DC"].ToString();
objacc.Account = row["Account"].ToString();
objacc.LedgerId = objAccBL.GetLedgerIdByAccountName(row["Account"].ToString());
objacc.Debit = Convert.ToDecimal(row["Debit"].ToString() == string.Empty ? "0.00" : row["Debit"].ToString());
objacc.Credit = Convert.ToDecimal(row["Credit"].ToString() == string.Empty ? "0.00" : row["Credit"].ToString());
objacc.Narration = row["Narration"].ToString() == null ? string.Empty : row["Narration"].ToString();
objacc.ParentId = Convert.ToInt32(row["ParentId"].ToString() == string.Empty ? "0" : row["ParentId"].ToString());
objacc.AC_Id = Convert.ToInt32(row["AC_Id"].ToString() == string.Empty ? "0" : row["AC_Id"].ToString());
lstAccounts.Add(objacc);
}
objcontra.ContraAccountModel = lstAccounts;
objcontra.CV_Id = Contra_Id;
bool isSuccess = objconBL.UpdateContraVoucher(objcontra);
if (isSuccess)
{
MessageBox.Show("Update Successfully!");
Contra_Id = 0;
ClearFormValues();
Transaction.List.ContraVouchersList frmList = new Transaction.List.ContraVouchersList();
frmList.StartPosition = FormStartPosition.CenterScreen;
frmList.ShowDialog();
FillContraVoucherInfo();
}
}
public List <ContraVoucherModel> GetCreditNotebyId(int id)
{
List <ContraVoucherModel> lstCredit = new List <ContraVoucherModel>();
ContraVoucherModel objcontra;
string Query = "SELECT * FROM Contra_Voucher WHERE Contra_Id=" + id;
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objcontra = new ContraVoucherModel();
objcontra.CV_Id = DataFormat.GetInteger(dr["Contra_ID"]);
objcontra.Voucher_Series = dr["Series"].ToString();
objcontra.CV_Date = DataFormat.GetDateTime(dr["CV_Date"]);
objcontra.Voucher_Number = DataFormat.GetInteger(dr["VoucherNo"]);
objcontra.Type = dr["Type"].ToString();
if (dr["PDC_Date"].ToString() != "")
{
objcontra.PDCDate = Convert.ToDateTime(dr["PDC_Date"]);
}
//SELECT Credit Note Accounts
string itemQuery = "SELECT * FROM Contra_Voucher_Accounts WHERE Contra_Id=" + objcontra.CV_Id;
System.Data.IDataReader drAcc = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject());
objcontra.AccountModel = new List <AccountModel>();
AccountModel objAcc;
while (drAcc.Read())
{
objAcc = new AccountModel();
objAcc.AC_Id = Convert.ToInt32(drAcc["AC_Id"]);
objAcc.ParentId = DataFormat.GetInteger(drAcc["Contra_Id"]);
objAcc.DC = drAcc["DC"].ToString();
objAcc.Account = drAcc["Account"].ToString();
objAcc.Debit = Convert.ToDecimal(drAcc["Debit"]);
objAcc.Credit = Convert.ToDecimal(drAcc["Credit"]);
objAcc.Narration = drAcc["Narration"].ToString();
objcontra.AccountModel.Add(objAcc);
}
lstCredit.Add(objcontra);
}
return(lstCredit);
}
public int SaveContraVoucher(ContraVoucherModel objCon)
{
string Query = string.Empty;
int conid = 0;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Series", objCon.Voucher_Series));
paramCollection.Add(new DBParameter("@Date", objCon.CV_Date));
paramCollection.Add(new DBParameter("@Voucher_Number", objCon.Voucher_Number));
paramCollection.Add(new DBParameter("@Type", objCon.Type));
paramCollection.Add(new DBParameter("@PDDate", objCon.PDCDate));
paramCollection.Add(new DBParameter("@Long", objCon.LongNarration));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "INSERT INTO Contra_Voucher([Series],[CV_Date],[VoucherNo],[Type],[PDC_Date],[LongNarration]" +
"[CreatedBy],[CreatedDate]) VALUES " +
"(@Series,@Date,@Voucher_Number,@Type,@PDDate,@Long " +
" @CreatedBy,@CreatedDate)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
SaveAcconuts(objCon.AccountModel);
conid = GetContraId();
}
}
catch (Exception ex)
{
conid = 0;
throw ex;
}
return(conid);
}
//Save Contara Voucher main
public bool SaveContraVoucher(ContraVoucherModel objCon)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@VoucherNumber", objCon.Voucher_Number));
paramCollection.Add(new DBParameter("@Series", objCon.Voucher_Series));
paramCollection.Add(new DBParameter("@CVDate", objCon.CV_Date, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@Type", objCon.Type));
paramCollection.Add(new DBParameter("@PDCDate", objCon.PDCDate, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@LongNarration", objCon.LongNarration));
paramCollection.Add(new DBParameter("@TotalCreditAmount", objCon.TotalCreditAmount, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@TotalDebitAmount", objCon.TotalDebitAmount, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", ""));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spInsertContraMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
long id = 0;
dr.Read();
id = Convert.ToInt32(dr[0]);
SaveContraAcconuts(objCon.ContraAccountModel, id);
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
public bool UpdateContraVoucher(ContraVoucherModel objContra)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
//UPDATE CONTRA TABLE - PARENT TABLE
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Series", objContra.Voucher_Series));
paramCollection.Add(new DBParameter("@Date", objContra.CV_Date));
paramCollection.Add(new DBParameter("@Voucher_Number", objContra.Voucher_Number));
paramCollection.Add(new DBParameter("@Type", objContra.Type));
paramCollection.Add(new DBParameter("@PDDate", objContra.PDCDate));
//paramCollection.Add(new DBParameter("@TotalCreditAmt", "0"));
//paramCollection.Add(new DBParameter("@TotalDebitAmt", "0"));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now));
paramCollection.Add(new DBParameter("@id", objContra.CV_Id));
Query = "UPDATE Contra_Voucher SET [Series]=@Series,[CV_Date]=@Date,[VoucherNo]=@Voucher_Number," +
"[Type]=@Type,[PDC_Date]=@PDDate,[ModifiedBy]=@ModifiedBy," +
"[ModifiedDate]=@ModifiedDate " +
"WHERE Contra_Id=@id";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
List <AccountModel> lstAcct = new List <AccountModel>();
//UPDATE CREDIT NOTE ACCOUNT -CHILD TABLE UPDATES
foreach (AccountModel act in objContra.AccountModel)
{
if (act.AC_Id > 0)
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@DC", (act.DC)));
paramCollection.Add(new DBParameter("@Account", act.Account));
paramCollection.Add(new DBParameter("@Debit", act.Debit));
paramCollection.Add(new DBParameter("@Credit", act.Credit));
paramCollection.Add(new DBParameter("@Narration", act.Narration));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now));
paramCollection.Add(new DBParameter("@ACT_ID", act.AC_Id));
Query = "UPDATE Contra_Voucher_Accounts SET [DC]=@DC," +
"[Account]=@Account,[Debit]=@Debit,[Credit]=@Credit,[Narration]=@Narration,[ModifiedBy]=@ModifiedBy,[ModifiedDate]=@ModifiedDate " +
"WHERE [AC_Id]=@ACT_ID";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
else
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@CN_ID", (act.ParentId)));
paramCollection.Add(new DBParameter("@DC", (act.DC)));
paramCollection.Add(new DBParameter("@Account", act.Account));
paramCollection.Add(new DBParameter("@Debit", act.Debit));
paramCollection.Add(new DBParameter("@Credit", act.Credit));
paramCollection.Add(new DBParameter("@Narration", act.Narration));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "INSERT INTO Contra_Voucher_Accounts([Contra_Id],[DC],[Account],[Debit],[Credit]," +
"[Narration],[CreatedBy],[CreatedDate]) VALUES " +
"(@CN_ID,@DC,@Account,@Debit,@Credit,@Narration,@CreatedBy,@CreatedDate)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
}
;
}
}
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}
//Update Contra Voucher
public bool UpdateContraVoucher(ContraVoucherModel objContra)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
//UPDATE CONTRA TABLE - PARENT TABLE
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Series", objContra.Voucher_Series));
paramCollection.Add(new DBParameter("@Date", objContra.CV_Date));
paramCollection.Add(new DBParameter("@VoucherNumber", objContra.Voucher_Number));
paramCollection.Add(new DBParameter("@Type", objContra.Type));
paramCollection.Add(new DBParameter("@CVDate", objContra.CV_Date, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@PDCDate", objContra.PDCDate, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@TotalCreditAmount", objContra.TotalCreditAmount, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@TotalDebitAmount", objContra.TotalDebitAmount, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@LongNarration", objContra.LongNarration));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@ContraId", objContra.CV_Id));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spUpdateContraMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
List <AccountModel> lstAcct = new List <AccountModel>();
//UPDATE Contra Voucher details
foreach (AccountModel act in objContra.ContraAccountModel)
{
act.ParentId = Convert.ToInt32(objContra.CV_Id);
if (act.AC_Id > 0)
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@DC", (act.DC)));
paramCollection.Add(new DBParameter("@Account", act.Account));
paramCollection.Add(new DBParameter("@LegderId", act.LedgerId));
paramCollection.Add(new DBParameter("@DebitAmount", act.Debit, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@CreditAmount", act.Credit, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@Narration", act.Narration));
paramCollection.Add(new DBParameter("@CreatedBy", ""));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@AccId", act.AC_Id));
paramCollection.Add(new DBParameter("@ContraId", act.ParentId));
System.Data.IDataReader acdr =
_dbHelper.ExecuteDataReader("spUpdateContraDetails", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
}
else
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@ContraID", act.ParentId));
paramCollection.Add(new DBParameter("@DC", (act.DC)));
paramCollection.Add(new DBParameter("@Account", act.Account));
paramCollection.Add(new DBParameter("@LegderId", act.LedgerId));
paramCollection.Add(new DBParameter("@DebitAmount", act.Debit, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@CreditAmount", act.Credit, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@Narration", act.Narration));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", ""));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime));
System.Data.IDataReader acdr =
_dbHelper.ExecuteDataReader("spInsertContraDetails", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
}
}
}
catch (Exception ex)
{
isUpdated = false;
//throw ex;
}
return(isUpdated);
}
