public DL_QuoteViewModel BL_GetOpportunityByQuoteNo(string QuoteNo) { DL_QuoteViewModel ret = new DL_QuoteViewModel(); ret = this.CustomerDL.GetOpportunityByQuoteNo(QuoteNo); return(ret); }
public DL_QuoteViewModel GetCustomersList() { DL_QuoteViewModel ret = new DL_QuoteViewModel(); //ret = this.ItemDetailsDL.LaodData(); ret = this.CustomerDL.LoadQuoteList(); return(ret); }
// GET: Customer/Edit/5 public ActionResult Edit(string QuoteNo) { DL_QuoteViewModel view = new DL_QuoteViewModel(); QuoteBusinessLogic CBL = new QuoteBusinessLogic(); QuoteViewModel CustomerView = new QuoteViewModel(); view = CBL.BL_GetOpportunityByQuoteNo(QuoteNo); QuoteViewModel ViewModel = PopulateBOMViewModel(view); ViewBag.Territorylist = ViewModel.TerritoryListModel; return(View("Edit", ViewModel)); }
public DL_QuoteViewModel LoadQuoteList() { DL_QuoteViewModel QuoteList = new DL_QuoteViewModel(); using (SqlConnection conn = new SqlConnection(GetConnectionString())) { //return cnn.Query<T>(sql).ToList(); conn.Open(); DataSet ds = new DataSet(); SqlCommand dCmd = new SqlCommand("Get_OpportunityList", conn); dCmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(dCmd); DataTable dt = new DataTable(); ds.Clear(); da.Fill(dt); conn.Close(); if (dt != null && dt.Rows.Count > 0) { QuoteList.QuoteCustomers = new List <DL_OpportunityModel>(); foreach (DataRow dr in dt.Rows) { DL_OpportunityModel x = new DL_OpportunityModel(); x.Opportunity = dr["opportunity"].ToString(); x.CompanyName = dr["Name"].ToString(); x.QuoteNo = dr["map_QuoteNumber"].ToString(); x.SalesPerson = dr["cvn_SalespersonName"].ToString(); QuoteList.QuoteCustomers.Add(x); } } //var das = ds.Tables[0].AsEnumerable(); return(QuoteList); } }
public ActionResult Index(string QuoteNo = "") { if (QuoteNo == "") { DL_QuoteViewModel QuoteLst = new DL_QuoteViewModel(); QuoteViewModel QuoteVM = new QuoteViewModel(); QuoteBusinessLogic BL = new QuoteBusinessLogic(); QuoteLst = BL.GetCustomersList(); QuoteViewModel CustLst = PopulateQuoteViewModel(QuoteLst); return(View(CustLst)); } else { DL_QuoteViewModel view = new DL_QuoteViewModel(); QuoteBusinessLogic CBL = new QuoteBusinessLogic(); QuoteViewModel CustomerView = new QuoteViewModel(); view = CBL.BL_GetOpportunityByQuoteNo(QuoteNo); QuoteViewModel ViewModel = PopulateBOMViewModel(view); return(View("Edit", ViewModel)); } }
private QuoteViewModel PopulateQuoteViewModel(DL_QuoteViewModel QuoteList) { QuoteViewModel ret = new QuoteViewModel(); List <OpportunityCoverModel> Custlst = new List <OpportunityCoverModel>(); if (QuoteList == null) { return(ret); } foreach (var item in QuoteList.QuoteCustomers) { OpportunityCoverModel Model = new OpportunityCoverModel(); Model.Opportunity = item.Opportunity; Model.CompanyName = item.CompanyName; Model.DeliveryDate = item.DeliveryDate; Model.QuoteNo = item.QuoteNo; Model.SalesPerson = item.SalesPerson; Custlst.Add(Model); } ret.QuoteCustomerListModel = Custlst; return(ret); }
public DL_QuoteViewModel GetOpportunityByQuoteNo(string QuoteNo) { DL_QuoteViewModel QuoteList = new DL_QuoteViewModel(); using (SqlConnection conn = new SqlConnection(GetConnectionString())) { //return cnn.Query<T>(sql).ToList(); conn.Open(); DataSet ds = new DataSet(); SqlCommand dCmd = new SqlCommand("Get_OpportunityByQuoteNo", conn); dCmd.CommandType = CommandType.StoredProcedure; dCmd.Parameters.Add(new SqlParameter("@QuoteNo", QuoteNo)); //dCmd.Parameters.Add(new SqlParameter("@parameter1", parameter1)); SqlDataAdapter da = new SqlDataAdapter(dCmd); DataTable dt = new DataTable(); ds.Clear(); da.Fill(dt); conn.Close(); DL_QuoteViewModel x = new DL_QuoteViewModel(); if (dt != null && dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; x.ID = Convert.ToInt32(dr["ID"].ToString()); x.Opportunity = dr["Opportunity"].ToString(); x.ClosedDate = dr["ClosedDate"].ToString(); x.Representative = dr["Representative"].ToString(); x.CompanyName = dr["CompanyName"].ToString(); x.CustomerType = dr["CustomerType"].ToString(); //if (dr["LeadTime"].ToString() != "0") //{ x.DeliveryDate = Convert.ToDateTime(dr["DeliveryDate"].ToString()); } //else //{ // x.DeliveryDate = DateTime.Now; //} if (dr["DeliveryDate"].ToString() == "") { x.DeliveryDate = DateTime.Now; } else { x.DeliveryDate = Convert.ToDateTime(dr["DeliveryDate"].ToString()); } x.CalcDeliveryDate = Convert.ToDateTime(dr["CalcDeliveryDate"].ToString()); x.QuoteNo = dr["QuoteNo"].ToString(); x.PONumber = dr["PONumber"].ToString(); x.Authorisation = dr["Authorisation"].ToString(); x.Campaign = dr["Campaign"].ToString(); x.CampaignCode = dr["CampaignCode"].ToString(); x.Territory1ID = dr["Territory1ID"].ToString(); x.Territory2ID = dr["Territory2ID"].ToString(); if (dr["Territory1Split"].ToString() != "") { x.Territory1Split = Convert.ToInt32(dr["Territory1Split"].ToString()); } else { x.Territory1Split = 0; } if (dr["Territory2Split"].ToString() != "") { x.Territory2Split = Convert.ToInt32(dr["Territory2Split"].ToString()); } else { x.Territory2Split = 0; } x.DispatchAddress = dr["DispatchAddress"].ToString(); x.AccountContactName = dr["AccountContactName"].ToString(); x.AccountContactTitle = dr["AccountContactTitle"].ToString(); x.AccountContactPhoneNo = dr["AccountContactPhoneNo"].ToString(); x.AccountContactEmail = dr["AccountContactEmail"].ToString(); x.FinanceDeal = dr["FinanceDeal"].ToString(); x.FinanceType = dr["FinanceType"].ToString(); x.FinanceApproved = dr["FinanceApproved"].ToString(); if (dr["FinanceTotalAmount"].ToString() != "") { x.FinanceTotalAmount = Convert.ToDecimal(dr["FinanceTotalAmount"].ToString()); } else { x.FinanceTotalAmount = 0; } if (dr["FinancePeriod"].ToString() == "" || dr["FinancePeriod"].ToString() == null) { x.FinancePeriod = 0; } else { x.FinancePeriod = Convert.ToInt32(dr["FinancePeriod"].ToString()); } x.InkUsage = dr["InkUsage"].ToString(); x.SolventUsage = dr["SolventUsage"].ToString(); x.Comments = dr["Comments"].ToString(); x.SalesPerson = dr["SalesPerson"].ToString(); x.CHOPComments = dr["CHOPComments"].ToString(); x.CustomerCode = dr["CustomerCode"].ToString(); if (dr["SaleTypeID"].ToString() != "") { x.SaleTypeID = Convert.ToInt32(dr["SaleTypeID"].ToString()); } else { x.SaleTypeID = 0; } } conn.Open(); dCmd = new SqlCommand("Get_OpportunityBOMListBYOpportunityID", conn); dCmd.CommandType = CommandType.StoredProcedure; dCmd.Parameters.Add(new SqlParameter("@OpportunityID", x.ID)); //dCmd.Parameters.Add(new SqlParameter("@parameter1", parameter1)); da = new SqlDataAdapter(dCmd); dt = new DataTable(); ds.Clear(); da.Fill(dt); conn.Close(); List <DL_BOMListModel> QL = new List <DL_BOMListModel>(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { DL_BOMListModel l = new DL_BOMListModel(); l.BOMID = Convert.ToInt32(dr["BOMID"].ToString()); l.Name = dr["BOM"].ToString(); //if (dr["OpportunityBOMListID"].ToString() != "") { l.OpportunityBOMListID = Convert.ToInt32(dr["OpportunityBOMListID"].ToString()); } if (dr["OpportunityID"].ToString() != "") { l.OpportunityID = Convert.ToInt32(dr["OpportunityID"].ToString()); } if (dr["TotalPrice"] != DBNull.Value) { l.TotalPrice = Convert.ToDecimal(dr["TotalPrice"].ToString()); } else { l.TotalPrice = 0; } l.Discount = Convert.ToDecimal(dr["Discount"].ToString()); l.PriceAfterDiscount = Convert.ToDecimal(dr["PriceAfterDiscount"].ToString()); l.FinalAgreedPrice = Convert.ToDecimal(dr["FinalAgreedPrice"].ToString()); l.ClosedDate = dr["ClosedDate"].ToString(); QL.Add(l); } x.BOMListModel = QL; } else { x.BOMListModel = QL; } conn.Open(); dCmd = new SqlCommand("Get_Territory", conn); dCmd.CommandType = CommandType.StoredProcedure; da = new SqlDataAdapter(dCmd); dt = new DataTable(); ds.Clear(); da.Fill(dt); conn.Close(); List <DL_Territory> TL = new List <DL_Territory>(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { DL_Territory l = new DL_Territory(); l.ID = dr["SALESDISTRICTID"].ToString(); l.Description = dr["DESCRIPTION"].ToString(); TL.Add(l); } x.TerritoryList = TL; } else { x.TerritoryList = TL; } //Get Sale Types conn.Open(); dCmd = new SqlCommand("Get_SaleTypes", conn); dCmd.CommandType = CommandType.StoredProcedure; da = new SqlDataAdapter(dCmd); dt = new DataTable(); ds.Clear(); da.Fill(dt); conn.Close(); List <DL_SaleType> SL = new List <DL_SaleType>(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { DL_SaleType l = new DL_SaleType(); l.ID = dr["ID"].ToString(); l.SaleType = dr["SaleType"].ToString(); SL.Add(l); } x.SaleTypeList = SL; } else { x.SaleTypeList = SL; } return(x); } }
private QuoteViewModel PopulateBOMViewModel(DL_QuoteViewModel view) { QuoteViewModel ret = new QuoteViewModel(); if (view == null) { return(ret); } else { ret.QuoteID = view.ID; ret.Opportunity = view.Opportunity; ret.ClosedDate = view.ClosedDate; ret.Representative = view.Representative; ret.CompanyName = view.CompanyName; ret.CustomerType = view.CustomerType; ret.DeliveryDate = view.DeliveryDate; ret.QuoteNo = view.QuoteNo; ret.PONumber = view.PONumber; ret.Authorisation = view.Authorisation; ret.Campaign = view.Campaign; ret.CampaignCode = view.CampaignCode; ret.Territory1ID = view.Territory1ID; ret.Territory2ID = view.Territory2ID; ret.Territory1Split = view.Territory1Split; ret.Territory2Split = view.Territory2Split; ret.DispatchAddress = view.DispatchAddress; ret.AccountContactName = view.AccountContactName; ret.AccountContactTitle = view.AccountContactTitle; ret.AccountContactPhoneNo = view.AccountContactPhoneNo; ret.AccountContactEmail = view.AccountContactEmail; ret.FinanceDeal = view.FinanceDeal; ret.FinanceType = view.FinanceType; ret.FinanceApproved = view.FinanceApproved; ret.FinanceTotalAmount = view.FinanceTotalAmount; ret.FinancePeriod = view.FinancePeriod; ret.InkUsage = view.InkUsage; ret.SolventUsage = view.SolventUsage; ret.Comments = view.Comments; ret.SalesPerson = view.SalesPerson; ret.CHOPComments = view.CHOPComments; ret.ClosedDate = view.ClosedDate; ret.CalcDeliveryDate = view.CalcDeliveryDate; ret.DeliveryDate = view.DeliveryDate; ret.CustomerCode = view.CustomerCode; ret.SaleTypeID = view.SaleTypeID; } List <BOMListModel> Linelst = new List <BOMListModel>(); if (view.BOMListModel.Count > 0) { foreach (var item in view.BOMListModel) { BOMListModel l = new BOMListModel(); l.BOMID = item.BOMID; l.OpportunityBOMListID = item.OpportunityBOMListID; l.OpportunityID = Convert.ToInt32(item.OpportunityID); l.Name = item.Name; l.TotalPrice = Convert.ToDecimal(item.TotalPrice); l.Discount = item.Discount; l.PriceAfterDiscount = item.PriceAfterDiscount; l.FinalAgreedPrice = item.FinalAgreedPrice; l.ClosedDate = item.ClosedDate; Linelst.Add(l); } ret.BOMListModel = Linelst; } else { ret.BOMListModel = Linelst; } List <TerritoryModel> Territorylst = new List <TerritoryModel>(); if (view.TerritoryList.Count > 0) { foreach (var item in view.TerritoryList) { TerritoryModel l = new TerritoryModel(); l.ID = item.ID; l.Description = item.Description; Territorylst.Add(l); } ret.TerritoryListModel = Territorylst; } else { ret.TerritoryListModel = Territorylst; } List <SaleModel> Salelst = new List <SaleModel>(); if (view.TerritoryList.Count > 0) { foreach (var item in view.SaleTypeList) { SaleModel l = new SaleModel(); l.ID = item.ID; l.SaleType = item.SaleType; Salelst.Add(l); } ret.SaleListModel = Salelst; } else { ret.TerritoryListModel = Territorylst; } return(ret); }