public bool UpdatePurchaseReturnItems(Item_VoucherModel objPRItem)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Purchase_Item", objPRItem.Item));
paramCollection.Add(new DBParameter("@Purchase_batch", objPRItem.Batch));
paramCollection.Add(new DBParameter("@Purchase_Qty", objPRItem.Qty, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@Purchase_Unit", objPRItem.Unit));
paramCollection.Add(new DBParameter("@Purchase_Price", objPRItem.Price, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@Purchase_Amount", objPRItem.Amount, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@TotalQty", objPRItem.TotalQty, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@TotalAmount", objPRItem.TotalAmount, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
//paramCollection.Add(new DBParameter("@ModifiedDate",DateTime.Now));
paramCollection.Add(new DBParameter("@PurchaseId", objPRItem.ParentId));
paramCollection.Add(new DBParameter("@ItemId", objPRItem.Item_ID));
Query = "UPDATE Trans_PR_Items SET [Item]=@Purchase_Item,[Batch]=@Purchase_batch,[Qty]=@Purchase_Qty,[Unit]=@Purchase_Unit," +
"[Price]=@Purchase_Price,[Amount]=@Purchase_Amount,[TotalQty]=@TotalQty,[TotalAmount]=@TotalAmount,[ModifiedBy]=@ModifiedBy " +
"WHERE transPRId=@PurchaseId AND [ItemId]=@ItemId";
//Query = "UPDATE Trans_PR_Items SET [Item]=@Purchase_Item,[Batch]=@Purchase_batch,[Qty]=@Purchase_Qty,[Unit]=@Purchase_Unit," +
//"[Price]=@Purchase_Price,[Amount]=@Purchase_Amount,[TotalQty]=@TotalQty,[TotalAmount]=@TotalAmount,[ModifiedBy]=@ModifiedBy,[ModifiedDate]=@ModifiedDate " +
//"WHERE transPRId=@PurchaseId AND [ItemId]=@ItemId";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}
//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 bool UpdateUnassembleVoucherItems(Item_VoucherModel objItems)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Item", objItems.Item));
paramCollection.Add(new DBParameter("@Batch", objItems.Batch));
paramCollection.Add(new DBParameter("@Qty", objItems.Qty, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@Unit", objItems.Unit));
paramCollection.Add(new DBParameter("@Price", objItems.Price, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@Amount", objItems.Amount, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@TotalQty", objItems.TotalQty, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@TotalAmount", objItems.TotalAmount, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now));
paramCollection.Add(new DBParameter("@Voucher_ID", objItems.ParentId));
paramCollection.Add(new DBParameter("@ItemId", objItems.Item_ID));
Query = "UPDATE Trans_Unassemble_Items SET [Item]=@Item,[Batch]=@Batch,[Qty]=@Qty,[Unit]=@Unit," +
"[Price]=@Price,[Amount]=@Amount,[TotalQty]=@TotalQty,[TotalAmount]=@TotalAmount,[ModifiedBy]=@ModifiedBy,[ModifiedDate]=@ModifiedDate " +
"WHERE Unassemble_ID=@Voucher_ID AND [ItemId]=@ItemId";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}
public bool UpdateSalesVoucherItems(Item_VoucherModel objSalesItem)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Sales_Item", objSalesItem.Item));
paramCollection.Add(new DBParameter("@Sales_Qty", objSalesItem.Qty, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@Sales_Unit", objSalesItem.Unit));
paramCollection.Add(new DBParameter("@Sales_Price", objSalesItem.Price, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@Sales_Amount", objSalesItem.Amount, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@TotalQty", objSalesItem.TotalQty, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@TotalAmount", objSalesItem.TotalAmount, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@ModifiedBy", objSalesItem.ModifiedBy));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now));
paramCollection.Add(new DBParameter("@SalesVoucher_ID", objSalesItem.ParentId));
paramCollection.Add(new DBParameter("@ItemId", objSalesItem.Item_ID));
Query = "UPDATE Trans_Sales_Item SET [Item]=@Sales_Item,[Qty]=@Sales_Qty,[Unit]=@Sales_Unit," +
"[Price]=@Sales_Price,[Amount]=@Sales_Amount,[TotalQty]=@TotalQty,[TotalAmount]=@TotalAmount,[ModifiedBy]=@ModifiedBy,[ModifiedDate]=@ModifiedDate " +
"WHERE SalesVoucher_ID=@SalesVoucher_ID AND [ItemId]=@ItemId";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}
public bool SaveUnassembleVoucherItem(Item_VoucherModel item)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@UAVoucher_ID", item.ParentId));
paramCollection.Add(new DBParameter("@UA_Item", item.Item));
paramCollection.Add(new DBParameter("@UA_Batch", item.Batch));
paramCollection.Add(new DBParameter("@UA_Qty", item.Qty));
paramCollection.Add(new DBParameter("@UA_Unit", item.Unit));
paramCollection.Add(new DBParameter("@UA_Price", item.Price));
paramCollection.Add(new DBParameter("@UA_Amount", item.Amount));
paramCollection.Add(new DBParameter("@TotalQty", item.TotalQty));
paramCollection.Add(new DBParameter("@TotalAmount", item.TotalAmount));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "INSERT INTO Trans_Unassemble_Items ([Unassemble_Id],[Item],[Batch],[Qty],[Unit]," +
"[Price],[Amount],[TotalQty],[TotalAmount],[CreatedBy],[CreatedDate]) VALUES" +
"(@UAVoucher_ID,@UA_Item,@UA_Batch,@UA_Qty,@UA_Unit,@UA_Price,@UA_Amount,@TotalQty,@TotalAmount,@CreatedBy,@CreatedDate)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
public bool SaveProductionVoucherItems(Item_VoucherModel lstItems)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@PV_ID", (lstItems.ParentId)));
paramCollection.Add(new DBParameter("@Item", lstItems.Item));
paramCollection.Add(new DBParameter("@Batch", lstItems.Batch));
paramCollection.Add(new DBParameter("@Qty", lstItems.Qty));
paramCollection.Add(new DBParameter("@Unit", (lstItems.Unit)));
paramCollection.Add(new DBParameter("@Price", Convert.ToDecimal(lstItems.Price)));
paramCollection.Add(new DBParameter("@Amount", Convert.ToDecimal(lstItems.Amount)));
paramCollection.Add(new DBParameter("@TotalQty", lstItems.TotalQty));
paramCollection.Add(new DBParameter("@TotalAmount", Convert.ToDecimal(lstItems.TotalAmount)));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "INSERT INTO Trans_Production_Items([Production_Id],[Item],[Batch],[Qty],[Unit]," +
"[Price],[Amount],[TotalQty],[TotalAmount],[CreatedBy],[CreatedDate]) VALUES " +
"(@PV_ID,@Item,@Batch,@Qty,@Unit,@Price,@Amount,@TotalQty,@TotalAmount,@CreatedBy,@CreatedDate)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
public bool SaveStockTransferVoucherItem(Item_VoucherModel item)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@ST_ID", (item.ParentId)));
paramCollection.Add(new DBParameter("@Item", item.Item));
paramCollection.Add(new DBParameter("@Batch", item.Batch));
paramCollection.Add(new DBParameter("@Qty", item.Qty));
paramCollection.Add(new DBParameter("@Unit", (item.Unit)));
paramCollection.Add(new DBParameter("@Price", Convert.ToDecimal(item.Price)));
paramCollection.Add(new DBParameter("@Amount", Convert.ToDecimal(item.Amount)));
paramCollection.Add(new DBParameter("@TotalQty", item.TotalQty));
paramCollection.Add(new DBParameter("@TotalAmount", Convert.ToDecimal(item.TotalAmount)));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
//paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "INSERT INTO Stock_Transfer_Items ([Stock_Id],[Item],[Batch],[Qty],[Unit]," +
"[Price],[Amount],[TotalQty],[TotalAmount],[ModifiedBy]) VALUES " +
"(@ST_ID,@Item,@Batch,@Qty,@Unit,@Price,@Amount,@TotalQty,@TotalAmount,@ModifiedBy)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
public bool SavePurchaseItems(Item_VoucherModel lstitems)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Voucher_ID", Convert.ToInt32(lstitems.ParentId)));
paramCollection.Add(new DBParameter("@Item", lstitems.Item));
paramCollection.Add(new DBParameter("@Batch", lstitems.Batch));
paramCollection.Add(new DBParameter("@Qty", Convert.ToInt32(lstitems.Qty)));
paramCollection.Add(new DBParameter("@Unit", lstitems.Unit));
paramCollection.Add(new DBParameter("@Price", Convert.ToInt32(lstitems.Price)));
paramCollection.Add(new DBParameter("@Amount", Convert.ToInt32(lstitems.Amount)));
paramCollection.Add(new DBParameter("@TotalQty", Convert.ToInt32(lstitems.TotalQty)));
paramCollection.Add(new DBParameter("@TotalAmount", Convert.ToInt32(lstitems.TotalAmount)));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
Query = "INSERT INTO Trans_PV_Items([TransPVId],[Item],[Batch],[Qty],[Unit]," +
"[Price],[Amount],[TotalQty],[TotalAmount],[ModifiedBy]) VALUES " +
"(@Voucher_ID,@Item,@Batch,@Qty,@Unit,@Price,@Amount,@TotalQty,@TotalAmount,@ModifiedBy)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
public bool SavePurchaseVoucherItems(Item_VoucherModel objItem)
{
string Query = string.Empty;
bool isSaved = true;
objItem.ParentId = GetPurchaseVoucherId();
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@PurchaseVoucher_ID", objItem.ParentId));
paramCollection.Add(new DBParameter("@Purchase_Item", objItem.Item));
paramCollection.Add(new DBParameter("@Purchase_Qty", objItem.Qty));
paramCollection.Add(new DBParameter("@Purchase_Unit", objItem.Qty));
paramCollection.Add(new DBParameter("@Purchase_Price", objItem.Price));
paramCollection.Add(new DBParameter("@Purchase_Amount", objItem.Amount));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
Query = "INSERT INTO PurchaseItem_Voucher([PurchaseVoucher_ID],[Purchase_Item],[Purchase_Qty],[Purchase_Unit]," +
"[Purchase_Price],[Purchase_Amount],[CreatedBy]) VALUES " +
"(@PurchaseVoucher_ID,@Purchase_Item,@Purchase_Qty,@Purchase_Unit,@Purchase_Price,@Purchase_Amount,@CreatedBy)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
public List <StockTransferModel> GetAllStockTransfer()
{
List <StockTransferModel> lstST = new List <StockTransferModel>();
StockTransferModel objstock;
string Query = "SELECT * FROM Stock_Transfer_Voucher";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objstock = new StockTransferModel();
objstock.ST_Id = DataFormat.GetInteger(dr["ST_Id"]);
objstock.Series = dr["Series"].ToString();
objstock.SalesType = dr["SalesType"].ToString();
objstock.ST_Date = DataFormat.GetDateTime(dr["ST_Date"]);
objstock.Voucher_Number = DataFormat.GetInteger(dr["VoucherNo"]);
objstock.BillNo = Convert.ToInt32(dr["BillNo"]);
objstock.Party = dr["Party"].ToString();
objstock.MatCenter = dr["MatCentre"].ToString();
objstock.Narration = dr["Narration"].ToString();
//objsales. = Convert.ToDecimal(dr["TotalQty"]);
//objsales.TotalAmount = Convert.ToDecimal(dr["TotalAmount"]);
//objsales.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]);
//SELECT ST Items
string itemQuery = "SELECT * FROM Stock_Transfer_Items WHERE Stock_Id=" + objstock.ST_Id;
System.Data.IDataReader drItem = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject());
objstock.StockItem_Voucher = new List <Item_VoucherModel>();
Item_VoucherModel objItemModel;
while (drItem.Read())
{
objItemModel = new Item_VoucherModel();
objItemModel.ParentId = DataFormat.GetInteger(drItem["StockId"]);
objItemModel.Item_ID = DataFormat.GetInteger(drItem["ItemId"]);
objItemModel.Item = drItem["Item"].ToString();
objItemModel.Price = Convert.ToDecimal(drItem["Price"]);
objItemModel.Qty = Convert.ToDecimal(drItem["Qty"]);
objItemModel.Unit = drItem["Unit"].ToString();
objItemModel.Amount = Convert.ToDecimal(drItem["Amount"]);
objItemModel.TotalQty = Convert.ToDecimal(drItem["TotalQty"]);
objItemModel.TotalAmount = Convert.ToDecimal(drItem["TotalAmount"]);
objstock.StockItem_Voucher.Add(objItemModel);
}
//SELECT Bill Sundry Voucher items
string bsQuery = "SELECT * FROM Trans_SalesReturn_BS WHERE StockId=" + objstock.ST_Id;
System.Data.IDataReader drBS = _dbHelper.ExecuteDataReader(bsQuery, _dbHelper.GetConnObject());
objstock.StockBillSundry_Voucher = new List <BillSundry_VoucherModel>();
BillSundry_VoucherModel objBSModel;
while (drBS.Read())
{
objBSModel = new BillSundry_VoucherModel();
objBSModel.ParentId = DataFormat.GetInteger(drBS["StockId"]);
objBSModel.BSId = DataFormat.GetInteger(drBS["BSId"]);
objBSModel.BillSundry = drBS["BillSundry"].ToString();
objBSModel.Percentage = Convert.ToDecimal(drBS["Percentage"]);
objBSModel.Amount = Convert.ToDecimal(drBS["Amount"]);
objBSModel.TotalAmount = Convert.ToDecimal(drBS["TotalAmount"]);
objstock.StockBillSundry_Voucher.Add(objBSModel);
}
lstST.Add(objstock);
}
return(lstST);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
TransSalesModel objSaleVch = new TransSalesModel();
if (tbxVoucherNumber.Text.Trim() == "")
{
MessageBox.Show("Voucher Number Can Not Be Blank!");
return;
}
objSaleVch.VoucherType = tbxVoucherType.Text.Trim();
objSaleVch.SaleDate = Convert.ToDateTime(dtDate.Text);
objSaleVch.Terms = cbxTerms.SelectedItem.ToString();
objSaleVch.VoucherNumber = Convert.ToInt64(tbxVoucherNumber.Text.Trim() == string.Empty ? "0" : tbxVoucherNumber.Text.Trim());
objSaleVch.BillNo = Convert.ToInt64(tbxBillNo.Text.Trim() == string.Empty ? "0" : tbxBillNo.Text.Trim());
objSaleVch.LedgerId = objAccBL.GetLedgerIdByAccountName(tbxParty.Text.Trim());
objSaleVch.SalesType = tbxSaleType.Text.Trim();
objSaleVch.MatCentre = tbxMatcenter.Text.Trim() == null ? string.Empty : tbxMatcenter.Text.Trim();
objSaleVch.PriceList = cbxPriceList.Text.Trim() == null ? string.Empty : cbxPriceList.Text.Trim();
objSaleVch.Narration = tbxNarration.Text.Trim() == null ? string.Empty : tbxNarration.Text.Trim();
objSaleVch.TotalAmount = Convert.ToDecimal(Amount.SummaryItem.SummaryValue);
objSaleVch.TotalFree = Convert.ToDecimal(colFree.SummaryItem.SummaryValue);
objSaleVch.TotalBasicAmount = Convert.ToDecimal(colBasicAmt.SummaryItem.SummaryValue);
objSaleVch.TotalDisAmount = Convert.ToDecimal(colDisAmt.SummaryItem.SummaryValue);
objSaleVch.TotalTaxAmount = Convert.ToDecimal(colTaxAmont.SummaryItem.SummaryValue);
objSaleVch.TotalQty = Convert.ToDecimal(Qty.SummaryItem.SummaryValue);
objSaleVch.BSTotalAmount = Convert.ToDecimal(BSAmount.SummaryItem.SummaryValue);
//Items Details
Item_VoucherModel objSaleItem;
List <Item_VoucherModel> lstSaleItems = new List <Item_VoucherModel>();
for (int i = 0; i < dvgItemDetails.DataRowCount; i++)
{
DataRow row = dvgItemDetails.GetDataRow(i);
objSaleItem = new Item_VoucherModel();
objSaleItem.ITM_Id = objIMBL.GetItemIdByItemName(row["Item"].ToString() == null ? string.Empty : row["Item"].ToString());
objSaleItem.Qty = Convert.ToDecimal(row["Qty"].ToString() == string.Empty ? "0.00" : row["Qty"]);
objSaleItem.LedgerId = objAccBL.GetLedgerIdByAccountName(row["Particulars"].ToString() == null ? string.Empty : row["Particulars"].ToString());
objSaleItem.Unit = row["Unit"].ToString() == null ? string.Empty : row["Unit"].ToString();
objSaleItem.Per = row["Per"].ToString() == null ? string.Empty : row["Per"].ToString();
objSaleItem.Price = Convert.ToDecimal(row["Price"].ToString() == string.Empty ? "0.00" : row["Price"].ToString());
objSaleItem.Batch = row["Batch"].ToString() == null ? string.Empty : row["Batch"].ToString();
objSaleItem.Free = Convert.ToDecimal(row["Free"].ToString() == string.Empty ? "0.00" : row["Free"].ToString());
objSaleItem.BasicAmt = Convert.ToDecimal(row["BasicAmt"].ToString() == string.Empty ? "0.00" : row["BasicAmt"].ToString());
objSaleItem.DiscountPercentage = Convert.ToDecimal(row["DiscountPercentage"].ToString() == string.Empty ? "0.00" : row["DiscountPercentage"].ToString());
objSaleItem.DiscountAmount = Convert.ToDecimal(row["DiscountAmount"].ToString() == string.Empty ? "0.00" : row["DiscountAmount"].ToString());
objSaleItem.TaxAmount = Convert.ToDecimal(row["TaxAmount"].ToString() == string.Empty ? "0.00" : row["TaxAmount"].ToString());
objSaleItem.Amount = Convert.ToDecimal(row["Amount"].ToString() == string.Empty ? "0.00" : row["Amount"].ToString());
objSaleItem.Item_ID = Convert.ToInt64(row["Item_ID"].ToString() == string.Empty ? "0" : row["Item_ID"].ToString());
objSaleItem.ParentId = Convert.ToInt64(row["ParentId"].ToString() == string.Empty ? "0" : row["ParentId"].ToString());
lstSaleItems.Add(objSaleItem);
}
objSaleVch.SalesItem_Voucher = lstSaleItems;
//Bill Sundry Details
BillSundry_VoucherModel objSaleBS;
List <BillSundry_VoucherModel> lstSaleBS = new List <BillSundry_VoucherModel>();
for (int i = 0; i < dvgBsDetails.DataRowCount; i++)
{
DataRow row = dvgBsDetails.GetDataRow(i);
objSaleBS = new BillSundry_VoucherModel();
objSaleBS.BS_Id = objBSBL.GetBSIdByBSName(row["BillSundry"].ToString() == null ? string.Empty : row["BillSundry"].ToString());
objSaleBS.Percentage = Convert.ToDecimal(row["Percentage"].ToString() == string.Empty ? "0.00" : row["Percentage"].ToString());
objSaleBS.Extra = row["Extra"].ToString() == null ? string.Empty : row["Extra"].ToString();
objSaleBS.Amount = Convert.ToDecimal(row["Amount"].ToString() == string.Empty ? "0.00" : row["Amount"].ToString());
objSaleBS.BSId = Convert.ToInt64(row["BSId"].ToString() == string.Empty ? "0" : row["BSId"].ToString());
objSaleBS.ParentId = Convert.ToInt64(row["ParentId"].ToString() == string.Empty ? "0" : row["ParentId"].ToString());
lstSaleBS.Add(objSaleBS);
}
objSaleVch.SalesBillSundry_Voucher = lstSaleBS;
objSaleVch.Trans_Sales_Id = SalesId;
bool isSuccess = objSVBL.UpdateSalesVoucherMaster(objSaleVch);
if (isSuccess)
{
MessageBox.Show("Update Successfully!");
SalesId = 0;
ClearControls();
Transaction.List.SalesVouchersList frmSaleVchList = new Transaction.List.SalesVouchersList();
frmSaleVchList.StartPosition = FormStartPosition.CenterParent;
frmSaleVchList.ShowDialog();
FillSalesVoucherInfo();
}
}
public TransSalesModel GetAllSalesbyId(long id)
{
TransSalesModel objSaleVch = new TransSalesModel();
StringBuilder sbQuery = new StringBuilder();
sbQuery.AppendLine("SELECT m.*,am.ACC_NAME FROM `salesvoucher_master` AS m");
sbQuery.AppendLine("INNER JOIN accountmaster AS am ON m.LedgerId= am.Ac_ID");
sbQuery.AppendLine("WHERE m.`SalesVoucher_Id`='" + id + "'");
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(sbQuery.ToString(), _dbHelper.GetConnObject());
while (dr.Read())
{
objSaleVch.Trans_Sales_Id = Convert.ToInt64(dr["SalesVoucher_Id"]);
objSaleVch.VoucherType = dr["VoucherType"].ToString();
objSaleVch.SaleDate = DataFormat.GetDateTime(dr["SaleDate"]);
objSaleVch.Terms = dr["Terms"].ToString();
objSaleVch.VoucherNumber = Convert.ToInt64(dr["VoucherNumber"]);
objSaleVch.BillNo = Convert.ToInt64(dr["BillNumber"].ToString());
objSaleVch.SalesType = dr["SalesType"].ToString();
objSaleVch.Party = dr["ACC_NAME"].ToString();
objSaleVch.MatCentre = dr["MatCentre"].ToString();
objSaleVch.Narration = dr["Narration"].ToString();
objSaleVch.TotalQty = Convert.ToDecimal(dr["TotalQty"]);
objSaleVch.TotalAmount = Convert.ToDecimal(dr["TotalAmount"].ToString());
objSaleVch.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]);
objSaleVch.PriceList = dr["PriceList"].ToString();
//SELECT Item Details
StringBuilder sbitemQuery = new StringBuilder();
sbitemQuery.AppendLine("SELECT i.*,im.ITEM_Name,ia.ACC_NAME FROM salesvoucher_itemdetails as i");
sbitemQuery.AppendLine("left join itemmaster as im on i.ITM_ID=im.ITM_ID");
sbitemQuery.AppendLine("left join accountmaster as ia on i.LedgerId=ia.AC_ID");
sbitemQuery.AppendLine("WHERE SalesVoucher_Id='" + id + "'");
System.Data.IDataReader drItems = _dbHelper.ExecuteDataReader(sbitemQuery.ToString(), _dbHelper.GetConnObject());
objSaleVch.SalesItem_Voucher = new List <Item_VoucherModel>();
Item_VoucherModel objitem;
while (drItems.Read())
{
objitem = new Item_VoucherModel();
objitem.Item_ID = Convert.ToInt32(drItems["Id"]);
objitem.ParentId = DataFormat.GetInteger(drItems["SalesVoucher_Id"]);
objitem.ITM_Id = Convert.ToInt64(drItems["ITM_ID"].ToString() == string.Empty?"0": drItems["ITM_ID"].ToString());
objitem.LedgerId = Convert.ToInt64(drItems["LedgerId"].ToString() == string.Empty?"0":drItems["LedgerId"].ToString());
objitem.Item = drItems["ITEM_Name"].ToString();
objitem.Particulars = drItems["ACC_NAME"].ToString();
objitem.Qty = Convert.ToDecimal(drItems["qty"].ToString());
objitem.Unit = (drItems["Unit"].ToString());
objitem.Per = (drItems["Per"].ToString());
objitem.Batch = drItems["Batch"].ToString();
objitem.Price = Convert.ToDecimal(drItems["Price"]);
objitem.Amount = Convert.ToDecimal(drItems["Amount"].ToString());
objitem.Free = Convert.ToDecimal(drItems["Free"]);
objitem.BasicAmt = Convert.ToDecimal(drItems["BasicAmt"].ToString());
objitem.DiscountPercentage = Convert.ToDecimal(drItems["DiscountPercentage"].ToString());
objitem.DiscountAmount = Convert.ToDecimal(drItems["DiscountAmount"].ToString());
objitem.TaxAmount = Convert.ToDecimal(drItems["TaxAmount"].ToString());
objSaleVch.SalesItem_Voucher.Add(objitem);
}
//Select BS Details
StringBuilder sbBSQuery = new StringBuilder();
sbBSQuery.AppendLine("SELECT pbs.*,mbs.Name FROM salesvoucher_bsdetails as pbs");
sbBSQuery.AppendLine("inner join billsundarymaster as mbs on pbs.BS_Id=mbs.BS_Id");
sbBSQuery.AppendLine("WHERE SalesVoucher_Id='" + id + "'");
System.Data.IDataReader drbs = _dbHelper.ExecuteDataReader(sbBSQuery.ToString(), _dbHelper.GetConnObject());
objSaleVch.SalesBillSundry_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["SalesVoucher_Id"]);
objbs.BillSundry = drbs["Name"].ToString();
objbs.Percentage = Convert.ToDecimal(drbs["Percentage"].ToString());
objbs.Extra = drbs["Extra"].ToString();
objbs.Amount = Convert.ToDecimal((drbs["Amount"].ToString()));
objSaleVch.SalesBillSundry_Voucher.Add(objbs);
}
}
return(objSaleVch);
}
public List <PurchaseReturnVoucherModel> GetAllPurchaseReturn()
{
List <PurchaseReturnVoucherModel> lstPurchase = new List <PurchaseReturnVoucherModel>();
PurchaseReturnVoucherModel objPReturn;
string Query = "SELECT * FROM Trans_PurchaseReturn";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objPReturn = new PurchaseReturnVoucherModel();
objPReturn.PR_Id = DataFormat.GetInteger(dr["PR_Id"]);
objPReturn.Series = dr["Series"].ToString();
objPReturn.PR_Date = DataFormat.GetDateTime(dr["PR_Date"]);
objPReturn.Voucher_Number = DataFormat.GetInteger(dr["VoucherNo"]);
objPReturn.PurchaseType = dr["PurchaseType"].ToString();
objPReturn.Party = dr["Party"].ToString();
objPReturn.MatCenter = dr["MatCentre"].ToString();
objPReturn.Narration = dr["Narration"].ToString();
//objPReturn. = Convert.ToDecimal(dr["TotalQty"]);
//objPReturn.TotalAmount = Convert.ToDecimal(dr["TotalAmount"]);
//objPReturn.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]);
//SELECT Purchase Items
string itemQuery = "SELECT * FROM Trans_PR_Items WHERE Pro_Id=" + objPReturn.PR_Id;
System.Data.IDataReader drItem = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject());
objPReturn.Item_Voucher = new List <Item_VoucherModel>();
Item_VoucherModel objItemModel;
while (drItem.Read())
{
objItemModel = new Item_VoucherModel();
objItemModel.ParentId = DataFormat.GetInteger(drItem["TransPRId"]);
objItemModel.Item_ID = DataFormat.GetInteger(drItem["Id"]);
objItemModel.Item = drItem["Item"].ToString();
objItemModel.Price = Convert.ToDecimal(drItem["Price"]);
objItemModel.Qty = Convert.ToDecimal(drItem["Qty"]);
objItemModel.Unit = drItem["Unit"].ToString();
objItemModel.Amount = Convert.ToDecimal(drItem["Amount"]);
objItemModel.TotalQty = Convert.ToDecimal(drItem["TotalQty"]);
objItemModel.TotalAmount = Convert.ToDecimal(drItem["TotalAmount"]);
objPReturn.Item_Voucher.Add(objItemModel);
}
//SELECT Bill Sundry Voucher items
string bsQuery = "SELECT * FROM Trans_PR_BS WHERE TransPVId=" + objPReturn.PR_Id;
System.Data.IDataReader drBS = _dbHelper.ExecuteDataReader(bsQuery, _dbHelper.GetConnObject());
objPReturn.BillSundry_Voucher = new List <BillSundry_VoucherModel>();
BillSundry_VoucherModel objBSModel;
while (drBS.Read())
{
objBSModel = new BillSundry_VoucherModel();
objBSModel.ParentId = DataFormat.GetInteger(drBS["TransPRId"]);
objBSModel.BSId = DataFormat.GetInteger(drBS["BSId"]);
objBSModel.BillSundry = drBS["BillSundry"].ToString();
objBSModel.Percentage = Convert.ToDecimal(drBS["Percentage"]);
objBSModel.Amount = Convert.ToDecimal(drBS["Amount"]);
objBSModel.TotalAmount = Convert.ToDecimal(drBS["TotalAmount"]);
objPReturn.BillSundry_Voucher.Add(objBSModel);
}
lstPurchase.Add(objPReturn);
}
return(lstPurchase);
}
public TransSalesModel GetSalesById(String ID)
{
//List<TransSalesModel> lstSalesVouchers = new List<TransSalesModel>();
TransSalesModel objsales = new TransSalesModel();
string query = string.Empty;
query = "SELECT count(*) FROM Trans_Sales";
//int i=_dbHelper.ExecuteNonQuery(query);
if (ID == "first")
{
query = "SELECT TOP 1 * FROM Trans_Sales";
}
ID = "1";
if (ID == "last")
{
query = "SELECT TOP 1 * FROM Trans_Sales order by Trans_Sales_Id desc";
}
if (Convert.ToInt32(ID) > 0)
{
query = "SELECT * FROM Trans_Sales WHERE Trans_sales_id=" + ID;
}
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(query, _dbHelper.GetConnObject());
while (dr.Read())
{
objsales.Trans_Sales_Id = DataFormat.GetInteger(dr["Trans_Sales_Id"]);
objsales.Series = dr["Series"].ToString();
objsales.SaleDate = DataFormat.GetDateTime(dr["SaleDate"]);
objsales.VoucherNumber = DataFormat.GetInteger(dr["VoucherNumber"]);
objsales.SalesType = dr["SalesType"].ToString();
objsales.Party = dr["Party"].ToString();
objsales.MatCentre = dr["MatCentre"].ToString();
objsales.Narration = dr["Narration"].ToString();
objsales.TotalQty = Convert.ToDecimal(dr["TotalQty"]);
objsales.TotalAmount = Convert.ToDecimal(dr["TotalAmount"]);
objsales.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]);
objsales.Trans_Sales_Id = objsales.Trans_Sales_Id + 1;
//SELECT Sales Items
string itemQuery = "SELECT * FROM Trans_Sales_Item WHERE TransSalesId=" + objsales.Trans_Sales_Id;
System.Data.IDataReader drItem = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject());
objsales.SalesItem_Voucher = new List <Item_VoucherModel>();
Item_VoucherModel objItemModel;
while (drItem.Read())
{
objItemModel = new Item_VoucherModel();
objItemModel.ParentId = DataFormat.GetInteger(drItem["TransSalesId"]);
objItemModel.Item_ID = DataFormat.GetInteger(drItem["ItemId"]);
objItemModel.Item = drItem["Item"].ToString();
objItemModel.Price = Convert.ToDecimal(drItem["Price"]);
objItemModel.Qty = Convert.ToDecimal(drItem["Qty"]);
objItemModel.Unit = drItem["Unit"].ToString();
objItemModel.Amount = Convert.ToDecimal(drItem["Amount"]);
objItemModel.TotalQty = Convert.ToDecimal(drItem["TotalQty"]);
objItemModel.TotalAmount = Convert.ToDecimal(drItem["TotalAmount"]);
objsales.SalesItem_Voucher.Add(objItemModel);
}
//SELECT Bill Sundry Voucher items
string bsQuery = "SELECT * FROM Trans_Sales_BS WHERE TransSalesId=" + objsales.Trans_Sales_Id;
System.Data.IDataReader drBS = _dbHelper.ExecuteDataReader(bsQuery, _dbHelper.GetConnObject());
objsales.SalesBillSundry_Voucher = new List <BillSundry_VoucherModel>();
BillSundry_VoucherModel objBSModel;
while (drBS.Read())
{
objBSModel = new BillSundry_VoucherModel();
objBSModel.ParentId = DataFormat.GetInteger(drBS["TransSalesId"]);
objBSModel.BSId = DataFormat.GetInteger(drBS["BSId"]);
objBSModel.BillSundry = drBS["BillSundry"].ToString();
objBSModel.Percentage = Convert.ToDecimal(drBS["Percentage"]);
objBSModel.Amount = Convert.ToDecimal(drBS["Amount"]);
objBSModel.TotalAmount = Convert.ToDecimal(drBS["TotalAmount"]);
objsales.SalesBillSundry_Voucher.Add(objBSModel);
}
// lstSalesVouchers.Add(objsales);
}
return(objsales);
}
public PurchaseReturnVoucherModel GetAllPurchaseReturnById(int id)
{
PurchaseReturnVoucherModel objPRVoucher = new PurchaseReturnVoucherModel();
string Query = "SELECT * FROM Trans_purchaseReturn WHERE transprId=" + id;
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objPRVoucher.PR_Id = DataFormat.GetInteger(dr["TransPrId"]);
objPRVoucher.Series = dr["series"].ToString();
objPRVoucher.PurchaseType = dr["PurchaseType"].ToString();
objPRVoucher.PR_Date = DataFormat.GetDateTime(dr["pr_Date"]);
objPRVoucher.Voucher_Number = DataFormat.GetInteger(dr["Voucherno"]);
objPRVoucher.BillNo = DataFormat.GetInteger(dr["BillNo"]);
objPRVoucher.DueDate = DataFormat.GetDateTime(dr["DueDate"]);
objPRVoucher.Party = dr["party"].ToString();
objPRVoucher.MatCenter = dr["MatCenter"].ToString();
objPRVoucher.Narration = dr["Narration"].ToString();
//objpurchase.t = Convert.ToDecimal(dr["TotalQty"]);
//objpurchase.TotalAmount = Convert.ToDecimal(dr["TotalAmount"].ToString());
//objpurchase.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]);
//SELECT Purchase Items
string itemQuery = "SELECT * FROM Trans_pr_items WHERE TransprId=" + id;
System.Data.IDataReader drItems = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject());
objPRVoucher.Item_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["TransprId"]);
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.TotalQty = Convert.ToInt32(drItems["TotalQty"].ToString());
objitem.TotalAmount = Convert.ToDecimal(drItems["TotalAmount"]);
objPRVoucher.Item_Voucher.Add(objitem);
}
string BSQuery = "SELECT * FROM Trans_pr_BS WHERE TransprId=" + id;
System.Data.IDataReader drbs = _dbHelper.ExecuteDataReader(BSQuery, _dbHelper.GetConnObject());
objPRVoucher.BillSundry_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["TransprId"]);
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());
objPRVoucher.BillSundry_Voucher.Add(objbs);
}
}
return(objPRVoucher);
}
private void btnSave_Click(object sender, EventArgs e)
{
eSunSpeedDomain.StockJournalModel objjournal = new eSunSpeedDomain.StockJournalModel();
if (tbxVoucherNo.Text.Trim() == "")
{
MessageBox.Show("Voucher Number Can Not Be Blank!");
return;
}
objjournal.Series = tbxSeries.Text.Trim();
objjournal.SJ_Date = Convert.ToDateTime(dtDate.Text);
objjournal.Voucher_Number = Convert.ToInt32(tbxVoucherNo.Text.Trim());
objjournal.MatCenterIC = tbxMatcenterIC.Text.Trim();
objjournal.MatCenterIG = tbxMatcenterIG.Text.Trim();
objjournal.Narration = tbxNarration.Text.Trim();
objjournal.TotalAmountIG = Convert.ToDecimal(Amount.SummaryItem.SummaryValue);
objjournal.TotalQtyIG = Convert.ToInt32(Qty.SummaryItem.SummaryValue);
//Item Generated Details
Item_VoucherModel objItem;
List <Item_VoucherModel> lstItems = new List <Item_VoucherModel>();
for (int i = 0; i < gdvItemIG.DataRowCount; i++)
{
DataRow row = gdvItemIG.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);
}
objjournal.Item_Generated = lstItems;
//Item Consumed Details
ItemConsumedModel objItemCon;
List <ItemConsumedModel> lstItemConsumed = new List <ItemConsumedModel>();
for (int i = 0; i < gdvItemIG.DataRowCount; i++)
{
DataRow row = gdvItemIG.GetDataRow(i);
objItemCon = new ItemConsumedModel();
objItemCon.Item = row["Item"].ToString();
objItemCon.Qty = Convert.ToDecimal(row["Qty"]);
objItemCon.Unit = row["Unit"].ToString();
objItemCon.Amount = Convert.ToDecimal(row["Amount"].ToString());
objItemCon.Price = Convert.ToDecimal(row["Price"].ToString());
lstItemConsumed.Add(objItemCon);
}
objjournal.Item_Consumed = lstItemConsumed;
//objProdu.TotalQtyIG = Convert.ToDecimal(BSAmount.SummaryItem.SummaryValue);
//objSales.SalesBillSundry_Voucher = lstBS;
bool isSuccess = objSJBL.SaveStockJournalMaster(objjournal);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
// Dialogs.PopUPDialog d = new Dialogs.PopUPDialog("Saved Successfully!");
// d.ShowDialog();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
StockTransferModel objStockTrans = new StockTransferModel();
if (tbxVoucherNo.Text.Trim() == "")
{
MessageBox.Show("Voucher Number Can Not Be Blank!");
return;
}
objStockTrans.Series = tbxSeries.Text.Trim();
objStockTrans.FromDate = tbxFrom.Text.Trim();
objStockTrans.ToDate = tbxTo.Text.Trim();
objStockTrans.ST_Date = Convert.ToDateTime(dtDate.Text);
objStockTrans.Voucher_Number = Convert.ToInt32(tbxVoucherNo.Text.Trim());
objStockTrans.Narration = tbxNarration.Text.Trim();
objStockTrans.TotalAmount = Convert.ToDecimal(Amount.SummaryItem.SummaryValue);
objStockTrans.TotalQty = Convert.ToInt32(Qty.SummaryItem.SummaryValue);
//Stock Transfer 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);
}
objStockTrans.StockItem_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);
}
objStockTrans.BSTotalAmount = Convert.ToDecimal(BSAmount.SummaryItem.SummaryValue);
objStockTrans.StockBillSundry_Voucher = lstBS;
bool isSuccess = objStockBL.SaveStockVoucher(objStockTrans);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
// Dialogs.PopUPDialog d = new Dialogs.PopUPDialog("Saved Successfully!");
// d.ShowDialog();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
PurchaseReturnVoucherModel objPurcRet = new PurchaseReturnVoucherModel();
if (tbxVoucherNumber.Text.Trim() == "")
{
MessageBox.Show("Voucher Number Can Not Be Blank!");
return;
}
objPurcRet.VoucherType = cbxVoucherType.Text.Trim();
objPurcRet.PR_Date = Convert.ToDateTime(dtDate.Text);
objPurcRet.Terms = cbxTerms.SelectedItem.ToString();
objPurcRet.VoucherNumber = Convert.ToInt64(tbxVoucherNumber.Text.Trim() == string.Empty ? "0" : tbxVoucherNumber.Text.Trim());
objPurcRet.BillNo = Convert.ToInt64(tbxBillNo.Text.Trim() == string.Empty ? "0" : tbxBillNo.Text.Trim());
objPurcRet.LedgerId = objAccBL.GetLedgerIdByAccountName(cbxParty.Text.Trim());
objPurcRet.PurchaseType = cbxPurcRetType.Text.Trim() == null ? string.Empty : cbxPurcRetType.Text.Trim();
objPurcRet.MatCenter = cbxMatcenter.Text.Trim();
objPurcRet.Narration = tbxNarration.Text.Trim() == null ? string.Empty : tbxNarration.Text.Trim();
objPurcRet.TotalQty = Convert.ToDecimal(colQty.SummaryItem.SummaryValue);
objPurcRet.TotalFree = Convert.ToDecimal(colFree.SummaryItem.SummaryValue);
objPurcRet.TotalBasicAmount = Convert.ToDecimal(colBasicAmt.SummaryItem.SummaryValue);
objPurcRet.TotalDisAmount = Convert.ToDecimal(colDisAmt.SummaryItem.SummaryValue);
objPurcRet.TotalTaxAmount = Convert.ToDecimal(colTaxAmt.SummaryItem.SummaryValue);
objPurcRet.TotalAmount = Convert.ToDecimal(colAmount.SummaryItem.SummaryValue);
objPurcRet.BSTotalAmount = Convert.ToDecimal(colBSAmount.SummaryItem.SummaryValue);
//Items Details
Item_VoucherModel objPurcRetItem;
List <Item_VoucherModel> lstPurcRetItems = new List <Item_VoucherModel>();
for (int i = 0; i < dvgItemDetails.DataRowCount; i++)
{
DataRow row = dvgItemDetails.GetDataRow(i);
objPurcRetItem = new Item_VoucherModel();
objPurcRetItem.ITM_Id = objIMBL.GetItemIdByItemName(row["Item"].ToString() == null ? string.Empty : row["Item"].ToString());
objPurcRetItem.Qty = Convert.ToDecimal(row["Qty"].ToString() == string.Empty ? "0.00" : row["Qty"]);
objPurcRetItem.Unit = row["Unit"].ToString() == null ? string.Empty : row["Unit"].ToString();
objPurcRetItem.Per = row["Per"].ToString() == null ? string.Empty : row["Per"].ToString();
objPurcRetItem.Price = Convert.ToDecimal(row["Price"].ToString() == string.Empty ? "0.00" : row["Price"].ToString());
objPurcRetItem.Batch = row["Batch"].ToString() == null ? string.Empty : row["Batch"].ToString();
objPurcRetItem.Free = Convert.ToDecimal(row["Free"].ToString() == string.Empty ? "0.00" : row["Free"].ToString());
objPurcRetItem.BasicAmt = Convert.ToDecimal(row["BasicAmt"].ToString() == string.Empty ? "0.00" : row["BasicAmt"].ToString());
objPurcRetItem.DiscountPercentage = Convert.ToDecimal(row["DiscountPercentage"].ToString() == string.Empty ? "0.00" : row["DiscountPercentage"].ToString());
objPurcRetItem.DiscountAmount = Convert.ToDecimal(row["DiscountAmount"].ToString() == string.Empty ? "0.00" : row["DiscountAmount"].ToString());
objPurcRetItem.TaxAmount = Convert.ToDecimal(row["TaxAmount"].ToString() == string.Empty ? "0.00" : row["TaxAmount"].ToString());
objPurcRetItem.Amount = Convert.ToDecimal(row["Amount"].ToString() == string.Empty ? "0.00" : row["Amount"].ToString());
if (objPurcRet.PR_Id != 0)
{
objPurcRetItem.Item_ID = Convert.ToInt64(row["Item_ID"].ToString() == string.Empty ? "0" : row["Item_ID"].ToString());
objPurcRetItem.ParentId = Convert.ToInt64(row["ParentId"].ToString() == string.Empty ? "0" : row["ParentId"].ToString());
}
lstPurcRetItems.Add(objPurcRetItem);
}
objPurcRet.Item_Voucher = lstPurcRetItems;
//Bill Sundry Details
BillSundry_VoucherModel objPurcRetBS;
List <BillSundry_VoucherModel> lstPurcRetBS = new List <BillSundry_VoucherModel>();
for (int i = 0; i < dvgBSDetails.DataRowCount; i++)
{
DataRow row = dvgBSDetails.GetDataRow(i);
objPurcRetBS = new BillSundry_VoucherModel();
objPurcRetBS.BS_Id = objBSBL.GetBSIdByBSName(row["BillSundry"].ToString() == null ? string.Empty : row["BillSundry"].ToString());
objPurcRetBS.Percentage = Convert.ToDecimal(row["Percentage"].ToString() == string.Empty ? "0.00" : row["Percentage"].ToString());
objPurcRetBS.Extra = row["Extra"].ToString() == null ? string.Empty : row["Extra"].ToString();
objPurcRetBS.Amount = Convert.ToDecimal(row["Amount"].ToString() == string.Empty ? "0.00" : row["Amount"].ToString());
lstPurcRetBS.Add(objPurcRetBS);
}
objPurcRet.BillSundry_Voucher = lstPurcRetBS;
bool isSuccess = objPurcBL.SavePurcahseReturnVoucher(objPurcRet);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
PurcRetId = 0;
ClearControls();
}
}
public StockTransferModel GetAllStockTransferbyId(int id)
{
StockTransferModel objstock = new StockTransferModel();
string Query = "SELECT * FROM Stock_Transfer_Voucher WHERE Stock_Id=" + id;
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objstock.ST_Id = Convert.ToInt32(dr["Stock_Id"]);
objstock.Series = dr["series"].ToString();
objstock.ST_Date = DataFormat.GetDateTime(dr["ST_Date"]);
objstock.Voucher_Number = DataFormat.GetInteger(dr["VoucherNo"]);
objstock.FromDate = Convert.ToDateTime(dr["FromDate"]);
objstock.ToDate = Convert.ToDateTime(dr["ToDate"]);
objstock.Narration = dr["Narration"].ToString();
//objSalesReturn.TotalQty = Convert.ToDecimal(dr["TotalQty"]);
//objSalesReturn.TotalAmount = Convert.ToDecimal(dr["TotalAmount"].ToString());
//objSalesReturn.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]);
string itemQuery = "SELECT * FROM Stock_Transfer_Items WHERE Stock_Id=" + id;
System.Data.IDataReader drItems = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject());
objstock.StockItem_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["Stock_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());
objstock.StockItem_Voucher.Add(objitem);
}
string BSQuery = "SELECT * FROM Stock_Transfer_BS WHERE Stock_Id=" + id;
System.Data.IDataReader drbs = _dbHelper.ExecuteDataReader(BSQuery, _dbHelper.GetConnObject());
objstock.StockBillSundry_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["Stock_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());
objstock.StockBillSundry_Voucher.Add(objbs);
}
}
return(objstock);
}
public MatIssuedModel GetAllMatIssuedbyId(int id)
{
MatIssuedModel objMatIssued = new MatIssuedModel();
string Query = "SELECT * FROM Trans_MatIssued WHERE MatIssued_Id=" + id;
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objMatIssued.Issued_Id = Convert.ToInt32(dr["MatIssued_Id"]);
objMatIssued.Series = dr["series"].ToString();
objMatIssued.Issued_Date = DataFormat.GetDateTime(dr["Issued_Date"]);
objMatIssued.Voucher_Number = DataFormat.GetInteger(dr["VoucherNo"]);
objMatIssued.Party = dr["party"].ToString();
objMatIssued.MatCenter = dr["MatCentre"].ToString();
objMatIssued.Narration = dr["Narration"].ToString();
objMatIssued.TotalQty = Convert.ToDecimal(dr["TotalQty"]);
objMatIssued.TotalAmount = Convert.ToDecimal(dr["TotalAmount"].ToString());
objMatIssued.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]);
//SELECT Credit Note Accounts
string itemQuery = "SELECT * FROM Trans_MatIssued_Items WHERE MatIssued_Id=" + id;
System.Data.IDataReader drItems = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject());
objMatIssued.IssuedItem_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["MatIssued_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());
objMatIssued.IssuedItem_Voucher.Add(objitem);
}
string BSQuery = "SELECT * FROM Trans_MatIssued_BS WHERE MatIssued_Id=" + id;
System.Data.IDataReader drbs = _dbHelper.ExecuteDataReader(BSQuery, _dbHelper.GetConnObject());
objMatIssued.IssuedBillSundry_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["MatIssued_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());
objMatIssued.IssuedBillSundry_Voucher.Add(objbs);
}
}
return(objMatIssued);
}
public TransSalesModel GetAllSalesbyId(int id)
{
TransSalesModel objSales = new TransSalesModel();
string Query = "SELECT * FROM Trans_Sales WHERE trans_sales_Id=" + id;
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objSales.Trans_Sales_Id = Convert.ToInt32(dr["Trans_Sales_Id"]);
objSales.Series = dr["series"].ToString();
objSales.SaleDate = DataFormat.GetDateTime(dr["SaleDate"]);
objSales.VoucherNumber = DataFormat.GetInteger(dr["VoucherNumber"]);
objSales.BillNo = Convert.ToInt32(dr["BillNumber"].ToString());
objSales.DueDate = Convert.ToDateTime(dr["DueDate"]);
objSales.SalesType = dr["SalesType"].ToString();
objSales.Party = dr["party"].ToString();
objSales.MatCentre = dr["MatCentre"].ToString();
objSales.Narration = dr["Narration"].ToString();
objSales.TotalQty = Convert.ToDecimal(dr["TotalQty"]);
objSales.TotalAmount = Convert.ToDecimal(dr["TotalAmount"].ToString());
objSales.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]);
//SELECT Credit Note Accounts
string itemQuery = "SELECT * FROM Trans_Sales_Item WHERE Trans_Sales_Id=" + id;
System.Data.IDataReader drItems = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject());
objSales.SalesItem_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["Trans_Sales_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());
objSales.SalesItem_Voucher.Add(objitem);
}
string BSQuery = "SELECT * FROM Trans_Sales_BS WHERE Trans_Sales_Id=" + id;
System.Data.IDataReader drbs = _dbHelper.ExecuteDataReader(BSQuery, _dbHelper.GetConnObject());
objSales.SalesBillSundry_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["Trans_Sales_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());
objSales.SalesBillSundry_Voucher.Add(objbs);
}
}
return(objSales);
}
private void btnSave_Click(object sender, EventArgs e)
{
PurchaseVoucherMainModel objPurcQuot = new PurchaseVoucherMainModel();
if (tbxVoucherNo.Text.Trim() == "")
{
MessageBox.Show("Voucher Number Can Not Be Blank!");
return;
}
objPurcQuot.PurchaseVoucher_Series = tbxSeries.Text.Trim();
objPurcQuot.PurchaseVoucher_PurchaseType = tbxPurcType.Text.Trim();
objPurcQuot.PurchaseVoucher_Date = Convert.ToDateTime(dtDate.Text);
objPurcQuot.PurchaseVoucher_Number = Convert.ToInt32(tbxVoucherNo.Text.Trim());
objPurcQuot.PurchaseVoucher_Party = tbxParty.Text.Trim();
objPurcQuot.PurchaseVoucher_MatCenter = tbxMatCenter.Text.Trim();
objPurcQuot.Narration = tbxNarration.Text.Trim();
objPurcQuot.TotalAmount = Convert.ToDecimal(Amount.SummaryItem.SummaryValue);
objPurcQuot.TotalQty = Convert.ToInt32(Qty.SummaryItem.SummaryValue);
//Purchase Quotation Items
Item_VoucherModel objItem;
List <Item_VoucherModel> lstItemsPQ = 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());
lstItemsPQ.Add(objItem);
}
objPurcQuot.PurchaseItem_Voucher = lstItemsPQ;
//Purchase Qutation Bill Sundry
BillSundry_VoucherModel objBS;
List <BillSundry_VoucherModel> lstBSPQ = 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();
lstBSPQ.Add(objBS);
}
objPurcQuot.BSTotalAmount = Convert.ToDecimal(BSAmount.SummaryItem.SummaryValue);
objPurcQuot.BillSundry_Voucher = lstBSPQ;
bool isSuccess = objPQBL.SavePurchaseQuotation(objPurcQuot);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
// Dialogs.PopUPDialog d = new Dialogs.PopUPDialog("Saved Successfully!");
// d.ShowDialog();
}
}
public List <TransSalesModel> GetAllSalesVouchers()
{
List <TransSalesModel> lstSalesVouchers = new List <TransSalesModel>();
TransSalesModel objsales;
string Query = "SELECT * FROM Trans_Sales";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objsales = new eSunSpeedDomain.TransSalesModel();
objsales.Trans_Sales_Id = DataFormat.GetInteger(dr["Trans_Sales_Id"]);
objsales.Series = dr["Series"].ToString();
objsales.SaleDate = DataFormat.GetDateTime(dr["SaleDate"]);
objsales.VoucherNumber = DataFormat.GetInteger(dr["VoucherNumber"]);
objsales.SalesType = dr["SalesType"].ToString();
objsales.Party = dr["Party"].ToString();
objsales.MatCentre = dr["MatCentre"].ToString();
objsales.Narration = dr["Narration"].ToString();
objsales.TotalQty = Convert.ToDecimal(dr["TotalQty"]);
objsales.TotalAmount = Convert.ToDecimal(dr["TotalAmount"]);
objsales.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]);
//SELECT Sales Items
string itemQuery = "SELECT * FROM Trans_Sales_Item WHERE TransSalesId=" + objsales.Trans_Sales_Id;
System.Data.IDataReader drItem = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject());
objsales.SalesItem_Voucher = new List <Item_VoucherModel>();
Item_VoucherModel objItemModel;
while (drItem.Read())
{
objItemModel = new Item_VoucherModel();
objItemModel.ParentId = DataFormat.GetInteger(drItem["TransSalesId"]);
objItemModel.Item_ID = DataFormat.GetInteger(drItem["ItemId"]);
objItemModel.Item = drItem["Item"].ToString();
objItemModel.Price = Convert.ToDecimal(drItem["Price"]);
objItemModel.Qty = Convert.ToDecimal(drItem["Qty"]);
objItemModel.Unit = drItem["Unit"].ToString();
objItemModel.Amount = Convert.ToDecimal(drItem["Amount"]);
objItemModel.TotalQty = Convert.ToDecimal(drItem["TotalQty"]);
objItemModel.TotalAmount = Convert.ToDecimal(drItem["TotalAmount"]);
objsales.SalesItem_Voucher.Add(objItemModel);
}
//SELECT Bill Sundry Voucher items
string bsQuery = "SELECT * FROM Trans_Sales_BS WHERE TransSalesId=" + objsales.Trans_Sales_Id;
System.Data.IDataReader drBS = _dbHelper.ExecuteDataReader(bsQuery, _dbHelper.GetConnObject());
objsales.SalesBillSundry_Voucher = new List <BillSundry_VoucherModel>();
BillSundry_VoucherModel objBSModel;
while (drBS.Read())
{
objBSModel = new BillSundry_VoucherModel();
objBSModel.ParentId = DataFormat.GetInteger(drBS["TransSalesId"]);
objBSModel.BSId = DataFormat.GetInteger(drBS["BSId"]);
objBSModel.BillSundry = drBS["BillSundry"].ToString();
objBSModel.Percentage = Convert.ToDecimal(drBS["Percentage"]);
objBSModel.Amount = Convert.ToDecimal(drBS["Amount"]);
objBSModel.TotalAmount = Convert.ToDecimal(drBS["TotalAmount"]);
objsales.SalesBillSundry_Voucher.Add(objBSModel);
}
lstSalesVouchers.Add(objsales);
}
return(lstSalesVouchers);
}
private void btnSave_Click(object sender, EventArgs e)
{
TransSalesModel objSales = new TransSalesModel();
if (tbxVchNo.Text.Trim() == "")
{
MessageBox.Show("Voucher Number Can Not Be Blank!");
return;
}
objSales.Series = tbxSeries.Text.Trim();
objSales.SalesType = tbxSalesType.Text.Trim();
objSales.SaleDate = Convert.ToDateTime(dtDate.Text);
objSales.VoucherNumber = Convert.ToInt32(tbxVchNo.Text.Trim());
objSales.Party = tbxParty.Text.Trim();
objSales.MatCentre = tbxMatCentre.Text.Trim();
objSales.Narration = tbxNarration.Text.Trim();
objSales.TotalAmount = Convert.ToDecimal(Amount.SummaryItem.SummaryValue);
objSales.TotalQty = Convert.ToInt32(Qty.SummaryItem.SummaryValue);
//Bill Number and Due date not captured- check with Ravi if these are required
//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);
}
objSales.SalesItem_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.Percentage = Convert.ToDecimal(row["Percentage"]);
objBS.Amount = Convert.ToDecimal(row["Amount"]);
objBS.Type = row["Extra"].ToString();
lstBS.Add(objBS);
}
objSales.BSTotalAmount = Convert.ToDecimal(BSAmount.SummaryItem.SummaryValue);
objSales.SalesBillSundry_Voucher = lstBS;
objSalesVoucher = new SalesVoucherBL();
bool isSuccess = objSalesVoucher.SaveSalesVoucher(objSales);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
// Dialogs.PopUPDialog d = new Dialogs.PopUPDialog("Saved Successfully!");
// d.ShowDialog();
}
}
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);
}
//Get All Purchase Return Details By ID
public PurchaseReturnVoucherModel GetAllPurchaseVchDetailsbyId(long id)
{
PurchaseReturnVoucherModel objPurcRet = new PurchaseReturnVoucherModel();
StringBuilder sbQuery = new StringBuilder();
sbQuery.AppendLine("SELECT m.*,am.ACC_NAME FROM `purchasereturn_master` AS m");
sbQuery.AppendLine("INNER JOIN accountmaster AS am ON m.LedgerId= am.Ac_ID");
sbQuery.AppendLine("WHERE m.`PurcReturn_Id`='" + id + "'");
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(sbQuery.ToString(), _dbHelper.GetConnObject());
while (dr.Read())
{
objPurcRet.PR_Id = Convert.ToInt64(dr["PurcReturn_Id"]);
objPurcRet.VoucherType = dr["VoucherType"].ToString();
objPurcRet.PR_Date = DataFormat.GetDateTime(dr["PurcReturnDate"]);
objPurcRet.Terms = dr["Terms"].ToString();
objPurcRet.VoucherNumber = Convert.ToInt64(dr["VoucherNumber"]);
objPurcRet.BillNo = Convert.ToInt64(dr["BillNumber"].ToString());
objPurcRet.PurchaseType = dr["PurcType"].ToString();
objPurcRet.Party = dr["ACC_NAME"].ToString();
objPurcRet.MatCenter = dr["MatCentre"].ToString();
objPurcRet.Narration = dr["Narration"].ToString();
objPurcRet.TotalQty = Convert.ToDecimal(dr["TotalQty"]);
objPurcRet.TotalFree = Convert.ToDecimal(dr["TotalFree"]);
objPurcRet.TotalBasicAmount = Convert.ToDecimal(dr["TotalBasicAmount"]);
objPurcRet.TotalDisAmount = Convert.ToDecimal(dr["TotalDisAmount"]);
objPurcRet.TotalTaxAmount = Convert.ToDecimal(dr["TotalTaxAmount"]);
objPurcRet.TotalAmount = Convert.ToDecimal(dr["TotalAmount"].ToString());
objPurcRet.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]);
//SELECT Item Details
StringBuilder sbitemQuery = new StringBuilder();
sbitemQuery.AppendLine("SELECT i.*,im.ITEM_Name FROM purchasereturn_itemdetails as i");
sbitemQuery.AppendLine("inner join itemmaster as im on i.ITM_ID=im.ITM_ID");
sbitemQuery.AppendLine("WHERE PurcReturn_Id='" + id + "'");
System.Data.IDataReader drItems = _dbHelper.ExecuteDataReader(sbitemQuery.ToString(), _dbHelper.GetConnObject());
objPurcRet.Item_Voucher = new List <Item_VoucherModel>();
Item_VoucherModel objitem;
while (drItems.Read())
{
objitem = new Item_VoucherModel();
objitem.Item_ID = Convert.ToInt32(drItems["Id"]);
objitem.ParentId = DataFormat.GetInteger(drItems["PurcReturn_Id"]);
objitem.Item = drItems["ITEM_Name"].ToString();
objitem.Qty = Convert.ToDecimal(drItems["qty"].ToString());
objitem.Unit = (drItems["Unit"].ToString());
objitem.Per = (drItems["Per"].ToString());
objitem.Batch = drItems["Batch"].ToString();
objitem.Price = Convert.ToDecimal(drItems["Price"]);
objitem.Amount = Convert.ToDecimal(drItems["Amount"].ToString());
objitem.Free = Convert.ToDecimal(drItems["Free"]);
objitem.BasicAmt = Convert.ToDecimal(drItems["BasicAmt"].ToString());
objitem.DiscountPercentage = Convert.ToDecimal(drItems["DiscountPercentage"].ToString());
objitem.DiscountAmount = Convert.ToDecimal(drItems["DiscountAmount"].ToString());
objitem.TaxAmount = Convert.ToDecimal(drItems["TaxAmount"].ToString());
objPurcRet.Item_Voucher.Add(objitem);
}
//Select BS Details
StringBuilder sbBSQuery = new StringBuilder();
sbBSQuery.AppendLine("SELECT pbs.*,mbs.Name FROM purchasereturn_bsdetails as pbs");
sbBSQuery.AppendLine("inner join billsundarymaster as mbs on pbs.BS_Id=mbs.BS_Id");
sbBSQuery.AppendLine("WHERE PurcReturn_Id='" + id + "'");
System.Data.IDataReader drbs = _dbHelper.ExecuteDataReader(sbBSQuery.ToString(), _dbHelper.GetConnObject());
objPurcRet.BillSundry_Voucher = new List <BillSundry_VoucherModel>();
BillSundry_VoucherModel objbs;
while (drbs.Read())
{
objbs = new BillSundry_VoucherModel();
objbs.BSId = Convert.ToInt32(drbs["Id"]);
objbs.ParentId = DataFormat.GetInteger(drbs["PurcReturn_Id"]);
objbs.BillSundry = drbs["Name"].ToString();
objbs.Percentage = Convert.ToDecimal(drbs["Percentage"].ToString());
objbs.Extra = drbs["Extra"].ToString();
objbs.Amount = Convert.ToDecimal((drbs["Amount"].ToString()));
objPurcRet.BillSundry_Voucher.Add(objbs);
}
}
return(objPurcRet);
}
