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 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 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 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 object UpdateUsers(string Name, string UserName, string Department, string Designation, string ResourceRole, string Email, string password, string LOB, string SubDeptName, string ReportingManager, string Phone, string userStatus, string RegionID, string DomainID, string userid)
{
string[,] para =
{
{ "@UserID", userid },
{ "@Name", Name.ToString() },
{ "@DepartmentID", Department },
{ "@Username", UserName },
{ "@Password", password },
{ "@RoleID", ResourceRole },
{ "@ManagerID", ReportingManager },
{ "@DesignationID", Designation },
{ "@Email", Email },
{ "@Phone", Phone },
{ "@SubDepID", SubDeptName },
{ "@LOBID", LOB },
{ "@DomainID", DomainID },
{ "@RegionID", RegionID },
{ "@CreatedBy", userid },
{ "@TransactionDateTime", DateTime.Now.ToShortDateString() },
{ "@IsADAuthenticate", "1" },
{ "@IsActive", "1" }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
bool IsInserted = objDBAcess.executeProc("MR_UpdateUsers", para);
return(IsInserted);
}
public object UpdateActivity(string ActivityID, string Subject, string CustCode, string Account, string Address, string POC, string SubRefID, String Opportunity, string ActivityDate, string ActivityTime, string ActivityTypeID, string ActivityStatus, string ActivityOwner, string Remarks, String CloserRemarks)
{
string[,] para =
{
{ "@ActivityID", ActivityID },
{ "@Subject", Subject.ToString() },
{ "@RefID", CustCode },
{ "@RefName", Account },
{ "@Address", Address },
{ "@POC", POC },
{ "@SubRefID", SubRefID },
{ "@SubRefName", Opportunity },
{ "@ActivityDate", ActivityDate },
{ "@ActivityTime", ActivityTime },
{ "@ActivityTypeID", ActivityTypeID },
{ "@ActivityStatus", ActivityStatus },
{ "@ActivityOwner", ActivityOwner },
{ "@Remarks", Remarks },
{ "@ClosureRemarks", CloserRemarks }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
bool IsInserted = objDBAcess.executeProc("MR_UpdateActivity", para);
return(IsInserted);
}
//-------------------------------------
//Activity
public object InsertActivity(string Subject, string CustCode, string Account, string Address, string POC, string SubRefID, String Opportunity, string ActivityDate, string ActivityTime, string ActivityTypeID, string ActivityStatus, string ActivityOwner, string Remarks, String CloserRemarks, string Attachment, string IsActive, string TransactionBy, String TransactionDateTime)
{
string[,] para =
{
{ "@Subject", Subject.ToString() },
{ "@RefID", CustCode },
{ "@RefName", Account },
{ "@Address", Address },
{ "@POC", POC },
{ "@SubRefID", SubRefID },
{ "@SubRefName", Opportunity },
{ "@ActivityDate", ActivityDate },
{ "@ActivityTime", ActivityTime },
{ "@ActivityTypeID", ActivityTypeID },
{ "@ActivityStatus", ActivityStatus },
{ "@ActivityOwner", ActivityOwner },
{ "@Remarks", Remarks },
{ "@ClosureRemarks", CloserRemarks },
{ "@Attachment", Attachment },
{ "@IsActive", IsActive },
{ "@TransactionBy", TransactionBy },
{ "@TransactionDateTime", TransactionDateTime }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
bool IsInserted = objDBAcess.executeProc("RM_InsertActivity", para);
return(IsInserted);
}
public object InsertTerritoryQuotas(string PlanName, string TerritoryID, string RegionID, string Domain, string QuotaAmount, string StartDate, string EndDate, string RegionalHead, string RegionalHeadQuota, string ServcieUnitID, string IsActive, string TransactionBy, string TransactionDateTime)
{
string[,] para =
{
{ "@PlanName", PlanName.ToString() },
{ "@TerritoryID", TerritoryID },
{ "@RegionID", RegionID },
{ "@Domain", Domain },
{ "@QuotaAmount", QuotaAmount },
{ "@StartDate", StartDate },
{ "@EndDate", EndDate },
{ "@RegionalHead", RegionalHead },
{ "@RegionalHeadQuota", RegionalHeadQuota },
{ "@ServcieUnitID", ServcieUnitID },
{ "@IsActive", IsActive },
{ "@TransactionBy", TransactionBy },
{ "@TransactionDateTime", TransactionDateTime }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
bool IsInserted = objDBAcess.executeProc("RM_InsertQuotasTerritory", para);
return(IsInserted);
}
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 object UpdateNRFKey(string str_NRFID)
{
string[,] para =
{
{ "@NRFID", str_NRFID }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectnrfid = objDBAcess.executeProc("sp_UpdateNRFNEW", para);
return(objectnrfid);
}
public object CreatePartner(int CustomerCode, int PartnerCode)
{
dynamic[,] para =
{
{ "@CustomerCode", CustomerCode },
{ "@PartnerCode", PartnerCode }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectPartnerID = objDBAcess.executeProc("sp_CPM_InsertCustPartner", para);
return(objectPartnerID);
}
public object InsertItems(int int_NRFID, string str_ItemNumber, int int_Quantity, Decimal dec_Cost)
{
string[,] para =
{
{ "@NRFID", int_NRFID.ToString() },
{ "@ITEMNMBR", str_ItemNumber },
{ "@Quantity", int_Quantity.ToString() },
{ "@Cost", dec_Cost.ToString() },
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
bool IsInserted = objDBAcess.executeProc("sp_InsertNRFLine", para);
return(IsInserted);
}
public object CreateOpportunityDetailsForProducts(int Productsid, int UOMID, int InterfaceID, int OppRevID, int TransactionBy)
{
dynamic[,] para =
{
{ "@ProductID", Productsid },
{ "@UOMID", UOMID },
{ "@InterfaceID", InterfaceID },
{ "@RevDelID", OppRevID },
{ "@TransactionBy", TransactionBy }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectCustomerID = objDBAcess.executeProc("sp_InsertRevDetails_ForProducts", para);
return(objectCustomerID);
}
public string RejectTAF(int NRFID, int TAFID, string ServiceParameter, string Comments, string AdditionalEquipmentDesc)
{
dynamic[,] para =
{
{ "@NRFID", NRFID },
{ "@TAFID", TAFID },
{ "@ServiceParameter", ServiceParameter },
{ "@Comments", Comments },
{ "@AdditionalEquipmentDesc", AdditionalEquipmentDesc }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectCustomerID = objDBAcess.executeProc("sp_RejectTAF", para);
return("R");
}
public object UpdateOpportunityDetailsEBU(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 Cost_of_Additional_Equipment, int Difference, int PaybackPeriod, int PaybackPeriod35difff, int MRCOTS, int CosttoMPPL, string InfraType, string NRFCost, string TotalTAFcost, string PMRC3, string OTCP3, string NameOf3P, string NodeName, string WonLostStatus, string WinLossReason, string NRFRequestDate, int LastUpdatedBy)
{
dynamic[,] para =
{
{ "@OppID", OppID },
{ "@OppType", 1 },
{ "@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 },
{ "@CostOfAdditionalEqp", Cost_of_Additional_Equipment }, //c
{ "@Difference", Difference }, //c
{ "@PaybackPeriod", PaybackPeriod }, //c
{ "@PaybackPeriod35difff", PaybackPeriod35difff }, //c
{ "@MRCOTS", MRCOTS }, //c
{ "@CosttoMPPL", CosttoMPPL }, //c
{ "@InfraType", InfraType },
{ "@NRFCost", NRFCost },
{ "@TotalTAFcost", TotalTAFcost },
{ "@MRCP3", PMRC3 },
{ "@OTCP3", OTCP3 },
{ "@NameOf3P", NameOf3P },
{ "@NodeName", NodeName },
{ "@WonLostStatus", WonLostStatus },
{ "@WinLossReason", WinLossReason },
{ "@NRFRequestDate", NRFRequestDate },
{ "@LastUpdatedBy", LastUpdatedBy }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectCustomerID = objDBAcess.executeProc("sp_Update_OpportunityDetails_EBU", para);
return(objectCustomerID);
}
public object CreateTransactionLog(int RefrenceID, string Refrence, int StatusID, string Remarks, int TransactionBy, DateTime TransactionDateTime)
{
dynamic[,] para =
{
{ "@RefrenceID", RefrenceID },
{ "@Refrence", Refrence },
{ "@StatusID", StatusID },
{ "@Remarks", Remarks },
{ "@TransactionBy", TransactionBy },
{ "@TransactionDateTime", TransactionDateTime }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectCustomerID = objDBAcess.executeProc("sp_InsertTransaction", para);
return(objectCustomerID);
}
public object InsertRevenueLines(int OppID, 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, decimal NRC_Budget, decimal MRC_Budget, decimal NRC_Cost_On_Net, decimal MRC_Cost_On_Net, decimal NRC_Cost_Off_Net, decimal MRC_Cost_Off_Net, decimal NRC_Cost_OOP, decimal MRC_Cost_OOP, string Name_of_3P, decimal NRC_Actual, decimal MRC_Actual, decimal NRR, decimal MRR, decimal ROI, decimal Term_Profit, decimal Term_Revenue, decimal Recurring_Margin_Percentage, decimal Non_Recurring_Margin_Percentage)
{
dynamic[,] para =
{
{ "@OppID", OppID },
{ "@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 },
{ "@NRC_Budget", NRC_Budget },
{ "@MRC_Budget", MRC_Budget },
{ "@NRC_Cost_On_Net", NRC_Cost_On_Net },
{ "@MRC_Cost_On_Net", MRC_Cost_On_Net },
{ "@NRC_Cost_Off_Net", NRC_Cost_Off_Net },
{ "@MRC_Cost_Off_Net", MRC_Cost_Off_Net },
{ "@NRC_Cost_OOP", NRC_Cost_OOP },
{ "@MRC_Cost_OOP", MRC_Cost_OOP },
{ "@Name_of_3P", Name_of_3P },
{ "@NRC_Actual", NRC_Actual },
{ "@MRC_Actual", MRC_Actual },
{ "@NRR", NRR },
{ "@MRR", MRR },
{ "@ROI", ROI },
{ "@Term_Profit", Term_Profit },
{ "@Term_Revenue", Term_Revenue },
{ "@Recurring_Margin_Percentage", Recurring_Margin_Percentage },
{ "@Non_Recurring_Margin_Percentage", Non_Recurring_Margin_Percentage }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectCustomerID = objDBAcess.executeProc("sp_Insert_Revenue_Lines", para);
return(objectCustomerID);
}
public object UpdateQuotas(string QuotasID, string PlanName, string RegionID, string DomainID, string QuotaAmount, String RegionalHead, string RegionalHeadQuota, string IsActive)
{
string[,] para =
{
{ "@QuotaID", QuotasID },
{ "@PlanName", PlanName },
{ "@RegionID", RegionID },
{ "@Domain", DomainID },
{ "@QuotaAmount", QuotaAmount },
{ "@RegionalHead", RegionalHead },
{ "@RegionalHeadQuota", RegionalHeadQuota },
{ "@IsActive", IsActive },
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
bool IsInserted = objDBAcess.executeProc("MR_UpdateQuotas", para);
return(IsInserted);
}
public object UpdateOpportunity(int OppId, string OppName, int CustCode, int PartnerContactID, int KAMID, int WorkingBy, int CurrencyID, int OppStageID, int OppStatusID)
{
dynamic[,] para =
{
{ "@OppId", OppId },
{ "@OppName", OppName },
{ "@CustCode", CustCode },
{ "@PartnerContactID", PartnerContactID },
{ "@KAMID", KAMID },
{ "@WorkingBy", WorkingBy },
{ "@CurrencyID", CurrencyID },
{ "@OppStageID", OppStageID },
{ "@OppStatusID", OppStatusID }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectOpportunityID = objDBAcess.executeProc("sp_UpdateOpportunityMaster_New", para);
return(objectOpportunityID);
}
public object InsertTargets(string QuotaID, string MonthName, string Quater, string StartDate, string EndDate, string FiscalYear, string TargetAmount, string QuotaPercentage, string IsActive, string TransactionBy, string TransactionDateTime)
{
string[,] para =
{
{ "@QuotaID", QuotaID },
{ "@MonthName", MonthName },
{ "@Quater", Quater },
{ "@StartDate", StartDate },
{ "@EndDate", EndDate },
{ "@FiscalYear", FiscalYear },
{ "@TargetAmount", TargetAmount },
{ "@QuotaPercentage", QuotaPercentage },
{ "@IsActive", IsActive },
{ "@TransactionBy", TransactionBy },
{ "@TransactionDateTime", TransactionDateTime }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
bool IsInserted = objDBAcess.executeProc("RM_InsertTargets", para);
return(IsInserted);
}
public object UpdateAccount(int CustomerCode, string Customer, string Logo, string Country, string State, string City, string EmailAddress, string Phone, string Remarks, int IsActive, int TransactionBy, string CustomerType, string Domain)
{
dynamic[,] para =
{
{ "@CustomerCode", CustomerCode },
{ "@Customer", Customer },
{ "@Logo", Logo },
{ "@Country", Country },
{ "@State", State },
{ "@City", City },
{ "@EmailAddress", EmailAddress },
{ "@Phone", Phone },
{ "@Remarks", Remarks },
{ "@IsActive", IsActive.ToString() },
{ "@TransactionBy", TransactionBy },
{ "@CustomerType", CustomerType },
{ "@Domain", Domain }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectCustomerID = objDBAcess.executeProc("sp_CPM_UpdateCustomer", para);
return(objectCustomerID);
}
