public HttpResponseMessage addTarget(dynamic pTarget) { try { using (PRINCE_STGEntities dbCtx = new PRINCE_STGEntities()) { STG_TARGET target = new STG_TARGET(); target.TARGET_DATE = pTarget.TARGET_DATE; target.GEO_LEVEL1_CODE = "99999"; target.GEO_LEVEL2_CODE = "99999"; target.GEO_LEVEL3_CODE = "99999"; target.STORE_CODE = pTarget.STORE_CODE; target.PROD_LEVEL1_CODE = pTarget.PROD_LEVEL1_CODE; target.PROD_LEVEL2_CODE = pTarget.PROD_LEVEL2_CODE; target.PROD_LEVEL3_CODE = "99999"; target.PROD_LEVEL4_CODE = "99999"; target.PROD_LEVEL5_CODE = "99999"; target.PRODUCT_CODE = "99999"; target.TARGET_SALE_QTY = 99999; target.TARGET_SALE_VAL_AT_PRICE = pTarget.TARGET_SALE_VAL_AT_PRICE; target.TARGET_SALE_VAL_AT_COST = 99999; target.ARC_DATE = DateTime.Now; dbCtx.STG_TARGET.Add(target); dbCtx.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created, "Target successfully created.")); } } catch (Exception ex) { Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex); } return(Request.CreateResponse(HttpStatusCode.OK)); }
public HttpResponseMessage updateTarget(dynamic pTarget) { try { using (PRINCE_STGEntities enBi = new PRINCE_STGEntities()) { using (var dbCtxTran = enBi.Database.BeginTransaction()) { //DateTime merchdate = sStoreMerch.merch_DATE; int id = pTarget.ID; //string storecode = sStoreMerch.STORE_CODE; STG_TARGET target = enBi.STG_TARGET.Find(id); if (target != null) { target.ID = pTarget.ID; target.TARGET_DATE = pTarget.TARGET_DATE; target.GEO_LEVEL1_CODE = pTarget.GEO_LEVEL1_CODE; target.GEO_LEVEL2_CODE = pTarget.GEO_LEVEL2_CODE; target.GEO_LEVEL3_CODE = pTarget.GEO_LEVEL3_CODE; target.STORE_CODE = pTarget.STORE_CODE; target.PROD_LEVEL1_CODE = pTarget.PROD_LEVEL1_CODE; target.PROD_LEVEL2_CODE = pTarget.PROD_LEVEL2_CODE; target.PROD_LEVEL3_CODE = pTarget.PROD_LEVEL3_CODE; target.PROD_LEVEL4_CODE = pTarget.PROD_LEVEL4_CODE; target.PROD_LEVEL5_CODE = pTarget.PROD_LEVEL5_CODE; target.PRODUCT_CODE = pTarget.PRODUCT_CODE; target.TARGET_SALE_QTY = pTarget.TARGET_SALE_QTY; target.TARGET_SALE_VAL_AT_PRICE = pTarget.TARGET_SALE_VAL_AT_PRICE; target.TARGET_SALE_VAL_AT_COST = pTarget.TARGET_SALE_VAL_AT_COST; target.ARC_DATE = pTarget.ARC_DATE; enBi.Entry(target).State = System.Data.Entity.EntityState.Modified; enBi.SaveChanges(); dbCtxTran.Commit(); return(Request.CreateResponse(HttpStatusCode.OK, "Target successfully Updated.")); } } } } catch (DbEntityValidationException ex) { ExceptionEntity exDesc = new ExceptionEntity(ex); throw new ApiException() { HttpStatus = HttpStatusCode.BadRequest, ErrorCode = (int)HttpStatusCode.BadRequest, ErrorDescription = exDesc.GetDescException() }; } catch (Exception ex) { ExceptionDescription exDesc = new ExceptionDescription(ex); throw new ApiException() { HttpStatus = HttpStatusCode.BadRequest, ErrorCode = (int)HttpStatusCode.BadRequest, ErrorDescription = exDesc.GetDescException() }; } return(Request.CreateResponse(HttpStatusCode.OK, "Target successfully Updated.")); }