public function updateAction($params)
{
$db = new connection();
$pk = $params['pk'];
if ($pk != "") {
$columns_values = array("exam_type" => $params['exam_type'], "description" => trim($params['description']), "modified_at" => $db->now_time, "modified_by" => $_SESSION['sys_user_id'], "flag" => 0);
$msg = "";
if ($db->alreadyExists("Select * from exam_type where flag=0 and exam_type='" . $params['exam_type'] . "' and exam_type_id!=" . $pk)) {
$res = $db->updateData($this->table_name, $columns_values, " exam_type_id={$pk}");
if ($res == true) {
$msg = "Success";
} else {
$msg = "Failed";
}
} else {
$msg = "Data Already Exists";
}
} else {
$msg = "System Error";
}
return $msg;
}
public function updateAction($params)
{
$db = new connection();
$pk = $params['pk'];
if ($pk != "") {
$columns_values = array("sys_role_id" => $pk, "sys_role" => $params['sys_role'], "created_at" => $db->now_time, "flag" => 0);
$msg = "";
if ($db->alreadyExists("Select * from system_role where sys_role='" . $params['sys_role'] . "' and sys_role_id!=" . $pk)) {
$res = $db->updateData($this->table_name, $columns_values, " sys_role_id={$pk}");
if ($res == true) {
$msg = "Success";
} else {
$msg = "Failed";
}
} else {
$msg = "Data Already Exists";
}
} else {
$msg = "System Error";
}
return $msg;
}
public function updateAction($params)
{
$db = new connection();
$pk = $params['pk'];
if ($pk != "") {
$columns_values = array("sys_name" => $params['sys_name'], "sys_role_id" => $params['sys_role_id'], "dob" => $db->storeDBDate($params['dob']), "email" => $params['email'], "mobile" => $params['mobile'], "address" => $params['address'], "user_name" => $params['user_name'], "modified_by" => $_SESSION['sys_user_id'], "modified_at" => $db->now_time, "flag" => 0);
$msg = "";
if ($db->alreadyExists("Select * from system_user where flag=0 and user_name='" . $params['user_name'] . "' and email='" . $params['email'] . "' and sys_user_id!='{$pk}'")) {
$res = $db->updateData($this->table_name, $columns_values, " sys_user_id={$pk}");
if ($res == true) {
$msg = "Success";
} else {
$msg = "Failed";
}
} else {
$msg = "Data Already Exists";
}
} else {
$msg = "System Error";
}
return $msg;
}
