Example #1
0
        public static Int32 Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, STD_INSTITUTION objSave)
        {
            Int32             objReturn = 0;
            STD_INSTITUTIONDB objDB     = new STD_INSTITUTIONDB();

            objReturn = objDB.Save(CURRENT_USER, CURRENT_REGISTRY_ID, objSave);

            return(objReturn);
        }
Example #2
0
        public static STD_INSTITUTION GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 ID)
        {
            STD_INSTITUTION   objReturn = null;
            STD_INSTITUTIONDB objDB     = new STD_INSTITUTIONDB();

            objReturn = objDB.GetItem(CURRENT_USER, CURRENT_REGISTRY_ID, ID);

            return(objReturn);
        }
Example #3
0
        private string GenerateAddressBlock(STD_INSTITUTION fac)
        {
            string addressBlock = string.Empty;

            string address1 = fac.STREETADDRESSLINE1;
            string address2 = fac.STREETADDRESSLINE2;
            string address3 = fac.STREETADDRESSLINE3;
            string cityStr  = fac.STREETCITY;

            string stateStr = "N/A";

            if (fac.STREETSTATE != null)
            {
                stateStr = fac.STREETSTATE.NAME;
            }

            string zipString = fac.STREETPOSTALCODE;

            StringBuilder sb = new StringBuilder();

            if (!String.IsNullOrEmpty(address1))
            {
                sb.Append(address1);
            }

            if (!String.IsNullOrEmpty(address2))
            {
                if (!String.IsNullOrEmpty(sb.ToString()))
                {
                    sb.Append("<br />");
                }

                sb.Append(address2);
            }

            if (!String.IsNullOrEmpty(address3))
            {
                if (!String.IsNullOrEmpty(sb.ToString()))
                {
                    sb.Append("<br />");
                }

                sb.Append(address3);
            }

            if (!String.IsNullOrEmpty(sb.ToString()))
            {
                sb.Append("<br />");
            }

            sb.Append(cityStr + ", " + stateStr + " " + zipString);

            addressBlock = sb.ToString();

            return(addressBlock);
        }
        public STD_INSTITUTION ParseFacs(DataRow row)
        {
            STD_INSTITUTION objReturn = new STD_INSTITUTION
            {
                FACID    = (Int32)GetNullableObject(row.Field <object>("FACID")),
                FACTEXT  = (string)GetNullableObject(row.Field <object>("FACTEXT")),
                STA3N    = (string)GetNullableObject(row.Field <object>("STA3N")),
                VISNSID  = (Int32)GetNullableObject(row.Field <object>("VISNID")),
                VISNTEXT = (string)GetNullableObject(row.Field <object>("VISNTEXT"))
            };

            return(objReturn);
        }
