public DL_OpportunityBOMItemsViewModel GetOpportunityBOMList_BOMDownload(int OpportunityID, int BOMID, int State)
{
DL_OpportunityBOMItemsViewModel QuoteBOMView = new DL_OpportunityBOMItemsViewModel();
try
{
using (SqlConnection conn = new SqlConnection(GetConnectionString()))
{
//return cnn.Query<T>(sql).ToList();
conn.Open();
DataSet ds = new DataSet();
string SQLSP;
SQLSP = "Get_OpportunityBOMList_BOMDownload";
SqlCommand dCmd = new SqlCommand(SQLSP, conn);
dCmd.CommandType = CommandType.StoredProcedure;
dCmd.Parameters.Add(new SqlParameter("@OpportunityID", OpportunityID));
dCmd.Parameters.Add(new SqlParameter("@BOMID", BOMID));
dCmd.Parameters.Add(new SqlParameter("@State", State));
SqlDataAdapter da = new SqlDataAdapter(dCmd);
DataTable dt = new DataTable();
ds.Clear();
da.Fill(dt);
conn.Close();
List <DL_OpportunityBOMItem> BOMlst = new List <DL_OpportunityBOMItem>();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
DL_OpportunityBOMItem BOM = new DL_OpportunityBOMItem();
BOM.Description = dr["Description"].ToString();
BOM.ItemPrice = Convert.ToDecimal(dr["ItemPrice"].ToString());
BOM.Price = Convert.ToDecimal(dr["Price"].ToString());
BOM.MatthewsCode = dr["MatthewsCode"].ToString();
BOM.Qty = Convert.ToDecimal(dr["Qty"].ToString());
BOM.Category = dr["Category"].ToString();
BOM.CompanyName = dr["CompanyName"].ToString();
BOM.AccountContactEmail = dr["AccountContactEmail"].ToString();
BOM.DispatchAddress = dr["DispatchAddress"].ToString();
BOM.Discount = Convert.ToDecimal(dr["Discount"].ToString());
BOM.AfterDiscount = Convert.ToDecimal(dr["PriceAfterDiscount"].ToString());
BOM.FinalAgreedPrice = Convert.ToDecimal(dr["FinalAgreedPrice"].ToString());
BOM.QuoteNo = dr["QuoteNo"].ToString();
BOMlst.Add(BOM);
}
QuoteBOMView.BOMListViewModel = BOMlst;
}
return(QuoteBOMView);
}
}
catch (Exception ex)
{
return(QuoteBOMView);
}
}
private List <DL_OpportunityBOMItem> PopulateBOMDL(List <OpportunityBOMItem> BOMV)
{
List <DL_OpportunityBOMItem> lstBOMDL = new List <DL_OpportunityBOMItem>();
if (BOMV.Count > 0)
{
char[] charsToTrim = { ' ' };
foreach (var item in BOMV)
{
DL_OpportunityBOMItem dl = new DL_OpportunityBOMItem();
dl.OpportunityID = item.OpportunityID;
dl.OpportunityBOMListID = item.OpportunityBOMListID;
dl.BOMID = item.BOMID;
dl.BOMItemID = item.BOMItemID;
dl.Qty = item.Qty;
dl.ItemPrice = item.ItemPrice;
dl.Price = item.Price;
dl.Discount = item.Discount;
dl.FinalAgreedPrice = item.FinalAgreedPrice;
if (item.CustomDescription != null)
{
dl.CustomDescription = item.CustomDescription.Trim(charsToTrim);
dl.CustomCode = item.CustomCode;
}
dl.IsDiscountApply = item.IsDiscountApply;
dl.AfterDiscount = item.AfterDiscount;
dl.MaximumQty = item.MaximumQty;
dl.State = item.State;
if (item.IsInTotal == 1)
{
dl.IsInTotal = true;
}
else
{
dl.IsInTotal = false;
}
if (item.IsDecimalAllowed == 1)
{
dl.IsDecimalAllowed = true;
}
else
{
dl.IsDecimalAllowed = false;
}
dl.InkUsage = item.InkUsage;
lstBOMDL.Add(dl);
}
}
return(lstBOMDL);
}
public DL_OpportunityBOMItemsViewModel Get_OpportunityBOMItemsByOpportunityID(int OpportunityID, int BOMID, bool NewBOM, int State)
{
DL_OpportunityBOMItemsViewModel QuoteBOMView = new DL_OpportunityBOMItemsViewModel();
using (SqlConnection conn = new SqlConnection(GetConnectionString()))
{
//return cnn.Query<T>(sql).ToList();
conn.Open();
DataSet ds = new DataSet();
string SQLSP;
{ SQLSP = "Get_OpportunityBOMItemsByOpportunityID"; }
SqlCommand dCmd = new SqlCommand(SQLSP, conn);
dCmd.CommandType = CommandType.StoredProcedure;
dCmd.Parameters.Add(new SqlParameter("@OpportunityID", OpportunityID));
dCmd.Parameters.Add(new SqlParameter("@BOMID", BOMID));
dCmd.Parameters.Add(new SqlParameter("@NewBOM", NewBOM));
dCmd.Parameters.Add(new SqlParameter("@State", State));
SqlDataAdapter da = new SqlDataAdapter(dCmd);
DataTable dt = new DataTable();
ds.Clear();
da.Fill(dt);
conn.Close();
List <DL_OpportunityBOMItem> BOMlst = new List <DL_OpportunityBOMItem>();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
DL_OpportunityBOMItem BOM = new DL_OpportunityBOMItem();
BOM.OpportunityID = Convert.ToInt32(dr["OpportunityID"].ToString());
BOM.BOMID = Convert.ToInt32(dr["BOMID"].ToString());
BOM.BOMItemID = Convert.ToInt64(dr["BOMItemsID"].ToString());
BOM.Description = dr["Description"].ToString();
BOM.ItemPrice = Convert.ToDecimal(dr["ItemPrice"].ToString());
BOM.Price = Convert.ToDecimal(dr["Price"].ToString());
BOM.Qty = Convert.ToDecimal(dr["Qty"].ToString());
BOM.Category = dr["Category"].ToString();
BOM.SubCategory = dr["SubCategory"].ToString();
BOM.MatthewsCode = dr["ITEMID"].ToString();
BOM.OpportunityBOMListID = Convert.ToInt32(dr["OpportunityBOMListID"].ToString());
BOM.IsCustomParts = Convert.ToBoolean(dr["IsCustomParts"].ToString());
BOM.Discount = Convert.ToDecimal(dr["Discount"].ToString());
BOM.FinalAgreedPrice = Convert.ToDecimal(dr["Finalagreedprice"].ToString());
BOM.IsQtyFixed = Convert.ToBoolean(dr["IsQtyFixed"].ToString());
BOM.PriceAfterDiscount = Convert.ToDecimal(dr["PriceAfterDiscount"].ToString());
BOM.BOM = dr["BOM"].ToString();
BOM.MaximumQty = Convert.ToDecimal(dr["MaximumQty"].ToString());
BOM.ClosedDate = dr["ClosedDate"].ToString();
BOM.Stock = Convert.ToInt32(dr["Stock"].ToString());
BOM.State = State;
BOM.IsInTotal = Convert.ToBoolean(dr["IsInTotal"].ToString());
BOM.IsDecimalAllowed = Convert.ToBoolean(dr["IsDecimalAllowed"].ToString());
if (dr["IsDiscountApply"].ToString() != null && dr["IsDiscountApply"].ToString() != "")
{
BOM.IsDiscountApply = Convert.ToBoolean(dr["IsDiscountApply"].ToString());
}
else
{
BOM.IsDiscountApply = false;
}
if (BOM.IsDiscountApply == true)
{
BOM.AfterDiscount = ((BOM.ItemPrice) - (BOM.ItemPrice / 100) * BOM.Discount) * BOM.Qty;
}
else
{
BOM.AfterDiscount = (BOM.ItemPrice * BOM.Qty);
}
BOM.InkUsage = dr["InkUsage"].ToString();
BOMlst.Add(BOM);
}
QuoteBOMView.BOMListViewModel = BOMlst;
}
return(QuoteBOMView);
}
}
