private DL_OpportunityModel PopulateAssemblyDL(List <OpportunityCoverModel> Asmbly)
{
DL_OpportunityModel ret = new DL_OpportunityModel();
if (Asmbly == null)
{
return(ret);
}
foreach (var item in Asmbly)
{
ret.QuoteNo = item.QuoteNo;
ret.CompanyName = item.CompanyName;
ret.Representative = item.Representative;
ret.CustomerType = item.CustomerType;
ret.DeliveryDate = item.DeliveryDate;
ret.PONumber = item.PONumber;
ret.Authorisation = item.Authorisation;
ret.Campaign = item.Campaign;
ret.CampaignCode = item.CampaignCode;
ret.SalesPerson = item.SalesPerson;
ret.SaleTypeID = item.SaleTypeID;
}
return(ret);
}
private DL_OpportunityModel PopulateCustomerDL(List <OpportunityCoverModel> CUSDL)
{
DL_OpportunityModel ret = new DL_OpportunityModel();
if (CUSDL == null)
{
return(ret);
}
foreach (var item in CUSDL)
{
ret.QuoteNo = item.QuoteNo;
ret.DispatchAddress = item.DispatchAddress;
ret.AccountContactName = item.AccountContactName;
ret.AccountContactTitle = item.AccountContactTitle;
ret.AccountContactPhoneNo = item.AccountContactPhoneNo;
ret.AccountContactEmail = item.AccountContactEmail;
ret.FinanceDeal = item.FinanceDeal;
ret.FinanceType = item.FinanceType;
ret.FinanceApproved = item.FinanceApproved;
ret.FinanceTotalAmount = item.FinanceTotalAmount;
ret.FinancePeriod = item.FinancePeriod;
}
return(ret);
}
public string Update_OpportunityConsumableDetails(DL_OpportunityModel consu)
{
try
{
using (SqlConnection conn = new SqlConnection(GetConnectionString()))
{
DataSet ds = new DataSet();
SqlCommand dCmd = new SqlCommand("Update_OpportunityConsumableDetails", conn);
dCmd.CommandType = CommandType.StoredProcedure;
dCmd.Parameters.Add(new SqlParameter("@QuoteNo", consu.QuoteNo));
dCmd.Parameters.Add(new SqlParameter("@InkUsage", consu.InkUsage));
dCmd.Parameters.Add(new SqlParameter("@SolventUsage", consu.SolventUsage));
dCmd.Parameters.Add(new SqlParameter("@Comments", consu.Comments));
conn.Open();
dCmd.ExecuteNonQuery();
conn.Close();
return("");
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public ActionResult SaveConsumables(List <OpportunityCoverModel> Consumables)
{
DL_OpportunityModel cls = new DL_OpportunityModel();
QuoteBusinessLogic BL = new QuoteBusinessLogic();
cls = PopulateConsumableDL(Consumables);
string Saved = BL.BL_UpdateOpportunityConsumableDetails(cls);
return(Json(Saved, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveTerritorySplit(List <OpportunityCoverModel> Territory)
{
DL_OpportunityModel cls = new DL_OpportunityModel();
QuoteBusinessLogic BL = new QuoteBusinessLogic();
cls = PopulateTerritorySplitDL(Territory);
string Saved = BL.BL_UpdateOpportunityTerritorySplit(cls);
return(Json(Saved, JsonRequestBehavior.AllowGet));
}
public ActionResult SavePMComments(List <OpportunityCoverModel> pm)
{
DL_OpportunityModel cls = new DL_OpportunityModel();
QuoteBusinessLogic BL = new QuoteBusinessLogic();
cls = PopulatePMDL(pm);
string Saved = BL.BL_UpdateOpportunityPMComments(cls);
return(Json(Saved, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveAssembly(List <OpportunityCoverModel> Assembly)
{
DL_OpportunityModel Cust = new DL_OpportunityModel();
QuoteBusinessLogic BL = new QuoteBusinessLogic();
Cust = PopulateAssemblyDL(Assembly);
string Saved = BL.BL_UpdateOpportunityAssemblyDetails(Cust);
return(Json(Saved, JsonRequestBehavior.AllowGet));
}
private DL_OpportunityModel PopulatePMDL(List <OpportunityCoverModel> pm)
{
DL_OpportunityModel ret = new DL_OpportunityModel();
if (pm == null)
{
return(ret);
}
foreach (var item in pm)
{
ret.QuoteNo = item.QuoteNo;
ret.PMComments = item.PMComments;
}
return(ret);
}
private DL_OpportunityModel PopulateCHOPDL(List <OpportunityCoverModel> CHOP)
{
DL_OpportunityModel ret = new DL_OpportunityModel();
if (CHOP == null)
{
return(ret);
}
foreach (var item in CHOP)
{
ret.QuoteNo = item.QuoteNo;
ret.CHOPComments = item.CHOPComments;
}
return(ret);
}
private DL_OpportunityModel PopulateConsumableDL(List <OpportunityCoverModel> Consumable)
{
DL_OpportunityModel ret = new DL_OpportunityModel();
if (Consumable == null)
{
return(ret);
}
foreach (var item in Consumable)
{
ret.QuoteNo = item.QuoteNo;
ret.InkUsage = item.InkUsage;
ret.SolventUsage = item.SolventUsage;
ret.Comments = item.Comments;
}
return(ret);
}
private DL_OpportunityModel PopulateTerritorySplitDL(List <OpportunityCoverModel> TS)
{
DL_OpportunityModel ret = new DL_OpportunityModel();
if (TS == null)
{
return(ret);
}
foreach (var item in TS)
{
ret.QuoteNo = item.QuoteNo;
ret.Territory1Split = item.Territory1Split;
ret.Territory2Split = item.Territory2Split;
ret.Territory1ID = item.Territory1ID;
ret.Territory2ID = item.Territory2ID;
}
return(ret);
}
public string Update_OpportunityAssemblyDetails(DL_OpportunityModel Assembly)
{
try
{
using (SqlConnection conn = new SqlConnection(GetConnectionString()))
{
DataSet ds = new DataSet();
SqlCommand dCmd = new SqlCommand("Update_OpportunityAssemblyDetails", conn);
dCmd.CommandType = CommandType.StoredProcedure;
dCmd.Parameters.Add(new SqlParameter("@QuoteNo", Assembly.QuoteNo));
dCmd.Parameters.Add(new SqlParameter("@CompanyName", Assembly.CompanyName));
dCmd.Parameters.Add(new SqlParameter("@Representative", Assembly.Representative));
dCmd.Parameters.Add(new SqlParameter("@CustomerType", Assembly.CustomerType));
if (Assembly.DeliveryDate.Year != 1)
{
dCmd.Parameters.Add(new SqlParameter("@DeliveryDate", Assembly.DeliveryDate));
}
else
{
dCmd.Parameters.Add(new SqlParameter("@DeliveryDate", null));
}
dCmd.Parameters.Add(new SqlParameter("@PONumber", Assembly.PONumber));
dCmd.Parameters.Add(new SqlParameter("@Authorisation", Assembly.Authorisation));
dCmd.Parameters.Add(new SqlParameter("@Campaign", Assembly.Campaign));
dCmd.Parameters.Add(new SqlParameter("@CampaignCode", Assembly.CampaignCode));
dCmd.Parameters.Add(new SqlParameter("@SalesPerson", Assembly.SalesPerson));
dCmd.Parameters.Add(new SqlParameter("@SaleTypeID", Assembly.SaleTypeID));
conn.Open();
dCmd.ExecuteNonQuery();
conn.Close();
return("");
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
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 string BL_UpdateOpportunityTerritorySplit(DL_OpportunityModel TS)
{
string ret = this.CustomerDL.Update_OpportunityTerritorySplit(TS);
return(ret);
}
public string BL_UpdateOpportunityPMComments(DL_OpportunityModel pm)
{
string ret = this.CustomerDL.Update_OpportunityPMComments(pm);
return(ret);
}
public string BL_UpdateOpportunityCHOPComments(DL_OpportunityModel CHOP)
{
string ret = this.CustomerDL.Update_OpportunityCHOPComments(CHOP);
return(ret);
}
public string BL_UpdateOpportunityConsumableDetails(DL_OpportunityModel Consumable)
{
string ret = this.CustomerDL.Update_OpportunityConsumableDetails(Consumable);
return(ret);
}
public string BL_UpdateOpportunityAssemblyDetails(DL_OpportunityModel Assembly)
{
string ret = this.CustomerDL.Update_OpportunityAssemblyDetails(Assembly);
return(ret);
}
public string BL_UpdateOpportunityCustomerDetails(DL_OpportunityModel customer)
{
string ret = this.CustomerDL.Update_OpportunityCustomerDetails(customer);
return(ret);
}
