public List <PurchaseBookAmount> InsertUpdateTempPurchaseBookLineItem(PharmaBusinessObjects.Transaction.PurchaseSaleBookLineItem lineItem)
{
try
{
List <PurchaseBookAmount> purchaseBookAmounts = new List <PurchaseBookAmount>();
string ConnString = ConfigurationManager.ConnectionStrings["PharmaDBConn"].ConnectionString;
using (SqlConnection connection = new SqlConnection(ConnString))
{
SqlCommand cmd = new SqlCommand("InsertUpdateInvetoryLineItemInTempTable", connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
List <PharmaBusinessObjects.Transaction.PurchaseSaleBookLineItem> list = new List <PharmaBusinessObjects.Transaction.PurchaseSaleBookLineItem>();
list.Add(lineItem);
SqlParameter parameter = new SqlParameter();
parameter.SqlDbType = SqlDbType.Structured;
parameter.TypeName = "dbo.TableTypePurchaseSaleBookLineItem";
parameter.ParameterName = "@TableTypePurchaseSaleBookLineItem";
parameter.Value = CommonDaoMethods.CreateDataTable <PharmaBusinessObjects.Transaction.PurchaseSaleBookLineItem>(list);
cmd.Parameters.Add(parameter);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
PurchaseBookAmount obj = new PurchaseBookAmount()
{
PurchaseSaleBookLineItemID = row["PurchaseSaleBookLineItemID"] == null ? 0 : Convert.ToInt64(row["PurchaseSaleBookLineItemID"]),
PurchaseBookHeaderID = Convert.ToInt64(row["PurchaseSaleBookHeaderID"]),
BillAmount = Convert.ToInt64(row["BillAmount"]),
TaxAmount = Convert.ToInt64(row["TaxAmount"]),
CostAmount = Convert.ToInt64(row["CostAmount"]),
GrossAmount = Convert.ToInt64(row["GrossAmount"]),
SchemeAmount = Convert.ToInt64(row["SchemeAmount"]),
DiscountAmount = Convert.ToInt64(row["DiscountAmount"]),
SpecialDiscountAmount = Convert.ToInt64(row["SpecialDiscountAmount"]),
VolumeDiscountAmount = Convert.ToInt64(row["VolumeDiscountAmount"]),
TotalDiscountAmount = Convert.ToInt64(row["TotalDiscountAmount"])
};
purchaseBookAmounts.Add(obj);
}
}
}
return(purchaseBookAmounts);
}
catch (Exception ex)
{
throw ex;
}
}
private void FillFormForUpdate()
{
List <PurchaseBookAmount> amountList = applicationFacade.GetFinalAmountWithTaxForPurchase(purchaseBookHeader.PurchaseSaleBookHeaderID);
PurchaseBookAmount amount = amountList.FirstOrDefault(p => p.PurchaseSaleTypeCode.ToUpper() == PurchaseTypeCode.PurchaseType1);
if (amount != null)
{
lblAmount1.Text = amount.PurchaseSaleTypeName;
txtAmount1.Text = amount.Amount.ToString("#.##");
txtAmount1.Tag = amount.TaxApplicable.ToString("#.##");
txtIGST1.Text = amount.IGST.ToString("#.##");
}
amount = amountList.FirstOrDefault(p => p.PurchaseSaleTypeCode.ToUpper() == PurchaseTypeCode.PurchaseType2);
if (amount != null)
{
lblAmount2.Text = amount.PurchaseSaleTypeName;
txtAmount2.Text = amount.Amount.ToString("#.##");
txtAmount2.Tag = amount.TaxApplicable.ToString("#.##");
txtIGST2.Text = amount.IGST.ToString("#.##");
}
amount = amountList.FirstOrDefault(p => p.PurchaseSaleTypeCode.ToUpper() == PurchaseTypeCode.PurchaseType3);
if (amount != null)
{
lblAmount3.Text = amount.PurchaseSaleTypeName;
txtAmount3.Text = amount.Amount.ToString("#.##");
txtAmount3.Tag = amount.TaxApplicable.ToString("#.##");
txtIGST3.Text = amount.IGST.ToString("#.##");
}
amount = amountList.FirstOrDefault(p => p.PurchaseSaleTypeCode.ToUpper() == PurchaseTypeCode.PurchaseType4);
if (amount != null)
{
lblAmount4.Text = amount.PurchaseSaleTypeName;
txtAmount4.Text = amount.Amount.ToString("#.##");
txtAmount4.Tag = amount.TaxApplicable.ToString("#.##");
txtIGST4.Text = amount.IGST.ToString("#.##");
}
amount = amountList.FirstOrDefault(p => p.PurchaseSaleTypeCode.ToUpper() == PurchaseTypeCode.PurchaseType5);
if (amount != null)
{
lblAmount5.Text = amount.PurchaseSaleTypeName;
txtAmount5.Text = amount.Amount.ToString("#.##");
txtAmount5.Tag = amount.TaxApplicable.ToString("#.##");
txtIGST5.Text = amount.IGST.ToString("#.##");
}
amount = amountList.FirstOrDefault(p => p.PurchaseSaleTypeCode.ToUpper() == PurchaseTypeCode.PurchaseType6);
if (amount != null)
{
lblAmount6.Text = amount.PurchaseSaleTypeName;
txtAmount6.Text = amount.Amount.ToString("#.##");
txtAmount6.Tag = amount.TaxApplicable.ToString("#.##");
txtIGST6.Text = amount.IGST.ToString("#.##");
}
amount = amountList.FirstOrDefault(p => p.PurchaseSaleTypeCode.ToUpper() == PurchaseTypeCode.PurchaseType7);
if (amount != null)
{
lblAmount7.Text = amount.PurchaseSaleTypeName;
txtAmount7.Text = amount.Amount.ToString("#.##");
txtAmount7.Tag = amount.TaxApplicable.ToString("#.##");
txtIGST7.Text = amount.IGST.ToString("#.##");
}
SetTotalBillAmount();
}
