public async Task <IHttpActionResult> PostMERCHANT_SUMMARY_DAILY(MERCHANT_SUMMARY_DAILY mERCHANT_SUMMARY_DAILY) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.MERCHANT_SUMMARY_DAILY.Add(mERCHANT_SUMMARY_DAILY); try { await db.SaveChangesAsync(); } catch (DbUpdateException) { if (MERCHANT_SUMMARY_DAILYExists(mERCHANT_SUMMARY_DAILY.ReportDate)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = mERCHANT_SUMMARY_DAILY.ReportDate }, mERCHANT_SUMMARY_DAILY)); }
public async Task <IHttpActionResult> PutMERCHANT_SUMMARY_DAILY(DateTime id, MERCHANT_SUMMARY_DAILY mERCHANT_SUMMARY_DAILY) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != mERCHANT_SUMMARY_DAILY.ReportDate) { return(BadRequest()); } db.Entry(mERCHANT_SUMMARY_DAILY).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MERCHANT_SUMMARY_DAILYExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public MERCHANT_SUMMARY_DAILY GetMerchantSummaryForMerchantCode(string MerchantCode) { object[] paremeter = { new SqlParameter("@MerchantCode", MerchantCode) }; MERCHANT_SUMMARY_DAILY res = db.Database.SqlQuery <MERCHANT_SUMMARY_DAILY>("exec SP_GetMerchantSummaryForMerchantCode @MerchantCode", paremeter).FirstOrDefault(); return(res); }
public async Task <IHttpActionResult> GetMERCHANT_SUMMARY_DAILY(DateTime id) { MERCHANT_SUMMARY_DAILY mERCHANT_SUMMARY_DAILY = await db.MERCHANT_SUMMARY_DAILY.FindAsync(id); if (mERCHANT_SUMMARY_DAILY == null) { return(NotFound()); } return(Ok(mERCHANT_SUMMARY_DAILY)); }
public MERCHANT_SUMMARY_DAILY GetMerchantSummaryForAgentDefaultMerchantCode(string AgentCode, string MerchantCode, DateTime ReportDate) { object[] paremeter = { new SqlParameter("@AgentCode", AgentCode), new SqlParameter("@MerchantCode", MerchantCode), new SqlParameter("@ReportDate", ReportDate) }; MERCHANT_SUMMARY_DAILY res = db.Database.SqlQuery <MERCHANT_SUMMARY_DAILY>("exec SP_GetMerchantSummaryForAgent_Default_MerchantCode @AgentCode,@MerchantCode,@ReportDate", paremeter).FirstOrDefault(); return(res); }
public async Task <IHttpActionResult> DeleteMERCHANT_SUMMARY_DAILY(DateTime id) { MERCHANT_SUMMARY_DAILY mERCHANT_SUMMARY_DAILY = await db.MERCHANT_SUMMARY_DAILY.FindAsync(id); if (mERCHANT_SUMMARY_DAILY == null) { return(NotFound()); } db.MERCHANT_SUMMARY_DAILY.Remove(mERCHANT_SUMMARY_DAILY); await db.SaveChangesAsync(); return(Ok(mERCHANT_SUMMARY_DAILY)); }