public DataTable FilterICDcodes(string initText) { try { //string connection = ConfigurationSettings.AppSettings["dbConnection"]; //SqlConnection con = new SqlConnection(connection); //string selectString = "select * from ICDCODE9000" + initText[0].ToString() + " where DescrENG like '" + initText + "%'"; //SqlCommand cmd = new SqlCommand(selectString, con); //cmd.CommandType = CommandType.Text; //SqlDataAdapter adb = new SqlDataAdapter(); //adb.SelectCommand = cmd; //DataTable tbl = new DataTable(); //adb.Fill(tbl); //return tbl; SqlDataReader searchResult = null; ListDictionary parm = new ListDictionary(); parm.Add("@initText", initText); searchResult = LoadFromSqlReader("Mho_Gui_GetICDcode", parm) as SqlDataReader; DataTable ResultTable = new DataTable(); newAdapter da = new newAdapter(); if (searchResult != null && searchResult.HasRows) { da.FillFromReader(ResultTable, searchResult); } return ResultTable; } catch { return new DataTable(); } }
public void DeleteReg(Guid regID) { SqlDataReader searchResult = null; ListDictionary parm = new ListDictionary(); parm.Add("@RegisterID", regID); searchResult = LoadFromSqlReader("ManualRegisterDelete", parm) as SqlDataReader; DataTable ResultTable = new DataTable(); newAdapter da = new newAdapter(); if (searchResult != null && searchResult.HasRows) { da.FillFromReader(ResultTable, searchResult); } }
public DataTable GetDefaultHealthOfficeData(string loggedIP) { SqlDataReader searchResult = null; ListDictionary parm = new ListDictionary(); parm.Add("@HealthOfficeIP", loggedIP); searchResult = LoadFromSqlReader("Mho_Gui_GetDefaultHealthOfficeData", parm) as SqlDataReader; DataTable ResultTable = new DataTable(); newAdapter da = new newAdapter(); if (searchResult != null && searchResult.HasRows) { da.FillFromReader(ResultTable, searchResult); } return ResultTable; }
public DataTable GetHealthOfficeDetails(short govID, short civilId) { SqlDataReader searchResult = null; ListDictionary parm = new ListDictionary(); parm.Add("@GovId", govID); parm.Add("@CivilId", civilId); searchResult = LoadFromSqlReader("GetHealthOffices", parm) as SqlDataReader; DataTable ResultTable = new DataTable(); newAdapter da = new newAdapter(); if (searchResult != null && searchResult.HasRows) { da.FillFromReader(ResultTable, searchResult); } return ResultTable; }
public DataTable GetUserData(Guid userId) { SqlDataReader searchResult = null; ListDictionary parm = new ListDictionary(); parm.Add("@userId", userId); searchResult = LoadFromSqlReader("GetUserData", parm) as SqlDataReader; DataTable ResultTable = new DataTable(); newAdapter da = new newAdapter(); if (searchResult != null && searchResult.HasRows) { da.FillFromReader(ResultTable, searchResult); } return ResultTable; }
/// <summary> /// Check if the Descision number exisit in Born or death case /// </summary> /// <param name="_descNo">reference for descision number</param> /// <param name="_isBorn">flag to indecate the table to check</param> /// <returns>boolean with the result.</returns> public bool IsDecisionNumberExisit(string _descNo,int _orgID,bool _isBorn) { SqlDataReader searchResult = null; ListDictionary parm = new ListDictionary(); parm.Add("@descNo", _descNo); parm.Add("@ISBorn", _isBorn); parm.Add("@orgID", _orgID); searchResult = LoadFromSqlReader("CheckDecisionNoExist", parm) as SqlDataReader; DataTable ResultTable = new DataTable(); newAdapter da = new newAdapter(); if (searchResult != null && searchResult.HasRows) { da.FillFromReader(ResultTable, searchResult); } return ResultTable.Rows.Count > 0; }
public void InsertNewRegister(int _hid,int _year,int _regType, string _regCode) { SqlDataReader searchResult = null; ListDictionary parm = new ListDictionary(); parm.Add("@hoID", _hid); parm.Add("@regType", _regType); parm.Add("@regCode", _regCode); parm.Add("@regYear", _year); searchResult = LoadFromSqlReader("ManualRegisterOpen", parm) as SqlDataReader; DataTable ResultTable = new DataTable(); newAdapter da = new newAdapter(); if (searchResult != null && searchResult.HasRows) { da.FillFromReader(ResultTable, searchResult); } }
public bool ApproveDeadInfo(Guid deadID) { try { SqlDataReader searchResult = null; ListDictionary parm = new ListDictionary(); parm.Add("@deadID", deadID); searchResult = LoadFromSqlReader("Mho_Gui_Approve_Dead", parm) as SqlDataReader; DataTable ResultTable = new DataTable(); newAdapter da = new newAdapter(); if (searchResult != null && searchResult.HasRows) { da.FillFromReader(ResultTable, searchResult); } return true; } catch { return false; } }
public DataTable FilterICDCat(string initText) { try { SqlDataReader searchResult = null; ListDictionary parm = new ListDictionary(); parm.Add("@filterText", initText); searchResult = LoadFromSqlReader("Mho_Gui_FilterICD10Cat", parm) as SqlDataReader; DataTable ResultTable = new DataTable(); newAdapter da = new newAdapter(); if (searchResult != null && searchResult.HasRows) { da.FillFromReader(ResultTable, searchResult); } return ResultTable; } catch { return new DataTable(); } }
public DataTable GetMachineDetails(int locationType, int govId, int civilId, int healthOfficeId) { SqlDataReader searchResult = null; ListDictionary parm = new ListDictionary(); parm.Add("@locationTypeId", locationType); if (govId!=-1) parm.Add("@GovId", govId); if (civilId!=-1) parm.Add("@CivilId", civilId); if(healthOfficeId!=-1) parm.Add("@HealthOfficeId", healthOfficeId); searchResult = LoadFromSqlReader("GetMachineDetails", parm) as SqlDataReader; DataTable ResultTable = new DataTable(); newAdapter da = new newAdapter(); if (searchResult != null && searchResult.HasRows) { da.FillFromReader(ResultTable, searchResult); } return ResultTable; }
public DataTable GetUserDetails(Guid roleId, int govId, int civilId, int healthOfficeId,string userNationalID) { SqlDataReader searchResult = null; ListDictionary parm = new ListDictionary(); parm.Add("@RoleId", roleId); if (govId != -1) parm.Add("@GovId", govId); if (civilId != -1) parm.Add("@CivilId", civilId); if (healthOfficeId != -1) parm.Add("@HealthOfficeId", healthOfficeId); if (userNationalID != "") parm.Add("@UserNationalID", userNationalID); searchResult = LoadFromSqlReader("GetUserDetails", parm) as SqlDataReader; DataTable ResultTable = new DataTable(); newAdapter da = new newAdapter(); if (searchResult != null && searchResult.HasRows) { da.FillFromReader(ResultTable, searchResult); } return ResultTable; }
public bool ValidateUserIPStatus(Guid _userID, string _currentIP) { SqlDataReader searchResult = null; ListDictionary parm = new ListDictionary(); parm.Add("@userID", _userID); parm.Add("@orgIpstr", _currentIP); searchResult = LoadFromSqlReader("ValidateUserMachineIPandStatus", parm) as SqlDataReader; DataTable ResultTable = new DataTable(); newAdapter da = new newAdapter(); if (searchResult != null && searchResult.HasRows) { da.FillFromReader(ResultTable, searchResult); } return ResultTable.Rows.Count > 0; }
/// <summary> /// Update user details /// </summary> /// <param name="userId"></param> /// <param name="roleId"></param> /// <param name="username"></param> /// <param name="email"></param> public void UpdateUserDetails(Guid userId, Guid roleId, string username, string email) { SqlDataReader searchResult = null; ListDictionary parm = new ListDictionary(); parm.Add("@userId", userId); parm.Add("@RoleId", roleId); parm.Add("@Email", email); parm.Add("@UserName", username); parm.Add("@LowerUserName", username.ToLower()); searchResult = LoadFromSqlReader("UpdateUserData", parm) as SqlDataReader; DataTable ResultTable = new DataTable(); newAdapter da = new newAdapter(); if (searchResult != null && searchResult.HasRows) { da.FillFromReader(ResultTable, searchResult); } }
public DataTable LoadNonApprovedBorns(int _currentOfficeID) { try { SqlDataReader searchResult = null; ListDictionary parm = new ListDictionary(); parm.Add("@org", _currentOfficeID); searchResult = LoadFromSqlReader("gui_GetNotApprovedBorns", parm) as SqlDataReader; DataTable ResultTable = new DataTable(); newAdapter da = new newAdapter(); if (searchResult != null && searchResult.HasRows) { da.FillFromReader(ResultTable, searchResult); } return ResultTable; } catch { return new DataTable(); } }
public DataTable ListBornMailFemaleLostCount(string _dateFrom, string _dateTo) { try { SqlDataReader searchResult = null; ListDictionary parm = new ListDictionary(); parm.Add("@StartDate", DateTime.Parse(_dateFrom).ToString("MM/yyyy/dd")); parm.Add("@EndDate", DateTime.Parse(_dateTo).ToString("MM/yyyy/dd")); searchResult = LoadFromSqlReader("Rpt_ListBornMailFemaleLostCount", parm) as SqlDataReader; DataTable ResultTable = new DataTable(); newAdapter da = new newAdapter(); if (searchResult != null && searchResult.HasRows) { da.FillFromReader(ResultTable, searchResult); } return ResultTable; } catch { return new DataTable(); } }
public bool IsBornCaseExist(string _fatherNid, string _motherNid, string _bornName, string _birthDate, string _chkDate) { try { SqlDataReader searchResult = null; ListDictionary parm = new ListDictionary(); parm.Add("@FatherNid", _fatherNid); parm.Add("@MotherNid", _motherNid); parm.Add("@BornName", _bornName); parm.Add("@BornBirthDate", _birthDate); parm.Add("@checkDate", _chkDate); searchResult = LoadFromSqlReader("CheckBornCaseExist", parm) as SqlDataReader; DataTable ResultTable = new DataTable(); newAdapter da = new newAdapter(); if (searchResult != null && searchResult.HasRows) { da.FillFromReader(ResultTable, searchResult); } return ResultTable.Rows.Count > 0; } catch { return false; } }
public bool IsDeathCaseExist(string _nid,string _fname,string _sname,string _grandName,string _familyName,string _chkDate) { try { SqlDataReader searchResult = null; ListDictionary parm = new ListDictionary(); parm.Add("@Nid", _nid); parm.Add("@fName", _fname); parm.Add("@Sname", _sname); parm.Add("@GrandName", _grandName); parm.Add("@FamilyName", _familyName); parm.Add("@checkDate", _chkDate); searchResult = LoadFromSqlReader("CheckDeathCaseExist", parm) as SqlDataReader; DataTable ResultTable = new DataTable(); newAdapter da = new newAdapter(); if (searchResult != null && searchResult.HasRows) { da.FillFromReader(ResultTable, searchResult); } return ResultTable.Rows.Count > 0; } catch { return false; } }
public DataTable GetAllNews(int? _newsID,bool? _showLive,int? _govID, int? _civilID, int? _hoID) { try { SqlDataReader searchResult = null; ListDictionary parm = new ListDictionary(); if (_newsID != null) parm.Add("@newsID", _newsID.Value); if (_showLive != null) parm.Add("@showLive", _showLive.Value); if (_govID != null) parm.Add("@govid", _govID.Value); if (_civilID != null) parm.Add("@civilid", _civilID.Value); if (_hoID != null) parm.Add("@healthofficeid", _hoID.Value); searchResult = LoadFromSqlReader("GUI_GetAllNews", parm) as SqlDataReader; DataTable ResultTable = new DataTable(); newAdapter da = new newAdapter(); if (searchResult != null && searchResult.HasRows) { da.FillFromReader(ResultTable, searchResult); } return ResultTable; } catch { return new DataTable(); } }
public DataTable ListDeadAprrovedCountHealthOffice(string _dateFrom, string _dateTo, int GovID, int CivilID, int HealthOfficeID) { try { SqlDataReader searchResult = null; ListDictionary parm = new ListDictionary(); parm.Add("@StartDate", DateTime.Parse(_dateFrom).ToString("MM/yyyy/dd")); parm.Add("@EndDate", DateTime.Parse(_dateTo).ToString("MM/yyyy/dd")); parm.Add("@GovID", GovID); parm.Add("@CivilID", CivilID); parm.Add("@HealthOfficeID", HealthOfficeID); searchResult = LoadFromSqlReader("Rpt_ListDeadAprrovedCountHealthOffice", parm) as SqlDataReader; DataTable ResultTable = new DataTable(); newAdapter da = new newAdapter(); if (searchResult != null && searchResult.HasRows) { da.FillFromReader(ResultTable, searchResult); } return ResultTable; } catch { return new DataTable(); } }