public static bool NewClaimRequest(ClaimRequestsModel claimData)
{
SqlDatabase travelMSysDB = new SqlDatabase(ConnString.DBConnectionString);
SqlCommand insertCmmnd = new SqlCommand("INSERT INTO CLAIM_REQUESTS ([Travel_Request_ID],[Claim_Amount],[Settled_Amount],[Emp_Remarks]) VALUES (@Travel_Request_ID,@Claim_Amount,@Settled_Amount,@Remarks)");
insertCmmnd.CommandType = CommandType.Text;
insertCmmnd.Parameters.AddWithValue("@Travel_Request_ID", claimData.Travel_Request_ID);
insertCmmnd.Parameters.AddWithValue("@Claim_Amount", claimData.Claim_Amount);
insertCmmnd.Parameters.AddWithValue("@Settled_Amount", 0);
insertCmmnd.Parameters.AddWithValue("@Remarks", claimData.Remarks);
int rowsAffected = travelMSysDB.ExecuteNonQuery(insertCmmnd);
Console.Write("rowsAffected " + rowsAffected);
if (rowsAffected == 1)
return true;
return false;
}
public ActionResult NewClaimRequest(ClaimRequestsModel model)
{
if (ModelState.IsValid)
{
try
{
if (!ClaimRequestsBizLayer.NewClaimRequest(model))
return View("Error");
return RedirectToAction("Index", "Employee");
}
catch (MembershipCreateUserException e)
{
ModelState.AddModelError("", ErrorCodeToString(e.StatusCode));
}
}
// If we got this far, something failed, redisplay form
return View(model);
}
public static bool NewClaimRequest(ClaimRequestsModel claimData)
{
if (ClaimRequestsDALayer.NewClaimRequest(claimData))
return true;
return false;
}
