public bool SaveIssuedVoucher(IssuedVoucherModel objIssued)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Date", objIssued.Date, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@Form", objIssued.From));
paramCollection.Add(new DBParameter("@FormNo", objIssued.fromNo));
paramCollection.Add(new DBParameter("@Authority", objIssued.Authourity, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@Party", objIssued.party));
paramCollection.Add(new DBParameter("@Narration", objIssued.Narration));
paramCollection.Add(new DBParameter("@TotalAmount", "0"));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spInsertFormIssuedMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
int id = 0;
dr.Read();
id = Convert.ToInt32(dr[0]);
SaveIssuedDetails(objIssued.ReceviedModel, id);
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
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();
}
}
public bool SaveIssuedVoucher(IssuedVoucherModel objIssued)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Date", objIssued.Date, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@From", objIssued.From));
paramCollection.Add(new DBParameter("@Authourity", objIssued.Authourity, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@FromNo", objIssued.fromNo));
paramCollection.Add(new DBParameter("@Party", objIssued.party));
paramCollection.Add(new DBParameter("@Narration", objIssued.Narration));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
//paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "INSERT INTO Issued_Voucher ([Issued_Date],[From],[Rcvd Authourity],[FromNo],[Party]," +
"[Narration],[CreatedBy]) VALUES " +
"(@Date,@From,@Authourity,@FromNo,@Party,@Narration," +
" @CreatedBy)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
SaveIssuedAccount(objIssued.ReceviedModel);
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
//Udate Reciept Voucher
public bool UpdateIssuedVoucher(IssuedVoucherModel objIssued)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
//UPDATE Issued Voucher - PARENT TABLE
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Date", objIssued.Date, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@From", objIssued.From));
paramCollection.Add(new DBParameter("@Authourity", objIssued.Authourity, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@FromNo", objIssued.fromNo));
paramCollection.Add(new DBParameter("@Party", objIssued.party));
paramCollection.Add(new DBParameter("@Narration", objIssued.Narration));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@id", objIssued.IV_Id));
//paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "UPDATE Issued_Voucher SET [Issued_Date]=@Date,[From]=@From,[Rcvd Authourity]=@Authourity," +
"[FromNo]=@FromNo,[Party]=@Party,[Narration]=@Narration," +
"[ModifiedBy]=@ModifiedBy " +
"WHERE Issued_Id=@id";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
List <ReceviedModel> lstAcct = new List <ReceviedModel>();
//UPDATE Issued Account -CHILD TABLE UPDATES
foreach (ReceviedModel iss in objIssued.ReceviedModel)
{
if (iss.id > 0)
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@VoucherNo", (iss.VoucherNo)));
paramCollection.Add(new DBParameter("@Dated", iss.Dated));
paramCollection.Add(new DBParameter("@Amount", iss.Amount));
paramCollection.Add(new DBParameter("@BillNo", iss.BillNo));
paramCollection.Add(new DBParameter("@BillDate", iss.BillDate));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
//paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now));
paramCollection.Add(new DBParameter("@ACT_ID", iss.id));
Query = "UPDATE Issued_Amount_Voucher SET [VoucherNo]=@VoucherNo," +
"[Dated]=@Dated,[Amount]=@Amount,[PurchaseBillNo]=@BillNo,[PurchaseDate]=@BillDate,[ModifiedBy]=@ModifiedBy " +
"WHERE [SNo]=@ACT_ID";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
else
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@ID", (objIssued.IV_Id)));
paramCollection.Add(new DBParameter("@VoucherNo", (iss.VoucherNo)));
paramCollection.Add(new DBParameter("@Dated", iss.Dated));
paramCollection.Add(new DBParameter("@amount", iss.Amount));
paramCollection.Add(new DBParameter("@BillNo", iss.BillNo));
paramCollection.Add(new DBParameter("@BillDate", iss.BillDate));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
//paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "INSERT INTO Issued_Amount_Voucher ([Issued_Id],[VoucherNo],[Dated],[Amount],[PurchaseBillNo],[PurchaseDate]," +
"[CreatedBy]) VALUES " +
"(@ID,@VoucherNo,@Dated,@amount,@BillNo,@BillDate,@CreatedBy)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
}
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}
