public bool UpdateMatIssueVoucher(MatRcvdModel objMatRcvd)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Series", objMatRcvd.Series));
paramCollection.Add(new DBParameter("@Date", objMatRcvd.Rcvd_Date));
paramCollection.Add(new DBParameter("@VoucherNumber", objMatRcvd.Voucher_Number));
paramCollection.Add(new DBParameter("@Type", objMatRcvd.type));
paramCollection.Add(new DBParameter("@Party", objMatRcvd.Party));
paramCollection.Add(new DBParameter("@MatCentre", objMatRcvd.MatCenter));
paramCollection.Add(new DBParameter("@Narration", objMatRcvd.Narration));
paramCollection.Add(new DBParameter("@qty", objMatRcvd.TotalQty));
paramCollection.Add(new DBParameter("@amount", objMatRcvd.TotalAmount));
paramCollection.Add(new DBParameter("@bsamount", objMatRcvd.BSTotalAmount));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@id", objMatRcvd.Rcvd_Id));
Query = "UPDATE Trans_MatRcvd_Voucher SET [Series]=@Series,[Rcvd_Date]=@Date," +
"[VoucherNo]=@VoucherNumber,[Type]=@Type," +
"[Party]=@Party,[MatCentre]=@MatCentre," +
"[Narration]=@Narration,[TotalQty]=@qty,[TotalAmount]=@amount,[BSTotalAmount]=@bsamount,[ModifiedBy]=@ModifiedBy " +
"WHERE [MatRcvd_Id]=@id ";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
UpdateItemandBS(objMatRcvd);
isUpdated = true;
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}
public bool SaveMatRcvdVoucher(MatRcvdModel objrcvd)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Series", objrcvd.Series));
paramCollection.Add(new DBParameter("@Voucher_Date", objrcvd.Rcvd_Date));
paramCollection.Add(new DBParameter("@Voucher_Number", objrcvd.Voucher_Number));
paramCollection.Add(new DBParameter("@Type", objrcvd.type));
paramCollection.Add(new DBParameter("@Party", objrcvd.Party));
paramCollection.Add(new DBParameter("@MatCenter", objrcvd.MatCenter));
paramCollection.Add(new DBParameter("@Narration", objrcvd.Narration));
paramCollection.Add(new DBParameter("@TotalQty", objrcvd.TotalQty));
paramCollection.Add(new DBParameter("@TotalAmount", objrcvd.TotalAmount));
paramCollection.Add(new DBParameter("@BSTotal", objrcvd.BSTotalAmount));
paramCollection.Add(new DBParameter("@CreatedBy", objrcvd.CreatedBy));
Query = "INSERT INTO Trans_MatRcvd_Voucher ([Series],[Rcvd_Date],[VoucherNo],[Type],[Party],[MatCentre],[Narration],[TotalQty],[TotalAmount],[BSTotalAmount]," +
"[CreatedBy]) VALUES " +
"(@Series,@Voucher_Date,@Voucher_Number,@Type,@Party," +
"@MatCenter,@Narration,@TotalQty,@TotalAmount,@BSTotal,@CreatedBy)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
SaveMatRcvdItems(objrcvd.RcvdItem_Voucher);
SaveMatRcvdBillSundry(objrcvd.RcvdBillSundry_Voucher);
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
public bool SaveMatRcvdVoucher(MatRcvdModel objrcvd)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@VoucherNumber", objrcvd.Voucher_Number));
paramCollection.Add(new DBParameter("@Series", objrcvd.Series));
paramCollection.Add(new DBParameter("@MatRcvdDate", objrcvd.Rcvd_Date, System.Data.DbType.DateTime));
//paramCollection.Add(new DBParameter("@BillNo", objSales.BillNo));
//paramCollection.Add(new DBParameter("@DueDate", objSales.DueDate));
paramCollection.Add(new DBParameter("@MatRcvdType", objrcvd.Type));
paramCollection.Add(new DBParameter("@MatRcvdParty", objrcvd.Party));
paramCollection.Add(new DBParameter("@MatCentre", objrcvd.MatCenter));
paramCollection.Add(new DBParameter("@Narration", objrcvd.Narration));
paramCollection.Add(new DBParameter("@ItemTotalAmount", objrcvd.TotalAmount));
paramCollection.Add(new DBParameter("@ItemTotalQty", objrcvd.TotalQty));
paramCollection.Add(new DBParameter("@BSTotalAmount", objrcvd.BSTotalAmount));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spInsertMatRcvddMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
int id = 0;
dr.Read();
id = Convert.ToInt32(dr[0]);
SaveMatRcvdItems(objrcvd.RcvdItem_Voucher, id);
SaveMatRcvdBillSundry(objrcvd.RcvdBillSundry_Voucher, id);
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
private bool UpdateItemandBS(MatRcvdModel objmat)
{
try
{
//UPDATE Item voucher -CHILD TABLE UPDATES
foreach (Item_VoucherModel item in objmat.RcvdItem_Voucher)
{
if (item.Item_ID > 0)
{
UpdateMatRcvdItems(item);
}
else
{
SaveMatRcvdPartyItems(item);
}
}
//Update Bill Sundry Items
foreach (BillSundry_VoucherModel bs in objmat.RcvdBillSundry_Voucher)
{
if (bs.BSId > 0)
{
SaveMatRcvdPartyItems(bs);
}
else
{
SaveMatRcvdPartyBillSundryVoucher(bs);
}
}
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public MatRcvdModel GetAllMatRcvdbyId(int id)
{
MatRcvdModel objMatRcvd = new MatRcvdModel();
string Query = "SELECT * FROM Trans_MatRcvd_Voucher WHERE MatRcvd_Id=" + id;
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objMatRcvd.Rcvd_Id = Convert.ToInt32(dr["Matrcvd_Id"]);
objMatRcvd.Series = dr["series"].ToString();
objMatRcvd.Rcvd_Date = DataFormat.GetDateTime(dr["Rcvd_Date"]);
objMatRcvd.Voucher_Number = DataFormat.GetInteger(dr["VoucherNo"]);
objMatRcvd.type = dr["Type"].ToString();
objMatRcvd.Party = dr["party"].ToString();
objMatRcvd.MatCenter = dr["MatCentre"].ToString();
objMatRcvd.Narration = dr["Narration"].ToString();
objMatRcvd.TotalQty = Convert.ToDecimal(dr["TotalQty"]);
objMatRcvd.TotalAmount = Convert.ToDecimal(dr["TotalAmount"].ToString());
objMatRcvd.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]);
//SELECT Credit Note Accounts
string itemQuery = "SELECT * FROM Trans_MatRcvd_Items WHERE MatRcvd_Id=" + id;
System.Data.IDataReader drItems = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject());
objMatRcvd.RcvdItem_Voucher = new List <Item_VoucherModel>();
Item_VoucherModel objitem;
while (drItems.Read())
{
objitem = new Item_VoucherModel();
objitem.Item_ID = Convert.ToInt32(drItems["ItemId"]);
objitem.ParentId = DataFormat.GetInteger(drItems["MatRcvd_Id"]);
objitem.Item = drItems["item"].ToString();
objitem.Batch = drItems["Batch"].ToString();
objitem.Qty = Convert.ToInt32(drItems["qty"].ToString());
objitem.Unit = (drItems["unit"].ToString());
objitem.Price = Convert.ToDecimal(drItems["price"]);
objitem.Amount = Convert.ToInt32(drItems["amount"].ToString());
objitem.TotalAmount = Convert.ToDecimal(drItems["TotalAmount"]);
objitem.TotalQty = Convert.ToInt32(drItems["TotalQty"].ToString());
objMatRcvd.RcvdItem_Voucher.Add(objitem);
}
string BSQuery = "SELECT * FROM Trans_MatRcvd_BS WHERE MatRcvd_Id=" + id;
System.Data.IDataReader drbs = _dbHelper.ExecuteDataReader(BSQuery, _dbHelper.GetConnObject());
objMatRcvd.RcvdBillSundry_Voucher = new List <BillSundry_VoucherModel>();
BillSundry_VoucherModel objbs;
while (drbs.Read())
{
objbs = new BillSundry_VoucherModel();
objbs.BSId = Convert.ToInt32(drbs["BSId"]);
objbs.ParentId = DataFormat.GetInteger(drbs["MatRcvd_Id"]);
objbs.BillSundry = drbs["BillSundry"].ToString();
objbs.Percentage = Convert.ToDecimal(drbs["Percentage"].ToString());
objbs.Amount = Convert.ToDecimal((drbs["Amount"].ToString()));
objbs.TotalAmount = Convert.ToDecimal(drbs["TotalAmount"].ToString());
objMatRcvd.RcvdBillSundry_Voucher.Add(objbs);
}
}
return(objMatRcvd);
}
private void btnSave_Click(object sender, EventArgs e)
{
eSunSpeedDomain.MatRcvdModel objrcvd = new MatRcvdModel();
if (tbxVchNumber.Text.Trim() == "")
{
MessageBox.Show("Voucher Number Can Not Be Blank!");
return;
}
objrcvd.Series = tbxSeries.Text.Trim();
objrcvd.Type = tbxType.Text.Trim();
objrcvd.Rcvd_Date = Convert.ToDateTime(dtDate.Text);
objrcvd.Voucher_Number = Convert.ToInt32(tbxVchNumber.Text.Trim());
objrcvd.Party = tbxParty.Text.Trim();
objrcvd.MatCenter = tbxVchNumber.Text.Trim();
objrcvd.Narration = tbxNarration.Text.Trim();
objrcvd.TotalAmount = Convert.ToDecimal(Amount.SummaryItem.SummaryValue);
objrcvd.TotalQty = Convert.ToInt32(Qty.SummaryItem.SummaryValue);
//MatRcvd Items
Item_VoucherModel objItem;
List <Item_VoucherModel> lstItems = new List <Item_VoucherModel>();
for (int i = 0; i < gdvItem.DataRowCount; i++)
{
DataRow row = gdvItem.GetDataRow(i);
objItem = new Item_VoucherModel();
objItem.Item = row["Item"].ToString();
objItem.Qty = Convert.ToDecimal(row["Qty"]);
objItem.Unit = row["Unit"].ToString();
objItem.Amount = Convert.ToDecimal(row["Amount"].ToString());
objItem.Price = Convert.ToDecimal(row["Price"].ToString());
lstItems.Add(objItem);
}
objrcvd.RcvdItem_Voucher = lstItems;
//Bill Sundry
BillSundry_VoucherModel objBS;
List <BillSundry_VoucherModel> lstBS = new List <BillSundry_VoucherModel>();
for (int i = 0; i < gridBs.DataRowCount; i++)
{
DataRow row = gridBs.GetDataRow(i);
objBS = new BillSundry_VoucherModel();
objBS.BillSundry = row["BillSundry"].ToString();
objBS.Narration = row["Narration"].ToString();
objBS.Percentage = Convert.ToDecimal(row["Percentage"]);
objBS.Amount = Convert.ToDecimal(row["Amount"]);
objBS.Type = row["Extra"].ToString();
lstBS.Add(objBS);
}
objrcvd.BSTotalAmount = Convert.ToDecimal(BSAmount.SummaryItem.SummaryValue);
objrcvd.RcvdBillSundry_Voucher = lstBS;
bool isSuccess = objMRBL.SaveMatRcvdVoucher(objrcvd);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
// Dialogs.PopUPDialog d = new Dialogs.PopUPDialog("Saved Successfully!");
// d.ShowDialog();
}
}
