public void SaveProjectPricingDetais(ProjectDetail details)
{
using (AzurePricingEntities entities = new AzurePricingEntities())
{
entities.ProjectDetails.Add(details);
entities.SaveChanges();
}
}
internal List <ProjectDetail> GetEstimationDetailsByEmail(string email)
{
using (AzurePricingEntities entities = new AzurePricingEntities())
{
List <ProjectDetail> details = entities.ProjectDetails.Include("ProjectResources").Where(p => p.QDB_EmailID == email).ToList();
return(details);
}
}
internal List <ProjectDetail> GetEstimationDetailsByID(int id)
{
List <ProjectDetail> details;
using (AzurePricingEntities entities = new AzurePricingEntities())
{
details = entities.ProjectDetails.Include("ProjectResources").Where(p => p.ID == id).ToList();
}
return(details);
}
public string GetPriceDetails(string Category, string SubCategory, string Region)
{
string price = "";
using (AzurePricingEntities entities = new AzurePricingEntities())
{
List <RateCardData> data = entities.RateCardDatas.Where(r => r.MeterSubCategory == SubCategory && r.MeterCategory == Category && r.MeterRegion == Region).ToList();
if (data != null && data.Count > 0)
{
price = data[0].MeterRates.Replace('[', ' ').Replace(']', ' ').Trim().Split(':')[1];
}
else
{
price = "0.0";
}
}
return(price);
}
