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