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