public string Update(/*string reqType*/) { DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>(); InventoryDbContext inventoryDBContext = new InventoryDbContext(connString); try { //string str = Request.Form.Keys.First<string>(); string str = this.ReadPostData(); string reqType = this.ReadQueryStringData("reqType"); if (!String.IsNullOrEmpty(str)) { if (reqType == "UpdateVendors") { VendorMasterModel vendor = DanpheJSONConvert.DeserializeObject <VendorMasterModel>(str); inventoryDBContext.Vendors.Attach(vendor); inventoryDBContext.Entry(vendor).State = EntityState.Modified; inventoryDBContext.Entry(vendor).Property(x => x.CreatedOn).IsModified = false; inventoryDBContext.Entry(vendor).Property(x => x.CreatedBy).IsModified = false; inventoryDBContext.SaveChanges(); responseData.Results = vendor; responseData.Status = "OK"; } else if (reqType == "UpdateInventoryTerms") { InventoryTermsModel termsconditions = DanpheJSONConvert.DeserializeObject <InventoryTermsModel>(str); inventoryDBContext.InventoryTerms.Attach(termsconditions); inventoryDBContext.Entry(termsconditions).State = EntityState.Modified; inventoryDBContext.Entry(termsconditions).Property(x => x.CreatedOn).IsModified = false; inventoryDBContext.Entry(termsconditions).Property(x => x.CreatedBy).IsModified = false; inventoryDBContext.SaveChanges(); responseData.Results = termsconditions; responseData.Status = "OK"; } if (reqType == "UpdateItemCategory") { ItemCategoryMasterModel itemcategoryModel = DanpheJSONConvert.DeserializeObject <ItemCategoryMasterModel>(str); inventoryDBContext.ItemCategoryMaster.Attach(itemcategoryModel); inventoryDBContext.Entry(itemcategoryModel).State = EntityState.Modified; inventoryDBContext.Entry(itemcategoryModel).Property(x => x.CreatedOn).IsModified = false; inventoryDBContext.Entry(itemcategoryModel).Property(x => x.CreatedBy).IsModified = false; inventoryDBContext.SaveChanges(); responseData.Results = itemcategoryModel; responseData.Status = "OK"; } if (reqType == "UpdateItemSubCategory") { ItemSubCategoryMasterModel itemsubcategoryModel = DanpheJSONConvert.DeserializeObject <ItemSubCategoryMasterModel>(str); inventoryDBContext.ItemSubCategoryMaster.Attach(itemsubcategoryModel); inventoryDBContext.Entry(itemsubcategoryModel).State = EntityState.Modified; inventoryDBContext.Entry(itemsubcategoryModel).Property(x => x.CreatedOn).IsModified = false; inventoryDBContext.Entry(itemsubcategoryModel).Property(x => x.CreatedBy).IsModified = false; inventoryDBContext.SaveChanges(); responseData.Results = itemsubcategoryModel; responseData.Status = "OK"; } if (reqType == "UpdateUnitOfMeasurement") { UnitOfMeasurementMasterModel unitofmeasurementModel = DanpheJSONConvert.DeserializeObject <UnitOfMeasurementMasterModel>(str); inventoryDBContext.UnitOfMeasurementMaster.Attach(unitofmeasurementModel); inventoryDBContext.Entry(unitofmeasurementModel).State = EntityState.Modified; inventoryDBContext.Entry(unitofmeasurementModel).Property(x => x.CreatedOn).IsModified = false; inventoryDBContext.Entry(unitofmeasurementModel).Property(x => x.CreatedBy).IsModified = false; inventoryDBContext.SaveChanges(); responseData.Results = unitofmeasurementModel; responseData.Status = "OK"; } if (reqType == "UpdatePackagingType") { PackagingTypeMasterModel packagingtypeModel = DanpheJSONConvert.DeserializeObject <PackagingTypeMasterModel>(str); inventoryDBContext.PackagingTypeMaster.Attach(packagingtypeModel); inventoryDBContext.Entry(packagingtypeModel).State = EntityState.Modified; inventoryDBContext.Entry(packagingtypeModel).Property(x => x.CreatedOn).IsModified = false; inventoryDBContext.Entry(packagingtypeModel).Property(x => x.CreatedBy).IsModified = false; inventoryDBContext.SaveChanges(); responseData.Results = packagingtypeModel; responseData.Status = "OK"; } if (reqType == "UpdateAccountHead") { AccountHeadMasterModel accountheadModel = DanpheJSONConvert.DeserializeObject <AccountHeadMasterModel>(str); inventoryDBContext.AccountHeadMaster.Attach(accountheadModel); inventoryDBContext.Entry(accountheadModel).State = EntityState.Modified; inventoryDBContext.Entry(accountheadModel).Property(x => x.CreatedOn).IsModified = false; inventoryDBContext.Entry(accountheadModel).Property(x => x.CreatedBy).IsModified = false; inventoryDBContext.SaveChanges(); responseData.Results = accountheadModel; responseData.Status = "OK"; } if (reqType == "UpdateItem") { ItemMasterModel itemModel = DanpheJSONConvert.DeserializeObject <ItemMasterModel>(str); inventoryDBContext.Items.Attach(itemModel); inventoryDBContext.Entry(itemModel).State = EntityState.Modified; inventoryDBContext.Entry(itemModel).Property(x => x.CreatedOn).IsModified = false; inventoryDBContext.Entry(itemModel).Property(x => x.CreatedBy).IsModified = false; inventoryDBContext.SaveChanges(); responseData.Results = itemModel; responseData.Status = "OK"; } if (reqType == "UpdateCurrency") { CurrencyMasterModel currencyModel = DanpheJSONConvert.DeserializeObject <CurrencyMasterModel>(str); inventoryDBContext.CurrencyMaster.Attach(currencyModel); inventoryDBContext.Entry(currencyModel).State = EntityState.Modified; inventoryDBContext.Entry(currencyModel).Property(x => x.CreatedOn).IsModified = false; inventoryDBContext.Entry(currencyModel).Property(x => x.CreatedBy).IsModified = false; inventoryDBContext.SaveChanges(); responseData.Results = currencyModel; responseData.Status = "OK"; } } } catch (Exception ex) { responseData.Status = "Failed"; responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString(); } return(DanpheJSONConvert.SerializeObject(responseData, true)); }
public string Post() { //if reqtype=employee, then use masterdbcontext.employee.add and so on for others. DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>(); //type 'object' since we have variable return types responseData.Status = "OK"; //by default status would be OK, hence assigning at the top InventoryDbContext inventoryDBContext = new InventoryDbContext(connString); try { //string str = Request.Form.Keys.First<string>(); string str = this.ReadPostData(); string reqType = this.ReadQueryStringData("reqType"); string vendorName = this.ReadQueryStringData("vendorName"); int itemId = ToInt(this.ReadQueryStringData("itemId")); if (reqType == "AddVendors") { VendorMasterModel vendorModel = DanpheJSONConvert.DeserializeObject <VendorMasterModel>(str); vendorModel.CreatedOn = System.DateTime.Now; inventoryDBContext.Vendors.Add(vendorModel); inventoryDBContext.SaveChanges(); responseData.Results = vendorModel; responseData.Status = "OK"; } else if (reqType == "AddItemCategory") { ItemCategoryMasterModel itemcategoryModel = DanpheJSONConvert.DeserializeObject <ItemCategoryMasterModel>(str); itemcategoryModel.CreatedOn = System.DateTime.Now; inventoryDBContext.ItemCategoryMaster.Add(itemcategoryModel); inventoryDBContext.SaveChanges(); responseData.Results = itemcategoryModel; responseData.Status = "OK"; } else if (reqType == "AddItemSubCategory") { ItemSubCategoryMasterModel itemsubcategoryModel = DanpheJSONConvert.DeserializeObject <ItemSubCategoryMasterModel>(str); itemsubcategoryModel.CreatedOn = System.DateTime.Now; inventoryDBContext.ItemSubCategoryMaster.Add(itemsubcategoryModel); inventoryDBContext.SaveChanges(); responseData.Results = itemsubcategoryModel; responseData.Status = "OK"; } //posting to inventory terms & conditions else if (reqType == "PostInventoryTerms") { InventoryTermsModel termsconditions = DanpheJSONConvert.DeserializeObject <InventoryTermsModel>(str); termsconditions.CreatedOn = System.DateTime.Now; inventoryDBContext.InventoryTerms.Add(termsconditions); inventoryDBContext.SaveChanges(); responseData.Results = termsconditions; responseData.Status = "OK"; } else if (reqType == "AddUnitOfMeasurement") { UnitOfMeasurementMasterModel unitofmeasurementModel = DanpheJSONConvert.DeserializeObject <UnitOfMeasurementMasterModel>(str); unitofmeasurementModel.CreatedOn = System.DateTime.Now; inventoryDBContext.UnitOfMeasurementMaster.Add(unitofmeasurementModel); inventoryDBContext.SaveChanges(); responseData.Results = unitofmeasurementModel; responseData.Status = "OK"; } else if (reqType == "AddPackagingType") { PackagingTypeMasterModel packagingtypeModel = DanpheJSONConvert.DeserializeObject <PackagingTypeMasterModel>(str); packagingtypeModel.CreatedOn = System.DateTime.Now; inventoryDBContext.PackagingTypeMaster.Add(packagingtypeModel); inventoryDBContext.SaveChanges(); responseData.Results = packagingtypeModel; responseData.Status = "OK"; } else if (reqType == "AddAccountHead") { AccountHeadMasterModel accountheadModel = DanpheJSONConvert.DeserializeObject <AccountHeadMasterModel>(str); accountheadModel.CreatedOn = System.DateTime.Now; inventoryDBContext.AccountHeadMaster.Add(accountheadModel); inventoryDBContext.SaveChanges(); responseData.Results = accountheadModel; responseData.Status = "OK"; } else if (reqType == "AddItem") { ItemMasterModel itemModel = DanpheJSONConvert.DeserializeObject <ItemMasterModel>(str); itemModel.CreatedOn = System.DateTime.Now; inventoryDBContext.Items.Add(itemModel); inventoryDBContext.SaveChanges(); responseData.Results = itemModel; responseData.Status = "OK"; } else if (reqType == "AddCurrency") { CurrencyMasterModel currencyModel = DanpheJSONConvert.DeserializeObject <CurrencyMasterModel>(str); currencyModel.CreatedOn = System.DateTime.Now; inventoryDBContext.CurrencyMaster.Add(currencyModel); inventoryDBContext.SaveChanges(); responseData.Results = currencyModel; responseData.Status = "OK"; } } catch (Exception ex) { responseData.Status = "Failed"; responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString(); } return(DanpheJSONConvert.SerializeObject(responseData, true)); }