public async Task <DTOproductprovider> Postproductprovider(DTOproductprovider newDTO)
{
productprovider newProd = EntityMapper.updateEntity(null, newDTO);
db.productproviders.Add(newProd);
await db.SaveChangesAsync();
return(newDTO);
}
public async Task <IHttpActionResult> Putproductprovider(int ID, DTOproductprovider editedDTO)
{
productprovider toUpdate = db.productproviders.Find(ID);
toUpdate = EntityMapper.updateEntity(toUpdate, editedDTO);
db.Entry(toUpdate).State = EntityState.Modified;
await db.SaveChangesAsync();
return(StatusCode(HttpStatusCode.NoContent));
}
public DTOProductProviderAgregatePaymentInformation(int userID)
{
//user tmpUser = (from l in db.users where l.User_ID == userID select l).SingleOrDefault();
user tmpUser = db.users.Find(userID);
productprovider tmpProductProvider = (from l in db.productproviders where l.User_ID == userID select l).SingleOrDefault();
productproviderpayment Latestpayment = (from a in db.productproviderpayments where a.ProductProvider_ID == tmpProductProvider.ProductProvider_ID orderby a.DatePayed descending select a).First();
ProductProviderController ctrl = new ProductProviderController();
companyName = tmpProductProvider.ppCompanyName;
cellPhoneNumber = tmpUser.userContactNumber;
email = tmpUser.userEmail;
//totalCashedOwed = (int) ctrl.getTotalOwedToPP(tmpProductProvider.ProductProvider_ID);
lastPaymentMade = Latestpayment.DatePayed;
}
// GET: api/insuranceManager
public InsuranceProviderSession Session(int ProductProviderID)
{
if (ProductProviderID == -1)
{
ProductProviderID = 11;
}
InsuranceProviderSession toReturn = new InsuranceProviderSession();
productprovider pd = db.productproviders.Find(ProductProviderID);
toReturn.userID = pd.User_ID;
toReturn.userType = int.Parse(pd.user.userType.ToString());
toReturn.providerID = pd.ProductProvider_ID;
toReturn.userName = pd.user.userFirstName.ToString();
return(toReturn);
}
public static productprovider updateEntity(productprovider entityObjct, DTOproductprovider dto)
{
if (entityObjct == null)
{
entityObjct = new productprovider();
}
entityObjct.ProductProvider_ID = dto.ProductProvider_ID;
entityObjct.User_ID = dto.User_ID;
entityObjct.ppCompanyName = dto.ppCompanyName;
entityObjct.ppVATnumber = dto.ppVATnumber;
entityObjct.ppFaxNumber = dto.ppFaxNumber;
entityObjct.ppAddress = dto.ppAddress;
entityObjct.lastAssignedPolicyNumber = dto.lastAssignedPolicyNumber;
return(entityObjct);
}
public static async Task <string> getProductProviderName(string insuranceProductName)
{
insuranceProductName = removeSpaces(insuranceProductName);
List <product> productList = (from l in db.products select l).ToList();
foreach (product prod in productList)
{
string tmpName = removeSpaces(prod.productName);
if (insuranceProductName.Equals(tmpName))
{
productprovider prodProvider = await db.productproviders.SingleAsync(l => l.ProductProvider_ID == prod.ProductProvider_ID);
return(removeSpaces(prodProvider.ppCompanyName));
}
}
return("");
}