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