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(""); }