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