Example #5
0
        public STD_INSTITUTION ParseReaderCustom(DataRow row)
        {
            STD_INSTITUTION objReturn = new STD_INSTITUTION
            {
                ACTIVATIONDATE   = (DateTime?)GetNullableObject(row.Field <object>("STD_INSTITUTION_ACTIVATIONDATE")),
                AGENCY_ID        = (Int32?)GetNullableObject(row.Field <object>("STD_INSTITUTION_AGENCY_ID")),
                CREATED          = (DateTime?)GetNullableObject(row.Field <object>("STD_INSTITUTION_CREATED")),
                CREATEDBY        = (string)GetNullableObject(row.Field <object>("STD_INSTITUTION_CREATEDBY")),
                DEACTIVATIONDATE = (DateTime?)GetNullableObject(row.Field <object>("STD_INSTITUTION_DEACTIVATIONDATE")),
                ID                  = (Int32)GetNullableObject(row.Field <object>("STD_INSTITUTION_ID")),
                IS_ACTIVE           = (string)GetNullableObject(row.Field <object>("STD_INSTITUTION_IS_ACTIVE")),
                MAILINGADDRESSLINE1 = (string)GetNullableObject(row.Field <object>("STD_INSTITUTION_MAILINGADDRESSLINE1")),
                MAILINGADDRESSLINE2 = (string)GetNullableObject(row.Field <object>("STD_INSTITUTION_MAILINGADDRESSLINE2")),
                MAILINGADDRESSLINE3 = (string)GetNullableObject(row.Field <object>("STD_INSTITUTION_MAILINGADDRESSLINE3")),
                MAILINGCITY         = (string)GetNullableObject(row.Field <object>("STD_INSTITUTION_MAILINGCITY")),
                MAILINGCOUNTRY_ID   = (Int32?)GetNullableObject(row.Field <object>("STD_INSTITUTION_MAILINGCOUNTRY_ID")),
                MAILINGCOUNTY_ID    = (Int32?)GetNullableObject(row.Field <object>("STD_INSTITUTION_MAILINGCOUNTY_ID")),
                MAILINGPOSTALCODE   = (string)GetNullableObject(row.Field <object>("STD_INSTITUTION_MAILINGPOSTALCODE")),
                MAILINGSTATE_ID     = (Int32?)GetNullableObject(row.Field <object>("STD_INSTITUTION_MAILINGSTATE_ID")),
                MFN_ZEG_RECIPIENT   = (string)GetNullableObject(row.Field <object>("STD_INSTITUTION_MFN_ZEG_RECIPIENT")),
                NAME                = (string)GetNullableObject(row.Field <object>("STD_INSTITUTION_NAME")),
                PARENT_ID           = (Int32?)GetNullableObject(row.Field <object>("STD_INSTITUTION_PARENT_ID")),
                REALIGNEDFROM_ID    = (Int32?)GetNullableObject(row.Field <object>("STD_INSTITUTION_REALIGNEDFROM_ID")),
                REALIGNEDTO_ID      = (Int32?)GetNullableObject(row.Field <object>("STD_INSTITUTION_REALIGNEDTO_ID")),
                STATIONNUMBER       = (string)GetNullableObject(row.Field <object>("STD_INSTITUTION_STATIONNUMBER")),
                STD_FACILITYTYPE_ID = (Int32)GetNullableObject(row.Field <object>("STD_INSTITUTION_STD_FACILITYTYPE_ID")),
                STREETADDRESSLINE1  = (string)GetNullableObject(row.Field <object>("STD_INSTITUTION_STREETADDRESSLINE1")),
                STREETADDRESSLINE2  = (string)GetNullableObject(row.Field <object>("STD_INSTITUTION_STREETADDRESSLINE2")),
                STREETADDRESSLINE3  = (string)GetNullableObject(row.Field <object>("STD_INSTITUTION_STREETADDRESSLINE3")),
                STREETCITY          = (string)GetNullableObject(row.Field <object>("STD_INSTITUTION_STREETCITY")),
                STREETCOUNTRY_ID    = (Int32?)GetNullableObject(row.Field <object>("STD_INSTITUTION_STREETCOUNTRY_ID")),
                STREETCOUNTY_ID     = (Int32?)GetNullableObject(row.Field <object>("STD_INSTITUTION_STREETCOUNTY_ID")),
                STREETPOSTALCODE    = (string)GetNullableObject(row.Field <object>("STD_INSTITUTION_STREETPOSTALCODE")),
                STREETSTATE_ID      = (Int32?)GetNullableObject(row.Field <object>("STD_INSTITUTION_STREETSTATE_ID")),
                UPDATED             = (DateTime?)GetNullableObject(row.Field <object>("STD_INSTITUTION_UPDATED")),
                UPDATEDBY           = (string)GetNullableObject(row.Field <object>("STD_INSTITUTION_UPDATEDBY")),
                VISN_ID             = (Int32?)GetNullableObject(row.Field <object>("STD_INSTITUTION_VISN_ID")),
                VISTANAME           = (string)GetNullableObject(row.Field <object>("STD_INSTITUTION_VISTANAME"))
            };

            return(objReturn);
        }
Example #6
0
        protected void ListFacilities_SelectedIndexChanged(object sender, EventArgs e)
        {
            ServiceInterfaceManager.LogInformation("POSTBACK_EVENT", String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId);

            try
            {
                int id = 0;
                int.TryParse(listFacilities.SelectedValue, out id);

                if (id > 0)
                {
                    STD_INSTITUTION fac = ServiceInterfaceManager.STD_INSTITUTION_GET_COMPLETE(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id);
                    if (fac != null)
                    {
                        lblFacilityName.Text = fac.NAME;
                        lblFacilityCode.Text = fac.STATIONNUMBER;
                        lblVistaName.Text    = fac.VISTANAME;
                        lblVisn.Text         = fac.VISN.NAME;
                        lblAddress.Text      = GenerateAddressBlock(fac);
                        lblFacilityType.Text = fac.STD_FACILITYTYPE.NAME;

                        pnlFacility.Visible = true;
                    }
                    else
                    {
                        pnlFacility.Visible = false;
                    }
                }
                else
                {
                    pnlFacility.Visible = false;
                }
            }
            catch (Exception ex)
            {
                ServiceInterfaceManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId);
                throw ex;
            }
        }
