public ActionResult addAgent(AgentModel model)
{
if (ModelState.IsValid)
{
var res = AdminPanelBizLayer.addAgent(model);
}
ModelState.Clear();
ViewBag.Message = "Agent Addition Successful! <a href=\"/Admin\">Go to Home page</a>";
return View("Success");
}
public static bool addAgent(AgentModel model)
{
SqlDatabase travelMSysDB = new SqlDatabase(ConnString.DBConnectionString);
SqlCommand insertCmmnd = new SqlCommand("INSERT INTO AGENTS(Agent_ID,Password,Agent_Name,Creator_Admin_ID,Phone_Num,Address) VALUES (@Agent_ID,@Password,@Agent_Name,@Creator_Admin_ID,@Phone_Num,@Address)");
insertCmmnd.CommandType = CommandType.Text;
insertCmmnd.Parameters.AddWithValue("@Agent_ID", model.Agent_ID);
insertCmmnd.Parameters.AddWithValue("@Password", "12d5ba628f5af19b9c8d5ccfe9283430");
//insertCmmnd.Parameters.AddWithValue("@Access_Status",model.Access_Status);
insertCmmnd.Parameters.AddWithValue("@Agent_Name", model.Agent_Name);
insertCmmnd.Parameters.AddWithValue("@Creator_Admin_ID", model.Creator_Admin_ID);
insertCmmnd.Parameters.AddWithValue("@Phone_Num", model.Phone_Num);
insertCmmnd.Parameters.AddWithValue("@Address", model.Address);
int rowsAffected = travelMSysDB.ExecuteNonQuery(insertCmmnd);
Console.Write("rowsAffected " + rowsAffected);
if (rowsAffected == 1)
return true;
return false;
}
public static bool addAgent(AgentModel model)
{
return AdminPanelDALayer.addAgent(model);
}