public bool UpdateSalesVoucher(UnassembleVoucherModel objassemble)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Series", objassemble.Series));
paramCollection.Add(new DBParameter("@Date", objassemble.UA_Date));
paramCollection.Add(new DBParameter("@VoucherNumber", objassemble.Voucher_Number));
paramCollection.Add(new DBParameter("@BomName", objassemble.BOM_Name));
paramCollection.Add(new DBParameter("@MatCentre1", objassemble.MatCenterIG));
paramCollection.Add(new DBParameter("@MatCentre2", objassemble.MatCenterIC));
paramCollection.Add(new DBParameter("@Narration", objassemble.Narration));
paramCollection.Add(new DBParameter("@TotalQty", objassemble.TotalAmountIG, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@TotalAmount", objassemble.TotalAmountIG, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@BSTotalAmount", objassemble.BSTotalAmount, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now));
paramCollection.Add(new DBParameter("@UassembleVoucher_ID", objassemble.UA_Id));
Query = "UPDATE Trans_Unassemble_Voucher SET [Series]=@Series,[UA_Date]=@Date," +
"[VoucherNo]=@VoucherNumber,[BOM_Name]=@BomName," +
"[MatCenter1]=@MatCentre1,[MatCenter2]=@MatCentre2," +
"[Narration]=@Narration,[TotalQty]=@TotalQty," +
"[TotalAmount]=@TotalAmount,[BSTotalAmount]=@BSTotalAmount," +
"[ModifiedBy]=@ModifiedBy,[ModifiedDate]=@ModifiedDate " +
"WHERE Unassemble_Id=@UassembleVoucher_ID;";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
//UpdateItemandBS(objassemble);
isUpdated = true;
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}
public bool SaveUnassembleVoucher(UnassembleVoucherModel objAssemble)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@VoucherNumber", objAssemble.Voucher_Number));
paramCollection.Add(new DBParameter("@Series", objAssemble.Series));
paramCollection.Add(new DBParameter("@Date", objAssemble.UA_Date, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@BOMName", objAssemble.BOM_Name));
paramCollection.Add(new DBParameter("@MatCentreIG", objAssemble.MatCenterIG));
paramCollection.Add(new DBParameter("@MatCentreIC", objAssemble.MatCenterIC));
paramCollection.Add(new DBParameter("@Narration", objAssemble.Narration));
//paramCollection.Add(new DBParameter("@ItemTotalAmount", objSales.TotalAmount));
//paramCollection.Add(new DBParameter("@ItemTotalQty", objSales.TotalQty));
//paramCollection.Add(new DBParameter("@BSTotalAmount", objSales.BSTotalAmount));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spInsertUnassembleMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
int id = 0;
dr.Read();
id = Convert.ToInt32(dr[0]);
SaveUnassembleItemgenerate(objAssemble.Item_Generated, id);
SaveUnassembleItemConsumed(objAssemble.Item_Consumed, id);
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
public bool SaveUnassembleVoucher(UnassembleVoucherModel objAssemble)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Series", objAssemble.Series));
paramCollection.Add(new DBParameter("@AssembleDate", objAssemble.UA_Date));
paramCollection.Add(new DBParameter("@VoucherNumber", objAssemble.Voucher_Number));
paramCollection.Add(new DBParameter("@MatCenter1", objAssemble.MatCenter1));
paramCollection.Add(new DBParameter("@MatCenter2", objAssemble.MatCenter2));
paramCollection.Add(new DBParameter("@Narration", objAssemble.Narration));
paramCollection.Add(new DBParameter("@TotalQty", objAssemble.TotalQty));
paramCollection.Add(new DBParameter("@TotalAmount", objAssemble.TotalAmount));
paramCollection.Add(new DBParameter("@BSTotalAmount", objAssemble.BSTotalAmount));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "INSERT INTO Trans_Unassemble_Voucher ([Series],[UA_Date],[VoucherNo],[MatCenter1]," +
"[MatCenter2],[Narration],[TotalQty],[TotalAmount],[BSTotalAmount],[CreatedBy],[CreatedDate]) VALUES " +
"(@Series,@AssembleDate,@VoucherNumber,@MatCenter1,@MatCenter2,@Narration,@TotalQty,@TotalAmount,@BSTotalAmount,@CreatedBy,@CreatedDate)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
SaveUnassembleItems(objAssemble.AssembleItem_Voucher);
SaveUnassembleBillSundry(objAssemble.AssembleBillSundry_Voucher);
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
private bool UpdateItemandBS(UnassembleVoucherModel objassemble)
{
try
{
//UPDATE Item voucher -CHILD TABLE UPDATES
foreach (Item_VoucherModel item in objassemble.AssembleItem_Voucher)
{
if (item.Item_ID > 0)
{
UpdateUnassembleVoucherItems(item);
}
else
{
SaveUnassembleVoucherItem(item);
}
}
//Update Bill Sundry Items
foreach (BillSundry_VoucherModel bs in objassemble.AssembleBillSundry_Voucher)
{
if (bs.BSId > 0)
{
UpdateUnassembleBillSundryVoucher(bs);
}
else
{
SaveUnassembleVoucherBillSundryVoucher(bs);
}
}
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public UnassembleVoucherModel GetAllUnassemblebyId(int id)
{
UnassembleVoucherModel objassemble = new UnassembleVoucherModel();
string Query = "SELECT * FROM Trans_Unassemble_Voucher WHERE Unassemble_Id=" + id;
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objassemble.UA_Id = Convert.ToInt32(dr["Unassemble_Id"]);
objassemble.Series = dr["series"].ToString();
objassemble.UA_Date = DataFormat.GetDateTime(dr["UA_Date"]);
objassemble.Voucher_Number = DataFormat.GetInteger(dr["VoucherNo"]);
objassemble.BOM_Name = dr["BOM_Name"].ToString();
objassemble.MatCenterIG = dr["MatCenter1"].ToString();
objassemble.MatCenterIC = dr["MatCenter2"].ToString();
objassemble.Narration = dr["Narration"].ToString();
objassemble.TotalQtyIG = Convert.ToDecimal(dr["TotalQty"]);
objassemble.TotalAmountIG = Convert.ToDecimal(dr["TotalAmount"].ToString());
objassemble.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]);
//SELECT Credit Note Accounts
string itemQuery = "SELECT * FROM Trans_Unassemble_Items WHERE Unassemble_Id=" + id;
System.Data.IDataReader drItems = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject());
//objassemble.AssembleItem_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["Unassemble_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());
//objassemble.AssembleItem_Voucher.Add(objitem);
}
string BSQuery = "SELECT * FROM Trans_Unassemble_BS WHERE Unassemble_Id=" + id;
System.Data.IDataReader drbs = _dbHelper.ExecuteDataReader(BSQuery, _dbHelper.GetConnObject());
//objassemble.AssembleBillSundry_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["Unassemble_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());
//objassemble.AssembleBillSundry_Voucher.Add(objbs);
}
}
return(objassemble);
}