Example #7
0
        public STD_INSTITUTION GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 ID)
        {
            STD_INSTITUTION objReturn = null;

            SqlConnection  sConn    = null;
            SqlCommand     sCmd     = null;
            SqlDataAdapter sAdapter = null;
            DataSet        objTemp  = null;

            try
            {
                sConn = new SqlConnection(SqlConnectionString);

                sConn.Open();

                sCmd = new SqlCommand("CRS.usp_STD_INSTITUTION_getitem", sConn);
                sCmd.CommandTimeout = SqlCommandTimeout;
                sCmd.CommandType    = CommandType.StoredProcedure;
                sCmd.Parameters.AddWithValue("@CURRENT_USER", CURRENT_USER);
                sCmd.Parameters.AddWithValue("@CURRENT_REGISTRY_ID", CURRENT_REGISTRY_ID);
                sCmd.Parameters.AddWithValue("@ID", ID);

                objTemp  = new DataSet();
                sAdapter = new SqlDataAdapter(sCmd);

                LogDetails logDetails = new LogDetails(String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
                sAdapter.Fill(objTemp);
                LogManager.LogTiming(logDetails);
                CheckDataSet(objTemp);

                if (objTemp != null && objTemp.Tables.Count > 0 && objTemp.Tables[0].Rows.Count > 0)
                {
                    objReturn = ParseReader(objTemp.Tables[0].Rows[0]);
                }

                sConn.Close();
            }
            catch (Exception ex)
            {
                LogManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
                throw ex;
            }
            finally
            {
                if (sAdapter != null)
                {
                    sAdapter.Dispose();
                    sAdapter = null;
                }
                if (sCmd != null)
                {
                    sCmd.Dispose();
                    sCmd = null;
                }
                if (sConn != null)
                {
                    if (sConn.State != ConnectionState.Closed)
                    {
                        sConn.Close();
                    }
                    sConn.Dispose();
                    sConn = null;
                }
            }

            return(objReturn);
        }
Example #8
0
        public Int32 Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, STD_INSTITUTION objSave)
        {
            Int32 objReturn = 0;

            SqlConnection sConn = null;
            SqlCommand    sCmd  = null;
            SqlParameter  p     = null;

            try
            {
                sConn = new SqlConnection(SqlConnectionString);

                sConn.Open();

                sCmd = new SqlCommand("CRS.usp_STD_INSTITUTION_save", sConn);
                sCmd.CommandTimeout = SqlCommandTimeout;
                sCmd.CommandType    = CommandType.StoredProcedure;
                sCmd.Parameters.AddWithValue("@CURRENT_USER", CURRENT_USER);
                sCmd.Parameters.AddWithValue("@CURRENT_REGISTRY_ID", CURRENT_REGISTRY_ID);

                p           = new SqlParameter("@ACTIVATIONDATE", SqlDbType.DateTime, 8);
                p.Precision = 23;
                p.Scale     = 3;
                AddParameter(ref sCmd, ref p, objSave.ACTIVATIONDATE);
                p           = new SqlParameter("@AGENCY_ID", SqlDbType.Int, 4);
                p.Precision = 10;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.AGENCY_ID);
                p           = new SqlParameter("@CREATED", SqlDbType.DateTime, 8);
                p.Precision = 23;
                p.Scale     = 3;
                AddParameter(ref sCmd, ref p, objSave.CREATED);
                p           = new SqlParameter("@CREATEDBY", SqlDbType.VarChar, 50);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.CREATEDBY);
                p           = new SqlParameter("@DEACTIVATIONDATE", SqlDbType.DateTime, 8);
                p.Precision = 23;
                p.Scale     = 3;
                AddParameter(ref sCmd, ref p, objSave.DEACTIVATIONDATE);
                p           = new SqlParameter("@ID", SqlDbType.Int, 4);
                p.Precision = 10;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.ID);
                p           = new SqlParameter("@IS_ACTIVE", SqlDbType.VarChar, 1);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.IS_ACTIVE);
                p           = new SqlParameter("@MAILINGADDRESSLINE1", SqlDbType.VarChar, 100);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.MAILINGADDRESSLINE1);
                p           = new SqlParameter("@MAILINGADDRESSLINE2", SqlDbType.VarChar, 100);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.MAILINGADDRESSLINE2);
                p           = new SqlParameter("@MAILINGADDRESSLINE3", SqlDbType.VarChar, 100);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.MAILINGADDRESSLINE3);
                p           = new SqlParameter("@MAILINGCITY", SqlDbType.VarChar, 50);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.MAILINGCITY);
                p           = new SqlParameter("@MAILINGCOUNTRY_ID", SqlDbType.Int, 4);
                p.Precision = 10;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.MAILINGCOUNTRY_ID);
                p           = new SqlParameter("@MAILINGCOUNTY_ID", SqlDbType.Int, 4);
                p.Precision = 10;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.MAILINGCOUNTY_ID);
                p           = new SqlParameter("@MAILINGPOSTALCODE", SqlDbType.VarChar, 15);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.MAILINGPOSTALCODE);
                p           = new SqlParameter("@MAILINGSTATE_ID", SqlDbType.Int, 4);
                p.Precision = 10;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.MAILINGSTATE_ID);
                p           = new SqlParameter("@MFN_ZEG_RECIPIENT", SqlDbType.VarChar, 100);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.MFN_ZEG_RECIPIENT);
                p           = new SqlParameter("@NAME", SqlDbType.VarChar, 100);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.NAME);
                p           = new SqlParameter("@PARENT_ID", SqlDbType.Int, 4);
                p.Precision = 10;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.PARENT_ID);
                p           = new SqlParameter("@REALIGNEDFROM_ID", SqlDbType.Int, 4);
                p.Precision = 10;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.REALIGNEDFROM_ID);
                p           = new SqlParameter("@REALIGNEDTO_ID", SqlDbType.Int, 4);
                p.Precision = 10;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.REALIGNEDTO_ID);
                p           = new SqlParameter("@STATIONNUMBER", SqlDbType.VarChar, 10);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.STATIONNUMBER);
                p           = new SqlParameter("@STD_FACILITYTYPE_ID", SqlDbType.Int, 4);
                p.Precision = 10;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.STD_FACILITYTYPE_ID);
                p           = new SqlParameter("@STREETADDRESSLINE1", SqlDbType.VarChar, 100);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.STREETADDRESSLINE1);
                p           = new SqlParameter("@STREETADDRESSLINE2", SqlDbType.VarChar, 100);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.STREETADDRESSLINE2);
                p           = new SqlParameter("@STREETADDRESSLINE3", SqlDbType.VarChar, 100);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.STREETADDRESSLINE3);
                p           = new SqlParameter("@STREETCITY", SqlDbType.VarChar, 50);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.STREETCITY);
                p           = new SqlParameter("@STREETCOUNTRY_ID", SqlDbType.Int, 4);
                p.Precision = 10;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.STREETCOUNTRY_ID);
                p           = new SqlParameter("@STREETCOUNTY_ID", SqlDbType.Int, 4);
                p.Precision = 10;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.STREETCOUNTY_ID);
                p           = new SqlParameter("@STREETPOSTALCODE", SqlDbType.VarChar, 50);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.STREETPOSTALCODE);
                p           = new SqlParameter("@STREETSTATE_ID", SqlDbType.Int, 4);
                p.Precision = 10;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.STREETSTATE_ID);
                p           = new SqlParameter("@UPDATED", SqlDbType.DateTime, 8);
                p.Precision = 23;
                p.Scale     = 3;
                AddParameter(ref sCmd, ref p, objSave.UPDATED);
                p           = new SqlParameter("@UPDATEDBY", SqlDbType.VarChar, 50);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.UPDATEDBY);
                p           = new SqlParameter("@VISN_ID", SqlDbType.Int, 4);
                p.Precision = 10;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.VISN_ID);
                p           = new SqlParameter("@VISTANAME", SqlDbType.VarChar, 50);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.VISTANAME);

                LogDetails logDetails = new LogDetails(String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
                int        cnt        = sCmd.ExecuteNonQuery();
                LogManager.LogTiming(logDetails);

                objReturn = (Int32)sCmd.Parameters["@ID"].Value;

                sConn.Close();
            }
            catch (Exception ex)
            {
                LogManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
                throw ex;
            }
            finally
            {
                if (sCmd != null)
                {
                    sCmd.Dispose();
                    sCmd = null;
                }
                if (sConn != null)
                {
                    if (sConn.State != ConnectionState.Closed)
                    {
                        sConn.Close();
                    }
                    sConn.Dispose();
                    sConn = null;
                }
            }

            return(objReturn);
        }
Example #9
0
 public static Boolean Delete(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, STD_INSTITUTION objDelete)
 {
     return(Delete(CURRENT_USER, CURRENT_REGISTRY_ID, objDelete.ID));
 }