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);
}
