public DL_OpportunityBOMItemsViewModel GetOpportunityPickingList_BOMDownload(int OpportunityID, int BOMID, int State)
{
DL_OpportunityBOMItemsViewModel ret = new DL_OpportunityBOMItemsViewModel();
ret = this.CustomerDL.GetOpportunityPickingList_BOMDownload(OpportunityID, BOMID, State);
return(ret);
}
public DL_OpportunityBOMItemsViewModel GetOpportunityBOMChildItemsByBOMItemID(int OpportunityID, string BOMItemID, int BOMID, int State)
{
DL_OpportunityBOMItemsViewModel ret = new DL_OpportunityBOMItemsViewModel();
ret = this.CustomerDL.Get_OpportunityBOMChildItemsByBOMItemID(OpportunityID, BOMItemID, BOMID, State);
return(ret);
}
public DL_OpportunityBOMItemsViewModel GetOpportunityBOMItemsByOpportunityID(int OpportunityID, int BOMID, bool NewBOM, int State)
{
DL_OpportunityBOMItemsViewModel ret = new DL_OpportunityBOMItemsViewModel();
ret = this.CustomerDL.Get_OpportunityBOMItemsByOpportunityID(OpportunityID, BOMID, NewBOM, State);
return(ret);
}
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);
}
}
// GET The BOM List
public ActionResult GetChildBOMList(int OpportunityID, string BOMitemID, int BOMID, int State)
{
DL_OpportunityBOMItemsViewModel DLVM = new DL_OpportunityBOMItemsViewModel();
QuoteBOMBusinessLogic BL = new QuoteBOMBusinessLogic();
DLVM = BL.GetOpportunityBOMChildItemsByBOMItemID(OpportunityID, BOMitemID, BOMID, State);
OpportunityBOMItemsViewModel view = PopulateBOMList(DLVM, "");
return(Json(view.BOMListViewModel, JsonRequestBehavior.AllowGet));
}
public byte[] DownloadPickingSlip(int OpportunityID, int BOMID, int State)
{
_documet = new Document();
_documet.SetPageSize(PageSize.A4);
_documet.SetMargins(5f, 5f, 20f, 5f);
_pdfTable.WidthPercentage = 100;
_pdfTable.HorizontalAlignment = Element.ALIGN_LEFT;
_fontStyle = FontFactory.GetFont("Tahoma", 8f, 1);
PdfWriter docWrite = PdfWriter.GetInstance(_documet, _memoryStream);
_documet.Open();
float[] sizes = new float[_maxColumns];
sizes[0] = 40;
sizes[1] = 40;
sizes[2] = 80;
sizes[3] = 20;
//for (var i = 0; i < _maxColumns; i++)
//{
// if (i == 2) sizes[i] = 20;
// else sizes[i] = 100;
//}
//--Get the BOM details'
PDFDownloadBusinessLogic BL = new PDFDownloadBusinessLogic();
QuoteBusinessLogic QBL = new QuoteBusinessLogic();
DLVM = BL.GetOpportunityPickingList_BOMDownload(OpportunityID, BOMID, State);
this.ReportHeader();
this.EmptyRow(2, _maxColumns);
this.DownloadBOM_ReportBody();
_pdfTable.SetWidths(sizes);
_pdfTable.HeaderRows = 2;
_documet.Add(_pdfTable);
_documet.Close();
return(_memoryStream.ToArray());
}
// GET The BOM List
public ActionResult GetBOMList(int OpportunityID, int BOMID, string QuoteNo, string Name, bool NewBOM, bool ViewBOM, bool PMView)
{
int State;
if (PMView == false)
{
State = (int)BOMState.Sales;
}
else
{
State = (int)BOMState.PM;
}
DL_OpportunityBOMItemsViewModel DLVM = new DL_OpportunityBOMItemsViewModel();
QuoteBOMBusinessLogic BL = new QuoteBOMBusinessLogic();
DLVM = BL.GetOpportunityBOMItemsByOpportunityID(OpportunityID, BOMID, NewBOM, State);
OpportunityBOMItemsViewModel view = PopulateBOMList(DLVM, QuoteNo);
view.ItemMasterName = Name;
view.ViewBOM = ViewBOM;
return(View("BOMList", view));
}
//---------------------------------Populate Data to View Modal and from BL
private OpportunityBOMItemsViewModel PopulateBOMList(DL_OpportunityBOMItemsViewModel BOMDL, string QuoteNo)
{
OpportunityBOMItemsViewModel ret = new OpportunityBOMItemsViewModel();
List <OpportunityBOMItem> bomlst = new List <OpportunityBOMItem>();
if (BOMDL == null)
{
return(ret);
}
if (BOMDL.BOMListViewModel == null)
{
OpportunityBOMItem Model = new OpportunityBOMItem();
bomlst.Add(Model);
ret.BOMListViewModel = bomlst;
ret.QuoteNo = QuoteNo;
return(ret);
}
if (BOMDL.BOMListViewModel.Count > 0)
{
decimal GrandTotal = 0;
decimal GrandTotalAfterDiscount = 0;
foreach (var item in BOMDL.BOMListViewModel)
{
OpportunityBOMItem Model = new OpportunityBOMItem();
Model.OpportunityID = item.OpportunityID;
Model.BOMItemID = item.BOMItemID;
Model.BOMID = item.BOMID;
Model.Description = item.Description;
Model.ItemPrice = item.ItemPrice;
Model.Price = item.Price;
Model.Category = item.Category;
Model.SubCategory = item.SubCategory;
Model.Qty = item.Qty;
Model.MatthewsCode = item.MatthewsCode;
Model.OpportunityBOMListID = item.OpportunityBOMListID;
Model.Category = item.Category;
Model.IsDiscountApply = item.IsDiscountApply;
Model.Discount = item.Discount;
Model.AfterDiscount = item.AfterDiscount;
Model.IsQtyFixed = item.IsQtyFixed;
Model.MaximumQty = item.MaximumQty;
Model.Stock = item.Stock;
Model.State = item.State;
if (item.IsInTotal == true)
{
Model.IsInTotal = 1;
GrandTotal += item.Price;
GrandTotalAfterDiscount += item.PriceAfterDiscount;
}
else
{
Model.IsInTotal = 0;
}
if (item.IsDecimalAllowed == true)
{
Model.IsDecimalAllowed = 1;
}
else
{
Model.IsDecimalAllowed = 0;
}
ret.FinalAgreedPrice = item.FinalAgreedPrice;
ret.Discount = item.Discount;
ret.IsCustomParts = item.IsCustomParts;
ret.OpportunityID = item.OpportunityID;
ret.BOMID = item.BOMID;
ret.BOM = item.BOM;
ret.ClosedDate = item.ClosedDate;
ret.InkUsage = item.InkUsage;
bomlst.Add(Model);
}
ret.GrandTotalAfterDiscount = GrandTotalAfterDiscount;
ret.GrandTotal = GrandTotal;
ret.BOMListViewModel = bomlst;
ret.QuoteNo = QuoteNo;
}
return(ret);
}
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);
}
}
