public static DataView ActivatePersonRole(string personRoleID)
{
DBFun.dbFunctions dbFun = new DBFun.dbFunctions(_connString);
dbFun.ExecSelectProc("ActivatePersonRole", personRoleID);
if (dbFun.blnError)
{
_blnError = dbFun.blnError;
_strError = dbFun.strError;
return(null);
}
return(dbFun.DV);
}
//_________________________________________________________________________________
public static DataView DoLogin(string username, string pwd)
{
DBFun.dbFunctions dbFun = new DBFun.dbFunctions(_connString);
dbFun.ExecSelectProc("DoLogin", username + "#~~#" + pwd);
if (dbFun.blnError)
{
_blnError = dbFun.blnError;
_strError = dbFun.strError;
return(null);
}
return(dbFun.DV);
}
// ----------------------------------------------- Incident History ---------------------------------------------------------------------
public static DataView GET_InvestigationHistory_Search_IMO(string refNumber, string incidentStatus, string isAnyPersonInjured, string isTreatmentProvided, string fromDate, string toDate, int unitID)
{
DBFun.dbFunctions dbFun = new DBFun.dbFunctions(_connString);
dbFun.ExecSelectProc("GET_InvestigationHistory_Search_IMO", refNumber + "#~~#" + incidentStatus + "#~~#" + isAnyPersonInjured + "#~~#" + isTreatmentProvided + "#~~#" + fromDate + "#~~#" + toDate + "#~~#" + unitID);
if (dbFun.blnError)
{
_blnError = dbFun.blnError;
_strError = dbFun.strError;
return(null);
}
return(dbFun.DV);
}
public static DataView Registration(string UserName, string Password, string FirstName, string LastName, string Mobile, string Gender)
{
DBFun.dbFunctions dbFun = new DBFun.dbFunctions(_connString);
dbFun.ExecSelectProc("UserRegistration", UserName + "#~~#" + Password + "#~~#" + FirstName + "#~~#" + LastName + "#~~#" + Mobile + "#~~#" + Gender);
if (dbFun.blnError)
{
_blnError = dbFun.blnError;
_strError = dbFun.strError;
return(null);
}
return(dbFun.DV);
}
public static DataView GetIncidentLocation()
{
DBFun.dbFunctions dbFun = new DBFun.dbFunctions(_connString);
dbFun.ExecSelectProc("GetLocation", "");
if (dbFun.blnError)
{
_blnError = dbFun.blnError;
_strError = dbFun.strError;
return(null);
}
return(dbFun.DV);
}
//_________________________________________________________________________________
public static DataView GetAcademicIntegrity()
{
DBFun.dbFunctions dbFun = new DBFun.dbFunctions(_connString);
dbFun.ExecSelectProc("GetAcademicIntegrity", "");
if (dbFun.blnError)
{
_blnError = dbFun.blnError;
_strError = dbFun.strError;
return(null);
}
return(dbFun.DV);
}
//_________________________________________________________________________________
public static DataView GetRegulationsEthics()
{
DBFun.dbFunctions dbFun = new DBFun.dbFunctions(_connString);
dbFun.ExecSelectProc("GetRegulationsEthics", "");
if (dbFun.blnError)
{
_blnError = dbFun.blnError;
_strError = dbFun.strError;
return(null);
}
return(dbFun.DV);
}
public static DataView GetProbabilityofReoccurrence()
{
DBFun.dbFunctions dbFun = new DBFun.dbFunctions(_connString);
dbFun.ExecSelectProc("GetProbabilityofReoccurrence", "");
if (dbFun.blnError)
{
_blnError = dbFun.blnError;
_strError = dbFun.strError;
return(null);
}
return(dbFun.DV);
}
public static DataView GetEnvironmentEquipment()
{
DBFun.dbFunctions dbFun = new DBFun.dbFunctions(_connString);
dbFun.ExecSelectProc("GetEnvironmentEquipment", "");
if (dbFun.blnError)
{
_blnError = dbFun.blnError;
_strError = dbFun.strError;
return(null);
}
return(dbFun.DV);
}
// ----------------------------------------------- Incident History ---------------------------------------------------------------------
public static DataView GET_IncidentsForPerson(string personID)
{
DBFun.dbFunctions dbFun = new DBFun.dbFunctions(_connString);
dbFun.ExecSelectProc("GET_IncidentsForPerson", personID);
if (dbFun.blnError)
{
_blnError = dbFun.blnError;
_strError = dbFun.strError;
return(null);
}
return(dbFun.DV);
}
public static DataSet AddUpdateUserDetailsByNationalID(string nationalID, string fullName, string email, string phone, string mobile)
{
DBFun.dbFunctions dbFun = new DBFun.dbFunctions(_connString);
// @username, @pwd , @firstname, @lastname, @nationIqama, @mobile , @personalEmail , @gender , @ERROR OUT)
dbFun.ExecSelectProc("AddUpdateUserDetailsByNationalID", nationalID + "#~~#" + fullName + "#~~#" + email + "#~~#" + phone + "#~~#" + mobile);
if (dbFun.blnError)
{
_blnError = dbFun.blnError;
_strError = dbFun.strError;
return(null);
}
return(dbFun.DSet);
}
// ----------------------------------------------- GetInvestigationData ---------------------------------------------------------------------
// @PersonID , @IncidentID, @IncidentSubInvestigationCausesIDs, @OtherInvestigation, @IncidentStatus, @Comments)
public static DataView InvestigationData(string PersonID, string IncidentID, string IncidentSubInvestigationCausesIDs, string OtherInvestigation, string IncidentStatus, string Comments)
{
DBFun.dbFunctions dbFun = new DBFun.dbFunctions(_connString);
dbFun.ExecSelectProc("InvestigationFormData", PersonID + "#~~#" + IncidentID + "#~~#" + IncidentSubInvestigationCausesIDs + "#~~#" + OtherInvestigation + "#~~#" + IncidentStatus + "#~~#" + Comments);
if (dbFun.blnError)
{
_blnError = dbFun.blnError;
_strError = dbFun.strError;
return(null);
}
return(dbFun.DV);
}
public static DataSet CheckAndGetDataForOthersLogin(string userName)
{
DBFun.dbFunctions dbFun = new DBFun.dbFunctions(_connString);
// @username, @pwd , @firstname, @lastname, @nationIqama, @mobile , @personalEmail , @gender , @ERROR OUT)
dbFun.ExecSelectProc("CheckAndGetDataForOthersLogin", userName);
if (dbFun.blnError)
{
_blnError = dbFun.blnError;
_strError = dbFun.strError;
return(null);
}
return(dbFun.DSet);
}
// ----------------------------------------------- Insert_VDQ Comments & Status ---------------------------------------------------------------------
public static DataView InsertVDQCommentStatus(string PersonID, string IncidentID, string IncidentStatus, string Comments)
{
DBFun.dbFunctions dbFun = new DBFun.dbFunctions(_connString);
dbFun.ExecSelectProc("InsertVDQCommentStatus", PersonID + "#~~#" + IncidentID + "#~~#" + IncidentStatus + "#~~#" + Comments);
if (dbFun.blnError)
{
_blnError = dbFun.blnError;
_strError = dbFun.strError;
return(null);
}
return(dbFun.DV);
}
// CREATE PROCEDURE DoActionPlan( @Incident_Id int, @StringData VARCHAR(8000), @rowDeliminater CHAR(1), @colDeliminater CHAR(1))
public static DataView DoActionPlan(string IncidentID, string StringData, string rowDeliminater, string colDeliminater)
{
DBFun.dbFunctions dbFun = new DBFun.dbFunctions(_connString);
dbFun.ExecSelectProc("DoActionPlan", IncidentID + "#~~#" + StringData + "#~~#" + rowDeliminater + "#~~#" + colDeliminater);
if (dbFun.blnError)
{
_blnError = dbFun.blnError;
_strError = dbFun.strError;
return(null);
}
return(dbFun.DV);
}
// ----------------------------------------------- GetAllInformation ---------------------------------------------------------------------
public static DataSet GetAllInformation(string RefNumber)
{
DBFun.dbFunctions dbFun = new DBFun.dbFunctions(_connString);
dbFun.ExecSelectProc("GetAllInformation", RefNumber);
if (dbFun.blnError)
{
_blnError = dbFun.blnError;
_strError = dbFun.strError;
return(null);
}
//DeleteTopEmptyRecord(dbFun.DSet);
return(dbFun.DSet);
}
//public static DataView IncidentData(string RefNumber, string UnitID, string TreatmentLocationID, string IncidentDateTime, string OtherLocation, string IncidentDesc, string IsAnyPersonInjured, string InjuryDesc, string IsTreatmentProvided, string ActionDesc, string AdditionalInfo, string Imgname, string IncidentSubCategoryID, string OtherIncident, string CorrectiveActionID)
public static DataView IncidentData(string roleID, string UnitID, string TreatmentLocationID, string IncidentDateTime, string OtherLocation, string IncidentDesc, string IsAnyPersonInjured, string InjuryDesc, string IsTreatmentProvided, string ActionDesc, string AdditionalInfo, string Imgname, string IncidentSubCategoryID, string OtherIncident, string CorrectiveActionID, string PersonID, string Historystatus, string Comments)
{ //@PersonRolesID @UnitID, @TreatmentLocationID, @IncidentDateTime, @OtherLocation, @IncidentDesc, @IsAnyPersonInjured, @InjuryDesc, @IsTreatmentProvided, @ActionDesc, @AdditionalInfo, @Imgname @IncidentSubCategoryID, @OtherIncident @CorrectiveActionID @Historystatus
if (IsTreatmentProvided == "N")
{
TreatmentLocationID = "4";
}
DBFun.dbFunctions dbFun = new DBFun.dbFunctions(_connString);
dbFun.ExecSelectProc("IncidentFormData", roleID + "#~~#" + UnitID + "#~~#" + TreatmentLocationID + "#~~#" + IncidentDateTime + "#~~#" + OtherLocation + "#~~#" + IncidentDesc + "#~~#" + IsAnyPersonInjured + "#~~#" + InjuryDesc + "#~~#" +
IsTreatmentProvided + "#~~#" + ActionDesc + "#~~#" + AdditionalInfo + "#~~#" + Imgname + "#~~#" + IncidentSubCategoryID + "#~~#" + OtherIncident + "#~~#" + CorrectiveActionID + "#~~#" + PersonID + "#~~#" + Historystatus + "#~~#" + Comments);
//dbFun.ExecSelectProc("IncidentFormData", UnitID + "#~~#" + OtherLocation + "#~~#" + IncidentDesc + "#~~#" + IsAnyPersonInjured + "#~~#" + InjuryDesc + "#~~#" +
// IsTreatmentProvided + "#~~#" + ActionDesc + "#~~#");
if (dbFun.blnError)
{
_blnError = dbFun.blnError;
_strError = dbFun.strError;
return(null);
}
return(dbFun.DV);
}