User-1419511951 posted
This is my source code:-- SpellServices.cs:- using System; using System.Collections.Generic; using System.Linq; using QFT_POMS_SVC.Domain.POMS; using System.Web.Http; namespace QFT_POMS_SVC.DAL.POMS { public class SpellServices : ISpellServices { private
DBMapper _dbContext; private Result _result; public IList<distributorproductmapping> GetAllDistributorsOp() { var query = from d in _dbContext.DistributorProductMappingRepository select d; return query.ToList(); } public int SaveDistributordetails(int id,DistributorProductMapping
items) { DistributorProductMapping DPM = new DistributorProductMapping(); DPM.DistributorId = items.DistributorId; DPM.ProductId = items.ProductId; DPM.Rank = items.Rank; DPM.SKU = items.SKU; DPM.StockStatus = items.StockStatus; DPM.UnitPrice = items.UnitPrice;
DPM.UpdatedBy = items.UpdatedBy; DPM.UpdatedDate = items.UpdatedDate; DPM.WholeSaleExpected = items.WholeSaleExpected; DPM.WholeSaleReceived = items.WholeSaleReceived; DPM.MSRPExpected = items.MSRPExpected; DPM.MSRPReceived = items.MSRPReceived; DPM.CreationDate
= items.CreationDate; DPM.CreatedBy = items.CreatedBy; DPM.UpdatedDate = items.UpdatedDate; DPM.UpdatedBy = items.UpdatedBy; DPM.Comment = items.Comment; DPM.HasTierPrices = items.HasTierPrices; // _dbContext.DistributorProductMappingRepository.AddRange(items);
return _dbContext.SaveChanges(); } public int Update(int Id,DistributorProductMapping obj) { // DistributorProductMapping obj1 = new DistributorProductMapping(); // DistributorProductMapping obj1 = _dbContext.DistributorProductMappingRepository.SingleOrDefault(x
=> x.Id==1); var obj1 = _dbContext.DistributorProductMappingRepository.FirstOrDefault(x => x.Id == Id); obj1.DistributorId =obj.DistributorId; obj1.ProductId = obj.ProductId; obj1.SKU = obj.SKU; obj1.StockStatus = obj.StockStatus; obj1.UnitPrice = obj.UnitPrice;
obj1.deleted = obj.deleted; obj1.Rank = obj.Rank; obj1.DiscountExpected = obj.DiscountExpected; obj1.DiscountReceived = obj.DiscountReceived; obj1.WholeSaleExpected = obj.WholeSaleExpected; obj1.WholeSaleReceived = obj.WholeSaleReceived; obj1.MSRPExpected
= obj.MSRPExpected; obj1.MSRPReceived = obj.MSRPReceived; obj1.CreationDate = obj.CreationDate; obj1.CreatedBy = obj.CreatedBy; obj1.UpdatedDate = obj.UpdatedDate; obj1.UpdatedBy = obj.UpdatedBy; obj1.Comment = obj.Comment; obj1.HasTierPrices = obj.HasTierPrices;
return _dbContext.SaveChanges(); } public int Delete(int Id) { DistributorProductMapping obj = (from x in _dbContext.DistributorProductMappingRepository where x.Id == Id select x).FirstOrDefault(); obj.deleted = true; return _dbContext.SaveChanges(); } public
int GetAllDistributorlist(int id) { DistributorProductMapping obj = (from x in _dbContext.DistributorProductMappingRepository where x.Id == id select x).SingleOrDefault(); //DistributorProductMapping obj1 = new DistributorProductMapping(); DistributorProductMapping
obj2 = _dbContext.DistributorProductMappingRepository.SingleOrDefault(x => x.Id==id); return _dbContext.SaveChanges(); } } } ISpellServices.cs using System.Collections.Generic; using QFT_POMS_SVC.Domain.POMS; namespace QFT_POMS_SVC.DAL.POMS { public interface
ISpellServices { int SaveDistributordetails(int Id, DistributorProductMapping items); int Update(int Id,DistributorProductMapping obj); int Delete(int Id); int GetAllDistributorlist(int id); } } SpellController.cs:-- using QFT_POMS_SVC.DAL.POMS; using QFT_POMS_SVC.Domain.POMS;
using System.Collections.Generic; using System.Net; using System.Net.Http; using System.Web.Http; using System.Web.Http.Cors; namespace QFT_POMS_SVC.Controllers { [RoutePrefix("Spell")] [EnableCors(origins: "*", headers: "*", methods: "*")] public class SpellController
: ApiController { private readonly ISpellServices _poService; public SpellController(ISpellServices poService) { this._poService = poService; } [HttpPost] [Route("AddTestEvent")] public HttpResponseMessage AddTestEvent(int PurchaseOrderId) { HttpResponseMessage
httpResponse = null; return httpResponse; } [HttpPost] [Route("SaveDistributordetails")] public HttpResponseMessage SaveDistributordetails(int Id) { var response = _poService.SaveDistributordetails(1,new DistributorProductMapping()); HttpResponseMessage httpResponse
= null; if (response == null) { httpResponse = Request.CreateResponse(HttpStatusCode.InternalServerError, response); return httpResponse; } else if (response != 0) { httpResponse = Request.CreateResponse(HttpStatusCode.BadRequest, response); return httpResponse;
} return Request.CreateResponse(HttpStatusCode.OK, response); } [HttpPut] [Route("Update")] public HttpResponseMessage Update(int Id,DistributorProductMapping obj) { var response = _poService.Update(1,obj); HttpResponseMessage httpResponse = null; if(response==null)
{ httpResponse = Request.CreateResponse(HttpStatusCode.InternalServerError, response); return httpResponse; } else if(response!=0) { httpResponse = Request.CreateResponse(HttpStatusCode.BadRequest, response); return httpResponse; } return Request.CreateResponse(HttpStatusCode.OK,
response); } [HttpDelete] [Route("Delete")] public HttpResponseMessage Delete(int Id) { var response = _poService.Delete(Id); HttpResponseMessage httpResponse = null; if(response==null) { httpResponse = Request.CreateResponse(HttpStatusCode.InternalServerError,
response); return httpResponse; } else if(response!=0) { httpResponse = Request.CreateResponse(HttpStatusCode.BadRequest, response); return httpResponse; ; } return Request.CreateResponse(HttpStatusCode.OK, response); } [HttpGet] [Route("GetAllDistributorlist")]
public HttpResponseMessage GetAllDistributorlist(int Id) { var response = _poService.GetAllDistributorlist(1); HttpResponseMessage httpResponse = null; if (response == null) { httpResponse = Request.CreateResponse(HttpStatusCode.InternalServerError, response);
return httpResponse; } else if (response != 0) { httpResponse = Request.CreateResponse(HttpStatusCode.BadRequest, response); return httpResponse; ; } return Request.CreateResponse(HttpStatusCode.OK, response); } } } </distributorproductmapping>
