public static int DeleteTC(int tCID)
{
string sqlDelete = @"DELETE FROM TESTCERTIFICATE
WHERE (TCID=@TCID)";
SqlParameter[] sqlParameters = { new SqlParameter("@TCID", tCID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int InsertMajor(Major major)
{
string sqlInsert = @"INSERT INTO MAJOR(MAJORNAME)
VALUES (@MajorName)";
SqlParameter[] sqlParameters = { new SqlParameter("@MajorName", major.MajorName) };
return(SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters));
}
public static int DeleteMajor(int majorID)
{
string sqlDelete = @"DELETE FROM MAJOR
WHERE (MAJORID = @MajorID)";
SqlParameter[] sqlParameters = { new SqlParameter("@MajorID", majorID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int DeletePrescription(int pID)
{
string sqlDelete = @"DELETE FROM PRESCRIPTION
WHERE (PRESCRIPTIONID=@PRESCRIPTIONID)";
SqlParameter[] sqlParameters = { new SqlParameter("@PRESCRIPTIONID", pID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int DeleteService(int serviceID)
{
string sqlDelete = @"DELETE FROM SERVICE
WHERE (SERVICEID = @SERVICEID)";
SqlParameter[] sqlParameters = { new SqlParameter("@SERVICEID", serviceID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int DeleteHN(int hNID)
{
string sqlDelete = @"DELETE FROM HEATHMONITORINGNOTE
WHERE (HNID=@HNID)";
SqlParameter[] sqlParameters = { new SqlParameter("@HNID", hNID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int DeleteTestDetail(int tCID)
{
string sqlDelete = @"DELETE FROM TESTDETAIL
WHERE TCID=@TCID";
SqlParameter[] sqlParameters = { new SqlParameter("@TCID", tCID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int DeleteRole(int RoleID)
{
string sqlDelete = @"DELETE FROM Role
WHERE (RoleID=@RoleID)";
SqlParameter[] sqlParameters = { new SqlParameter("@RoleID", RoleID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int DeleteHospitalBed(int bedID)
{
string sqlDelete = @"DELETE FROM HOSPITALBED
WHERE (BEDID = @BEDID)";
SqlParameter[] sqlParameters = { new SqlParameter("@BEDID", bedID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int DeleteRoleDetail(int roleID)
{
string sqlDelete = @"DELETE FROM ROLEDETAIL
WHERE ROLEID=@ROLEID";
SqlParameter[] sqlParameters = { new SqlParameter("@ROLEID", roleID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int DeleteDisease(int diseaseID)
{
string sqlDelete = @"DELETE FROM DISEASE
WHERE (DISEASEID = @DISEASEID)";
SqlParameter[] sqlParameters = { new SqlParameter("@DISEASEID", diseaseID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int DeleteDepartment(int departmentID)
{
string sqlDelete = @"DELETE FROM DEPARTMENT
WHERE (DEPARTMENTID = @DEPARTMENTID)";
SqlParameter[] sqlParameters = { new SqlParameter("@DEPARTMENTID", departmentID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int DeleteHC(int hCID)
{
string sqlDelete = @"DELETE FROM HOSPITALIZATIONCERTIFICATE
WHERE (HCID=@HCID)";
SqlParameter[] sqlParameters = { new SqlParameter("@HCID", hCID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int DeleteMaterial(int materialID)
{
string sqlDelete = @"DELETE FROM MATERIAL
WHERE (MATERIALID=@MATERIALID)";
SqlParameter[] sqlParameters = { new SqlParameter("@MATERIALID", materialID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int DeleteFunction(int functionID)
{
string sqlDelete = @"DELETE FROM ROLEFUNCTION
WHERE (FUNCTIONID=@FUNCTIONID)";
SqlParameter[] sqlParameters = { new SqlParameter("@FUNCTIONID", functionID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int DeleteMedicne(int medicineID)
{
string sqlDelete = @"DELETE FROM MEDICINE
WHERE (MEDICINEID = @MEDICINEID)";
SqlParameter[] sqlParameters = { new SqlParameter("@MEDICINEID", medicineID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int DeleteDC(int dCID)
{
string sqlDelete = @"DELETE FROM DISCHARGEDCERTIFICATE
WHERE (DCID=@DCID)";
SqlParameter[] sqlParameters = { new SqlParameter("@DCID", dCID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int DeleteSurgical(int surgicalID)
{
string sqlDelete = @"DELETE FROM SURGICAL
WHERE (SURGICALID=@SURGICALID)";
SqlParameter[] sqlParameters = { new SqlParameter("@SURGICALID", surgicalID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int DeleteHIC(int hICID)
{
string sqlDelete = @"DELETE FROM HIC
WHERE (HICID=@HICID)";
SqlParameter[] sqlParameters = { new SqlParameter("@HICID", hICID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int InsertDepartment(Department newDepartment)
{
String sqlInsert = @"INSERT INTO DEPARTMENT(DEPARTMENTNAME)
VALUES (@DEPARTMENTNAME)";
SqlParameter[] sqlParameters = { new SqlParameter("@DEPARTMENTNAME", newDepartment.DepartmentName) };
return(SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters));
}
public static int DeleteAssignment(int assignmentID)
{
string sqlDelete = @"DELETE FROM ASSIGNMENT
WHERE (ASSIGNID=@ASSIGNID)";
SqlParameter[] sqlParameters = { new SqlParameter("@ASSIGNID", assignmentID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int DeleteHeathFile(int heathFileID)
{
string sqlDelete = @"DELETE FROM HEATHFILE
WHERE (HEATHFILEID=@HEATHFILEID)";
SqlParameter[] sqlParameters = { new SqlParameter("@HEATHFILEID", heathFileID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int InsertRole(Role newRole)
{
String sqlInsert = @"INSERT INTO Role (RoleNAME)
VALUES (@RoleNAME)";
SqlParameter[] sqlParameters = { new SqlParameter("@RoleNAME", newRole.RoleName) };
return(SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters));
}
public static int DeleteEC(int eCID)
{
string sqlDelete = @"DELETE FROM EXAMINATIONCERTIFICATE
WHERE (ECID=@ECID)";
SqlParameter[] sqlParameters = { new SqlParameter("@ECID", eCID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int DeleteBill(int billID)
{
string sqlDelete = @"DELETE FROM BILL
WHERE (BILLID=@BILLID)";
SqlParameter[] sqlParameters = { new SqlParameter("@BILLID", billID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int InsertFunction(RoleFunction newFunction)
{
String sqlInsert = @"INSERT INTO ROLEFUNCTION(FUNCTIONNAME, BUTTON)
VALUES (@FUNCTIONNAME,@BUTTON)";
SqlParameter[] sqlParameters = { new SqlParameter("@FUNCTIONNAME", newFunction.FucntionName),
new SqlParameter("@BUTTON", newFunction.Button) };
return(SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters));
}
public static int DeleteRoleDetail(int roleID, int functionID)
{
string sqlDelete = @"UPDATE ROLEDETAIL
WHERE ROLEID=@ROLEID AND FUNCTIONID=@FUNCTIONID";
SqlParameter[] sqlParameters = { new SqlParameter("@ROLEID", roleID),
new SqlParameter("@FUNCTIONID", functionID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int InsertDisease(Disease newDisease)
{
String sqlInsert = @"INSERT INTO DISEASE(DISEASENAME,SYMPTOM)
VALUES (@DISEASENAME,@SYMPTOM)";
SqlParameter[] sqlParameters = { new SqlParameter("@DISEASENAME", newDisease.DiseaseName),
new SqlParameter("@SYMPTOM", newDisease.Symptom) };
return(SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters));
}
public static int DeleteMedicineBillDetail(int billID)
{
string sqlDelete = @"DELETE FROM MEDICINEBILLDETAIL
WHERE BILLID=@BILLID";
SqlParameter[] sqlParameters = { new SqlParameter("@BILLID", billID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int InsertRoleDetail(RoleDetail newRD)
{
String sqlInsert = @"INSERT INTO ROLEDETAIL(ROLEID, FUNCTIONID)
VALUES (@ROLEID,@FUNCTIONID)";
SqlParameter[] sqlParameters = { new SqlParameter("@ROLEID", newRD.RoleID),
new SqlParameter("@FUNCTIONID", newRD.FunctionID) };
return(SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters));
}
