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;
}
}
public long InsertUpdateTempPurchaseBookHeader(PharmaBusinessObjects.Transaction.PurchaseSaleBookHeader header)
{
try
{
long PurchaseSaleBookHeaderID = 0;
string ConnString = ConfigurationManager.ConnectionStrings["PharmaDBConn"].ConnectionString;
using (SqlConnection connection = new SqlConnection(ConnString))
{
SqlCommand cmd = new SqlCommand("InsertUpdateInvetoryHeadersInTempTable", connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
List <PharmaBusinessObjects.Transaction.PurchaseSaleBookHeader> list = new List <PharmaBusinessObjects.Transaction.PurchaseSaleBookHeader>();
list.Add(header);
SqlParameter parameter = new SqlParameter();
parameter.SqlDbType = SqlDbType.Structured;
parameter.TypeName = "dbo.TableTypePurchaseSaleBookHeader";
parameter.ParameterName = "@TableTypePurchaseSaleBookHeader";
parameter.Value = CommonDaoMethods.CreateDataTable <PharmaBusinessObjects.Transaction.PurchaseSaleBookHeader>(list);
cmd.Parameters.Add(parameter);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt != null && dt.Rows.Count > 0)
{
PurchaseSaleBookHeaderID = Convert.ToInt64(dt.Rows[0]["PurchaseSaleBookHeaderID"]);
}
}
return(PurchaseSaleBookHeaderID);
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveAllTempTransaction(List <long> tempReceiptPaymentIds)
{
try
{
using (PharmaDBEntities context = new PharmaDBEntities())
{
SqlConnection connection = (SqlConnection)context.Database.Connection;
SqlCommand cmd = new SqlCommand("SaveReceiptPaymentData", connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
List <PharmaBusinessObjects.Transaction.ReceiptPayment.TempReceiptPayment> list = new List <PharmaBusinessObjects.Transaction.ReceiptPayment.TempReceiptPayment>();
foreach (long id in tempReceiptPaymentIds)
{
list.Add(new PharmaBusinessObjects.Transaction.ReceiptPayment.TempReceiptPayment()
{
ReceiptPaymentID = id
});
}
SqlParameter parameter = new SqlParameter();
parameter.SqlDbType = SqlDbType.Structured;
parameter.TypeName = "dbo.TableTypeIds";
parameter.ParameterName = "@ReceiptPaymentIDs";
parameter.Value = CommonDaoMethods.CreateDataTable <PharmaBusinessObjects.Transaction.ReceiptPayment.TempReceiptPayment>(list);
cmd.Parameters.Add(parameter);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <PharmaBusinessObjects.Transaction.PurchaseSaleBookLineItem> InsertUpdateTempPurchaseBookLineItemForSale(PharmaBusinessObjects.Transaction.PurchaseSaleBookLineItem lineItem)
{
try
{
List <PharmaBusinessObjects.Transaction.PurchaseSaleBookLineItem> lineItemList = new List <PharmaBusinessObjects.Transaction.PurchaseSaleBookLineItem>();
//List<PurchaseBookAmount> purchaseBookAmounts = new List<PurchaseBookAmount>();
// lineItem.ExpiryDate = DateTime.Now;
lineItem.CreatedBy = LoggedInUser.Username;
lineItem.ModifiedBy = LoggedInUser.Username;
lineItem.CreatedOn = DateTime.Now;
lineItem.ModifiedOn = DateTime.Now;
using (PharmaDBEntities context = new PharmaDBEntities())
{
SqlConnection connection = (SqlConnection)context.Database.Connection;
SqlCommand cmd = new SqlCommand("InsertUpdateInvetoryLineItemInTempTableForSale", 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)
{
PharmaBusinessObjects.Transaction.PurchaseSaleBookLineItem item = new PharmaBusinessObjects.Transaction.PurchaseSaleBookLineItem();
item.PurchaseSaleBookLineItemID = Convert.ToInt32(row["PurchaseSaleBookLineItemID"]);
item.PurchaseSaleBookHeaderID = Convert.ToInt32(row["PurchaseSaleBookHeaderID"]);
item.ItemCode = Convert.ToString(row["ItemCode"]);
item.ItemName = Convert.ToString(row["ItemName"]);
item.SaleRate = Convert.IsDBNull(row["SaleRate"]) ? 0 : Convert.ToDecimal(row["SaleRate"]);
item.SpecialRate = Convert.IsDBNull(row["SpecialRate"]) ? 0 : Convert.ToDecimal(row["SpecialRate"]);
item.WholeSaleRate = Convert.IsDBNull(row["WholeSaleRate"]) ? 0 : Convert.ToDecimal(row["WholeSaleRate"]);
item.PurchaseBillDate = Convert.IsDBNull(row["PurchaseBillDate"]) ? DateTime.MinValue : Convert.ToDateTime(row["PurchaseBillDate"]);
item.PurchaseVoucherNumber = Convert.ToString(row["PurchaseVoucherNumber"]);
item.PurchaseSrlNo = Convert.IsDBNull(row["PurchaseSrlNo"]) ? 0 : Convert.ToInt32(row["PurchaseSrlNo"]);
item.Quantity = Convert.IsDBNull(row["Quantity"]) ? 0 : Convert.ToInt32(row["Quantity"]);
item.FreeQuantity = Convert.IsDBNull(row["FreeQuantity"]) ? 0 : Convert.ToInt32(row["FreeQuantity"]);
item.Scheme1 = Convert.IsDBNull(row["Scheme1"]) ? 0 : Convert.ToDecimal(row["Scheme1"]);
item.Scheme2 = Convert.IsDBNull(row["Scheme2"]) ? 0 : Convert.ToDecimal(row["Scheme2"]);
item.IsHalfScheme = Convert.IsDBNull(row["IsHalfScheme"]) ? false : Convert.ToBoolean(row["IsHalfScheme"]);
item.HalfSchemeRate = Convert.IsDBNull(row["HalfSchemeRate"]) ? 0 : Convert.ToDecimal(row["HalfSchemeRate"]);
//item.IsQTRScheme = Convert.IsDBNull(row["IsQTRScheme"]) ? false : Convert.ToBoolean(row["IsQTRScheme"]);
item.SpecialDiscount = Convert.IsDBNull(row["SpecialDiscount"]) ? 0 : Convert.ToDecimal(row["SpecialDiscount"]);
item.PurchaseSaleTax = Convert.IsDBNull(row["SalePurchaseTax"]) ? 0 : Convert.ToDecimal(row["SalePurchaseTax"]);
//item.IsFixedDiscount = Convert.IsDBNull(row["IsFixedDiscount"]) ? false : Convert.ToBoolean(row["IsFixedDiscount"]);
item.SurCharge = Convert.IsDBNull(row["SurCharge"]) ? 0 : Convert.ToDecimal(row["SurCharge"]);
item.SGST = Convert.IsDBNull(row["SGST"]) ? 0 : Convert.ToDecimal(row["SGST"]);
item.IGST = Convert.IsDBNull(row["IGST"]) ? 0 : Convert.ToDecimal(row["IGST"]);
item.CGST = Convert.IsDBNull(row["CGST"]) ? 0 : Convert.ToDecimal(row["CGST"]);
item.Amount = Convert.IsDBNull(row["Amount"]) ? 0 : Convert.ToDecimal(row["Amount"]);
item.DiscountQuantity = Convert.IsDBNull(row["DiscountQuantity"]) ? 0 : Convert.ToDecimal(row["DiscountQuantity"]);
item.VolumeDiscount = Convert.IsDBNull(row["VolumeDiscount"]) ? 0 : Convert.ToDecimal(row["VolumeDiscount"]);
item.ConversionRate = Convert.IsDBNull(row["ConversionRate"]) ? 0 : Convert.ToDecimal(row["ConversionRate"]);
item.MRP = Convert.IsDBNull(row["MRP"]) ? 0 : Convert.ToDecimal(row["MRP"]);
item.ExpiryDate = Convert.IsDBNull(row["ExpiryDate"]) ? DateTime.MinValue : Convert.ToDateTime(row["ExpiryDate"]);
item.WholeSaleRate = Convert.IsDBNull(row["WholeSaleRate"]) ? 0 : Convert.ToDecimal(row["WholeSaleRate"]);
item.SpecialRate = Convert.IsDBNull(row["SpecialRate"]) ? 0 : Convert.ToDecimal(row["SpecialRate"]);
item.LocalCentral = Convert.ToString(row["LocalCentral"]);
item.PurchaseSaleTypeCode = Convert.ToString(row["PurchaseSaleTypeCode"]);
item.Discount = Convert.IsDBNull(row["Discount"]) ? 0 : Convert.ToDecimal(row["Discount"]);
item.Batch = Convert.ToString(row["Batch"]);
item.BatchNew = Convert.ToString(row["BatchNew"]);
item.EffecivePurchaseSaleRate = Convert.IsDBNull(row["EffecivePurchaseSaleRate"]) ? 0 : Convert.ToDecimal(row["EffecivePurchaseSaleRate"]);
item.PurchaseSaleRate = Convert.IsDBNull(row["PurchaseSaleRate"]) ? 0 : Convert.ToDecimal(row["PurchaseSaleRate"]);
item.FifoID = Convert.IsDBNull(row["Fifoid"]) ? 0 : Convert.ToInt32(row["Fifoid"]);
item.SchemeAmount = Convert.IsDBNull(row["SchemeAmount"]) ? 0 : Convert.ToDecimal(row["SchemeAmount"]);
item.GrossAmount = Convert.IsDBNull(row["GrossAmount"]) ? 0 : Convert.ToDecimal(row["GrossAmount"]);
item.TaxAmount = Convert.IsDBNull(row["TaxAmount"]) ? 0 : Convert.ToDecimal(row["TaxAmount"]);
item.TotalDiscountAmount = Convert.IsDBNull(row["DiscountAmount"]) ? 0 : Convert.ToDecimal(row["DiscountAmount"]);
item.CostAmount = Convert.IsDBNull(row["BillAmount"]) ? 0 : Convert.ToDecimal(row["BillAmount"]);
lineItemList.Add(item);
//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(lineItemList);
}
catch (Exception ex)
{
throw ex;
}
}
