//---------------------------------------
public DataTable GetCompView()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GNF = objDBAcess.SP_Datatable("GetComplaintSD");
return(dt_GNF);
}
public void UpdateContact(int ContactID, int CustomerCode, string FirstName, string LastName, string Prefix, string Department, string CNIC, string JobTitle, string MobilePhone, string WorkPhone, string Email, string Address, string City, string State, string Country, string PinCode, string Gender, string Religion, string ContactType, int IsFav, int IsActive)
{
dynamic[,] para =
{
{ "@ContactID", ContactID },
{ "@CustomerCode", CustomerCode },
{ "@FirstName", FirstName },
{ "@LastName", LastName },
{ "@Prefix", Prefix },
{ "@Department", Department },
{ "@CNIC", CNIC },
{ "@JobTitle", JobTitle },
{ "@MobilePhone", MobilePhone },
{ "@WorkPhone", WorkPhone },
{ "@Email", Email },
{ "@Address", Address },
{ "@City", City },
{ "@State", State },
{ "@Country", Country },
{ "@PinCode", PinCode },
{ "@Gender", Gender },
{ "@Religion", Religion },
{ "@ContactType", ContactType },
{ "@IsFav", IsFav },
{ "@IsActive", IsActive }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectContactID = objDBAcess.executeProc("sp_UpdateCustomerContacts", para);
}
public DataTable GetAllOpportunity()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GAO = objDBAcess.SP_Datatable("sp_Get_Opportunity");
return(dt_GAO);
}
/*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 DataTable GetAccount()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GA = objDBAcess.SP_Datatable("GetCustomerIdentification");
return(dt_GA);
}
public DataTable GetOpportunityProposal()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GD = objDBAcess.SP_Datatable("Get_Proposal");
return(dt_GD);
}
public object UpdateOpportunityEBU(int OppId, string OppName, int CustCode, int PartnerContactID, int KAMID, int WorkingBy, int CurrencyID, int OppStageID, int OppStatusID, string WinProbibality, string GroupRTR, String DTProposalIntDate, string OppRemarks, string NegotiationStatus, string ProposalLastRevesionDate, string NegotiationFollowUpDate, string NegotiationRemarks, string NegotiationResumeDate, string NegotiationHoldReason, String OrderDate, string WonLostReason, String DeploymentDate)
{
//String NRFRequestDate
dynamic[,] para =
{
{ "@OppId", OppId },
{ "@OppName", OppName },
{ "@CustCode", CustCode },
{ "@PartnerContactID", PartnerContactID },
{ "@KAMID", KAMID },
{ "@WorkingBy", WorkingBy },
{ "@CurrencyID", CurrencyID },
{ "@OppStageID", OppStageID },
{ "@OppStatusID", OppStatusID },
{ "@WinProbability", WinProbibality },
{ "@GroupRTR", GroupRTR },
{ "@ProposalIntDate", DTProposalIntDate },
{ "@Remarks", OppRemarks },
{ "@NegotiationStatus", NegotiationStatus },
{ "@NegotiationProposalRevisionDate", ProposalLastRevesionDate },
{ "@NegotiationFollowUpDate", NegotiationFollowUpDate },
{ "@NegotiationRemarks", NegotiationRemarks },
{ "@NegotiationResumeDate", NegotiationResumeDate },
{ "@NegotiationHoldReason", NegotiationHoldReason },
{ "@OrderDate", OrderDate },
{ "@OppCloseReason", WonLostReason },
{ "@DeploymentDate", DeploymentDate }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectOpportunityID = objDBAcess.executeProc("sp_UpdateOpportunityMaster_EBU", para);
return(objectOpportunityID);
}
public DataTable GetAllCurrencies()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt = objDBAcess.SP_Datatable("sp_Get_Currency");
return(dt);
}
public DataTable GetAllOppStatus()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt = objDBAcess.SP_Datatable("sp_OppStatus");
return(dt);
}
public DataTable GetAllInfra()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt = objDBAcess.SP_Datatable("Get_LOB");
return(dt);
}
public DataTable GetAllAccounts()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt = objDBAcess.SP_Datatable("sp_CPM_GetMasterCustomer");
return(dt);
}
public DataTable GetALLBusinessType()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt = objDBAcess.SP_Datatable("GetBusinessType");
return(dt);
}
public DataTable GetTerritoryHead()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GNF = objDBAcess.SP_Datatable("RM_GetTerritoryHead");
return(dt_GNF);
}
public DataTable GetPriority()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GNF = objDBAcess.SP_Datatable("OM_GetPriority");
return(dt_GNF);
}
public DataTable GetOpportunitySurveyEBU()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GD = objDBAcess.SP_Datatable("Get_Survey_EBU");
return(dt_GD);
}
public DataTable GetDomain()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GD = objDBAcess.SP_Datatable("sp_SelDomain");
return(dt_GD);
}
public DataTable GetOpportunityBusinessCaseEBU()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GD = objDBAcess.SP_Datatable("Get_BusinessCase_EBU");
return(dt_GD);
}
public DataTable GetALLServices()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GAS = objDBAcess.SP_Datatable("GetServiceUnits");
return(dt_GAS);
}
public DataTable GetALLBandWidth()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt = objDBAcess.SP_Datatable("GetBandwidthEnterprise");
return(dt);
}
public DataTable GetCurrency()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GOS = objDBAcess.SP_Datatable("sp_GetCurrency");
return(dt_GOS);
}
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 DataTable GetContactType()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_CCT = objDBAcess.SP_Datatable("sp_Sales_GetContactType");
return(dt_CCT);
}
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 DataTable GetContactReligion()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_CR = objDBAcess.SP_Datatable("sp_Sales_GetContactReligion");
return(dt_CR);
}
public object CreateContact(int CustCode,
int CityID,
string CC_Title,
string CC_Name,
string CC_Contact,
string CC_Email,
string CC_Mobile,
string CC_Address,
int ContactTypeID,
string Religion,
string Gender,
int TransactionBy
)
{
dynamic[,] para =
{
{ "@CustCode", CustCode },
{ "@CityID", CityID },
{ "@CC_Title", CC_Title },
{ "@CC_Name", CC_Name },
{ "@CC_Contact", CC_Contact },
{ "@CC_Email", CC_Email },
{ "@CC_Mobile", CC_Mobile },
{ "@CC_Address", CC_Address },
{ "@ContactTypeID", ContactTypeID },
{ "@Religion", Religion },
{ "@Gender", Gender },
{ "@TransactionBy", TransactionBy }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectCustomerID = objDBAcess.executeProc("sp_Sales_InsertCustomerContact", para);
return(objectCustomerID);
}
public DataTable GetOpportunityBudgetary()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GD = objDBAcess.SP_Datatable("Get_BudgetaryOpportunity");
return(dt_GD);
}
//public object CreateOpportunityDetails(string SID_A_Address, string SID_A_Area, string SID_A_Building, string SID_A_City)
//{
// dynamic[,] para = {
// { "@SID_A_Address", SID_A_Address },
// { "@SID_A_Area", SID_A_Area },
// { "@SID_A_Building", SID_A_Building },
// { "@SID_A_City", SID_A_City }
// };
// clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
// object objectCustomerID = objDBAcess.executeProc("sp_InsertOpportunityDetails", 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.executeProc("sp_Ins_OpportunityDetails_New", para);
return(objectCustomerID);
}
public DataTable GetOpportunityRequirementEBU()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GD = objDBAcess.SP_Datatable("Get_Requirement_EBU");
return(dt_GD);
}
public object UpdateOpportunity(int OppId, string OppName, int StageID, int PartnerID, int CustCode, int CurrencyID, int StatusID, string WinProbability, int KAMID, int WorkingBy, string Attachment1, int LastUpdateBy, int IsBudgetaryQuote, DateTime BudgetaryQuoteDate, DateTime QuoteProposalDate)
{
dynamic[,] para =
{
{ "@OppId", OppId },
{ "@OppName", OppName },
{ "@StageID", StageID },
{ "@PartnerID", PartnerID },
{ "@CustCode", CustCode },
{ "@CurrencyID", CurrencyID },
{ "@StatusID", StatusID },
{ "@WinProbability", WinProbability },
{ "@KAMID", KAMID },
{ "@WorkingBy", WorkingBy },
{ "@Attachment1", Attachment1 },
{ "@LastUpdateBy", LastUpdateBy },
{ "@IsBudgetaryQuote", IsBudgetaryQuote },
{ "@BudgetaryQuoteDate", BudgetaryQuoteDate },
{ "@QuoteProposalDate", QuoteProposalDate }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectOpportunityID = objDBAcess.executeProc("sp_UpdateOpportunityMaster_New", para);
return(objectOpportunityID);
}
public DataTable GetCloserRemarks()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GNF = objDBAcess.SP_Datatable("RM_GetCloserRemarks");
return(dt_GNF);
}