public async Task <ActionResult> DeleteConfirmed(int id)
{
BillingRules billingRules = await db.BillingRules.FindAsync(id);
db.BillingRules.Remove(billingRules);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public ActionResult Rules([Bind(Prefix="ID")]int RuleID = 0) {
Models.BillingRules billingRules = null;
if (RuleID > 0) {
billingRules = db.BillingRules.Where(w => w.RuleID == RuleID).FirstOrDefault();
}
if (billingRules == null)
billingRules = new BillingRules();
return View(billingRules);
}
public async Task <ActionResult> Edit([Bind(Include = "RuleID,RuleName,RuleDescription,CalculateField,ApplyCondition")] BillingRules billingRules)
{
if (ModelState.IsValid)
{
db.Entry(billingRules).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(billingRules));
}
// GET: BillingRules/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BillingRules billingRules = await db.BillingRules.FindAsync(id);
if (billingRules == null)
{
return(HttpNotFound());
}
return(View(billingRules));
}
public bool IsValid(BillingRules Rule, out String ValidationError)
{
String SQL;
ValidationError = String.Empty;
//Check the table and field is defined
SQL = $"SELECT {Rule.CalculateField} FROM {Rule.CalculateOn} WHERE 1 = 0";
if (!String.IsNullOrWhiteSpace(Rule.ApplyCondition))
{
SQL += $" AND ({Rule.ApplyCondition})";
}
try {
ctx.Database.Connection.Open();
var result = ctx.Database.ExecuteSqlCommand(SQL);
} catch (Exception e) {
ValidationError = e.Message;
return(false);
}
return(true);
}
public bool IsValid(BillingRules Rule)
{
return(false);
}
