public object CreateNRF(int str_CustomerCode, string str_Addres, string str_City, string str_Industry, string str_BranchName, string str_NRFService, string str_Capacity, string str_InfraType, int int_LOB, int int_Distance, string str_POCName, string str_POCCOntact, string str_POCEmail, int int_MRC, int int_OTC, int int_ROI, int int_Building, int int_Area, int int_Infra, string str_Region, string str_TransactionBy)
{
string[,] para =
{
{ "@CustomerCode", str_CustomerCode.ToString() },
{ "@SiteAddress", str_Addres },
{ "@City", str_City },
{ "@Industry", str_Industry },
{ "@BranchName", str_BranchName },
{ "@NRFService", str_NRFService },
{ "@Capacity", str_Capacity },
{ "@InfraType", str_InfraType },
{ "@LOB", int_LOB.ToString() },
{ "@Distance", Convert.ToString(int_Distance) },
{ "@POCName", str_POCName },
{ "@POCContact", str_POCCOntact },
{ "@POCEmail", str_POCEmail },
{ "@MRC", int_MRC.ToString() },
{ "@OTC", int_OTC.ToString() },
{ "@ROI", int_ROI.ToString() },
{ "@Building", int_Building.ToString() },
{ "@Area", int_Area.ToString() },
{ "@Infra", int_Area.ToString() },
{ "@Region", str_Region },
{ "@TransactionBy", str_TransactionBy }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectnrfid = objDBAcess.InsertProc_WithOutput("sp_InsertNRFNew", para, "@NRFID");
return(objectnrfid);
}
/*public object CreateOpportunity(string OppName, string PartnerID, string CustCode, string ContactID, string KAMID, string WinProbability, string CurrencyID, string StageID, int StatusID
* , int IsActive, string IsBudgetaryQuote, string BudgetaryQuoteDate, string BudgetaryQuoteAmount
* , string QuoteProposalDate, string NegotiatedMMR, string NegotiatedAmount, string NegotiatedRevenue)*/
// public object CreateOpportunity(string OppName, string PartnerID, string CustCode, string ContactID, string KAMID, string WinProbability, string CurrencyID, string StageID, int StatusID
// , int IsActive)
//{
// //dynamic[,] para = {
// // { "@OppName", OppName },
// // { "@PartnerID", PartnerID },
// // { "@CustCode", CustCode },
// // { "@ContactID", ContactID },
// // { "@KAMID", KAMID },
// // { "@WinProbability", WinProbability },
// // { "@CurrencyID", CurrencyID },
// // { "@StageID" , StageID},
// // { "@StatusID", StatusID},
// // { "@IsActive", IsActive},
// // { "@IsBudgetaryQuote", IsBudgetaryQuote},
// // { "@BudgetaryQuoteDate", BudgetaryQuoteDate},
// // { "@BudgetaryQuoteAmount", BudgetaryQuoteAmount},
// // { "@QuoteProposalDate", QuoteProposalDate},
// // { "@NegotiatedMMR", NegotiatedMMR},
// // { "@NegotiatedAmount", NegotiatedAmount},
// // { "@NegotiatedRevenue", NegotiatedRevenue},
// // { "@NegotiatedMMR", NegotiatedMMR},
// // { "@NegotiatedMMR", NegotiatedMMR},
// // };
// dynamic[,] para = {
// { "@OppName", OppName },
// { "@PartnerID", PartnerID },
// { "@CustCode", CustCode },
// { "@ContactID", ContactID },
// { "@KAMID", KAMID },
// { "@WinProbability", WinProbability },
// { "@CurrencyID", CurrencyID },
// { "@StageID" , StageID},
// { "@StatusID", StatusID},
// { "@IsActive", IsActive},
// };
// clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
// object objectCustomerID = objDBAcess.executeProc("sp_InsertOpportunity", para);
// return objectCustomerID;
//}
public object CreateOpportunity(string OppName, string LOB_ID, int StageID, int PartnerID, int CustCode, int ContactID, string WinProbability, int KAMID, int WorkingBy, string Attachment1, int LastUpdateBy)
{
dynamic[,] para =
{
{ "@OppName", OppName },
{ "@LOB_ID", LOB_ID },
{ "@PartnerID", PartnerID },
{ "@CustCode", CustCode },
{ "@PartnerContactID", ContactID },
{ "@KAMID", KAMID },
{ "@WorkingBy", WorkingBy },
{ "@WinProbability", WinProbability },
{ "@CurrencyID", 1 },
{ "@OppStageID", StageID },
{ "@OppStatusID", 1 },
{ "@IsActive", 1 },
{ "@Attachment1", Attachment1 },
{ "@Attachment2", Attachment1 },
{ "@LastUpdateBy", LastUpdateBy }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectOpportunityID = objDBAcess.InsertProc_WithOutput("sp_Sales_InsertOpportunity", para, "@OppId");
return(objectOpportunityID);
}
public object CreateOpportunityDetailsForEBU(int OppID, int infraID, int ServiceUnitID, int RegionID, int City, int LocationCode, int BuildingID, string Site_A_Address, string Site_B_Address, string Latitude, string Longitude, int POC, int CircuitTypeID, string Remarks, int Estimated_Price, int Amount, int NRCActual, int MRCActual, int NRR, int MRR, int ROI, int TermProfit, int TermRevenue, int RecurringMarginage, int NonRecurringMargin, string NRFRequestDate, int LastUpdatedBy)
{
dynamic[,] para = { { "@OppID", OppID },
{ "@InfraID", infraID },
{ "@ServiceUnitID", ServiceUnitID },
{ "@RegionID", RegionID },
{ "@City", City },
{ "@LocationCode", LocationCode },
{ "@BuildingID", BuildingID },
{ "@Site_A_Address", Site_A_Address },
{ "@Site_B_Address", Site_B_Address },
{ "@Lat", Latitude },
{ "@Long", Longitude },
{ "@POC", POC },
{ "@CircuitTypeID", CircuitTypeID },
{ "@Remarks", Remarks },
{ "@Estimated_Price", Estimated_Price },
{ "@Amount", Amount },
{ "@NRCActual", NRCActual },
{ "@MRCActual", MRCActual },
{ "@NRR", NRR },
{ "@MRR", MRR },
{ "@LastUpdatedBy", LastUpdatedBy } };
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectOpportunityID = objDBAcess.InsertProc_WithOutput("sp_Ins_OpportunityDetails_EBU", para, "@OppRenID");
return(objectOpportunityID);
//clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
//object objectCustomerID = objDBAcess.executeProc("sp_Ins_OpportunityDetails_EBU", para);
//return objectCustomerID;
}
public object CreateOpportunityDetails(string Site_A_Address, int Site_A_Country, int Site_A_City, string Site_B_Address, int Site_B_Country, int Site_B_City, int Name, int QuantityUOM, int Interface, string Last_Mile_Protection, string Wet_Portion_Restorability, string SLA, DateTime RFS_Date_Duration, string Contract_Term, string Win_Loss, int Currency, int OppID)
{
dynamic[,] para =
{
{ "@Site_A_Address", Site_A_Address },
{ "@Site_A_Country", Site_A_Country },
{ "@Site_A_City", Site_A_City },
{ "@Site_B_Address", Site_B_Address },
{ "@Site_B_Country", Site_B_Country },
{ "@Site_B_City", Site_B_City },
{ "@Name", Name },
{ "@QuantityUOM", QuantityUOM },
{ "@Interface", Interface },
{ "@Last_Mile_Protection", Last_Mile_Protection },
{ "@Wet_Portion_Restorability", Wet_Portion_Restorability },
{ "@SLA", SLA },
{ "@RFS_Date_Duration", RFS_Date_Duration },
{ "@Contract_Term", Contract_Term },
{ "@Win_Loss", Win_Loss },
{ "@Currency", Currency },
{ "@OppID", OppID }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectCustomerID = objDBAcess.InsertProc_WithOutput("sp_Ins_OpportunityDetails_New", para, "@OppRevId");
return(objectCustomerID);
}
//public object CreateTAF(string RevisionNo, DateTime SubmissionDate, string Sites_JobLocation, string AccountManager, string BusinessUnit, string Capacity , string LastMileTopology, string RestorabilityMethod, string AdditionalEquipment, string ServiceParameter, string SLARequirement, int NRFID, int WorkingBy)
//public object CreateTAF(string TAFFormNo, string RevisionNo, string Sites_JobLocation, string AccountManager, string BusinessUnit, int LastMileTopology, int Capacity, int InterfaceHandoff, int LogicalTopology,string RestorabilityMethod, int AdditionalEquipment,int SLARequirement, string AdditionRequirement, string ServiceParameter, string Comments, string AdditionalEquipmentDesc, int NRFID, int WorkingBy)
public object CreateTAF(string TAFFormNo, string RevisionNo, string Sites_JobLocation, string AccountManager, string BusinessUnit, int LastMileTopology, int Capacity, int InterfaceHandoff, int LogicalTopology, string RestorabilityMethod, int AdditionalEquipment, int SLARequirement, string AdditionRequirement, int NRFID, int WorkingBy)
{
dynamic[,] para =
{
{ "@TAFFormNo", TAFFormNo },
{ "@RevisionNo", RevisionNo },
{ "@Sites_JobLocation", Sites_JobLocation },
{ "@AccountManager", AccountManager },
{ "@BusinessUnit", BusinessUnit },
{ "@LastMileTopology", LastMileTopology },
{ "@Capacity", Capacity },
{ "@InterfaceHandoff", InterfaceHandoff },
{ "@LogicalTopology", LogicalTopology },
{ "@RestorabilityMethod", RestorabilityMethod },
{ "@AdditionalEquipment", AdditionalEquipment },
{ "@SLARequirement", SLARequirement },
{ "@AdditionRequirement", AdditionRequirement },
//{ "@ServiceParameter", ServiceParameter},
//{ "@Comments", Comments},
//{ "@AdditionalEquipmentDesc", AdditionalEquipmentDesc},
{ "@NRFID", NRFID },
{ "@WorkingBy", WorkingBy }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectOpportunityID = objDBAcess.InsertProc_WithOutput("sp_InsertTAF", para, "@TAFID");
return(objectOpportunityID);
}
public object CreateOpportunityDetailsEBU_ForProducts(int ProductsID, int BandWidthID, String BandwidthType, int ServiceUnitID, int InterfaceID, int MRCActual, int MRCP3, int OppRevID, int Transby)
{
dynamic[,] para =
{
{ "@ProductID", ProductsID },
{ "@BandwidthID", BandWidthID },
{ "@BandwidthType", BandwidthType },
{ "@ServiceUnitID", ServiceUnitID },
{ "@InterfaceID", InterfaceID },
{ "@OppRevID", OppRevID },
{ "@MRCActual", MRCActual },
{ "@MRCP3", MRCP3 },
{ "@TransactionBy", Transby }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objProductID = objDBAcess.InsertProc_WithOutput("sp_InsertRevDetails_ForProducts", para, "@ProductRenID");
return(objProductID);
}
public object CreateAccount(string Customer, string Logo, string Country, string State, string City, string EmailAddress, string Phone, string Remarks, int IsActive, int TransactionBy, string CustomerType, string Domain)
{
string[,] para =
{
{ "@Customer", Customer },
{ "@Logo", Logo },
{ "@Country", Country },
{ "@State", State },
{ "@City", City },
{ "@EmailAddress", EmailAddress },
{ "@Phone", Phone },
{ "@Remarks", Remarks },
{ "@IsActive", IsActive.ToString() },
{ "@TransactionBy", TransactionBy.ToString() },
{ "@CustomerType", CustomerType },
{ "@Domain", Domain }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectCustomerID = objDBAcess.InsertProc_WithOutput("sp_CPM_InsertCustomer", para, "@CustomerCode");
return(objectCustomerID);
}
