public List <ReceviedVoucherModel> GetReceviedVoucherbyId(int id)
{
List <ReceviedVoucherModel> lstRecevied = new List <ReceviedVoucherModel>();
ReceviedVoucherModel objRecevied;
string Query = "SELECT * FROM Recevied_Voucher WHERE Recevied_Id=" + id;
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objRecevied = new ReceviedVoucherModel();
objRecevied.RV_Id = DataFormat.GetInteger(dr["Recevied_ID"]);
objRecevied.Date = DataFormat.GetDateTime(dr["Recevied_Date"]);
objRecevied.Series = dr["Series"].ToString();
objRecevied.issuingoffice = dr["Issuing Office"].ToString();
objRecevied.fromNo = DataFormat.GetInteger(dr["FromNo"]);
objRecevied.party = dr["Party"].ToString();
objRecevied.issuedDate = DataFormat.GetDateTime(dr["DateOfIssue"]);
objRecevied.stateofissue = dr["StateOfIssue"].ToString();
objRecevied.Narration = dr["Narration"].ToString();
//SELECT Recevied Amount Voucher
string itemQuery = "SELECT * FROM Recevied_Amount_Voucher WHERE Recevied_Id=" + id;
System.Data.IDataReader drRec = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject());
objRecevied.ReceviedModel = new List <ReceviedModel>();
ReceviedModel objrec;
while (drRec.Read())
{
objrec = new ReceviedModel();
objrec.id = DataFormat.GetInteger(drRec["SNo"]);
objrec.ParentId = DataFormat.GetInteger(drRec["Recevied_ID"]);
objrec.VoucherNo = DataFormat.GetInteger(drRec["VoucherNo"]);
objrec.Dated = drRec["Dated"].ToString();
objrec.Amount = Convert.ToDecimal(drRec["Amount"]);
objRecevied.ReceviedModel.Add(objrec);
}
lstRecevied.Add(objRecevied);
}
return(lstRecevied);
}
public List <IssuedVoucherModel> GetIssuedVouchertbyId(int id)
{
List <IssuedVoucherModel> lstIssued = new List <IssuedVoucherModel>();
IssuedVoucherModel objIssued;
string Query = "SELECT * FROM Issued_Voucher WHERE Issued_Id=" + id;
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objIssued = new IssuedVoucherModel();
objIssued.IV_Id = DataFormat.GetInteger(dr["Issued_Id"]);
objIssued.Date = DataFormat.GetDateTime(dr["Issued_Date"]);
objIssued.From = dr["From"].ToString();
objIssued.Authourity = dr["Rcvd Authourity"].ToString();
objIssued.fromNo = DataFormat.GetInteger(dr["FromNo"]);
objIssued.party = dr["Party"].ToString();
objIssued.Narration = dr["Narration"].ToString();
//SELECT Recevied Amount Voucher
string itemQuery = "SELECT * FROM Issued_Amount_Voucher WHERE Issued_Id=" + id;
System.Data.IDataReader drRec = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject());
objIssued.ReceviedModel = new List <ReceviedModel>();
ReceviedModel objiss;
while (drRec.Read())
{
objiss = new ReceviedModel();
objiss.id = DataFormat.GetInteger(drRec["SNo"]);
objiss.ParentId = DataFormat.GetInteger(drRec["Issued_ID"]);
objiss.VoucherNo = DataFormat.GetInteger(drRec["VoucherNo"]);
objiss.Dated = drRec["Dated"].ToString();
objiss.Amount = Convert.ToDecimal(drRec["Amount"]);
objiss.BillNo = DataFormat.GetInteger(drRec["PurchaseBillNo"]);
objiss.BillDate = drRec["PurchaseDate"].ToString();
objIssued.ReceviedModel.Add(objiss);
}
lstIssued.Add(objIssued);
}
return(lstIssued);
}
private void btnSave_Click(object sender, EventArgs e)
{
IssuedVoucherModel objissued = new IssuedVoucherModel();
//if (tbxVchNo.Text.Trim() == "")
//{
// MessageBox.Show("Voucher Number Can Not Be Blank!");
// return;
//}
objissued.Date = Convert.ToDateTime(dtDate.Text);
objissued.From = tbxForm.Text.Trim();
objissued.fromNo = Convert.ToInt32(tbxFormnumber.Text);
objissued.Authourity = Convert.ToDateTime(dtAuthority.Text.Trim());
objissued.party = tbxParty.Text.Trim();
objissued.Narration = tbxNarration.Text.Trim();
//objissued.TotalAmount = Convert.ToDecimal(Amount.SummaryItem.SummaryValue);
//objSales.TotalQty = Convert.ToInt32(Qty.SummaryItem.SummaryValue);
//Items
ReceviedModel objModel;
List <ReceviedModel> lstIssued = new List <ReceviedModel>();
for (int i = 0; i < gdvFormsIssued.DataRowCount; i++)
{
DataRow row = gdvFormsIssued.GetDataRow(i);
objModel = new ReceviedModel();
objModel.VoucherNo = Convert.ToInt32(row["VoucherNumber"]);
objModel.Dated = row["Dated"].ToString();
objModel.Amount = Convert.ToInt32(row["Amount"].ToString());
objModel.BillNo = Convert.ToInt32(row["Purchase Bill No"].ToString());
objModel.BillDate = Convert.ToInt32(row["Purchase Bill Date"].ToString());
lstIssued.Add(objModel);
}
objissued.ReceviedModel = lstIssued;
bool isSuccess = objibl.SaveIssuedVoucher(objissued);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
// Dialogs.PopUPDialog d = new Dialogs.PopUPDialog("Saved Successfully!");
// d.ShowDialog();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
ReceviedVoucherModel objissued = new ReceviedVoucherModel();
objissued.Date = Convert.ToDateTime(dtDate.Text);
objissued.form = tbxForm.Text.Trim();
objissued.fromNo = Convert.ToInt32(tbxFormNumber.Text);
objissued.Series = tbxSeries.Text.Trim();
objissued.issuingoffice = tbxIssingoffice.Text.Trim();
objissued.issuedDate = Convert.ToDateTime(dtDateIssue.Text);
objissued.Narration = tbxNarration.Text.Trim();
objissued.stateofissue = tbxStateIssue.Text.Trim();
objissued.party = tbxParty.Text.Trim();
//Form Recevied Details
ReceviedModel objModel;
List <ReceviedModel> lstIssued = new List <ReceviedModel>();
for (int i = 0; i < gdvFormsRcvd.DataRowCount; i++)
{
DataRow row = gdvFormsRcvd.GetDataRow(i);
objModel = new ReceviedModel();
objModel.VoucherNo = Convert.ToInt32(row["VoucherNumber"]);
objModel.Dated = row["Dated"].ToString();
objModel.Amount = Convert.ToInt32(row["Amount"].ToString());
lstIssued.Add(objModel);
}
objissued.ReceviedModel = lstIssued;
bool isSuccess = objrcvdbl.SaveReceviedVoucher(objissued);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
// Dialogs.PopUPDialog d = new Dialogs.PopUPDialog("Saved Successfully!");
// d.ShowDialog();
}
}
