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