public static Int32 Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, STD_WKFACTIVITYTYPE objSave)
        {
            Int32 objReturn             = 0;
            STD_WKFACTIVITYTYPEDB objDB = new STD_WKFACTIVITYTYPEDB();

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

            return(objReturn);
        }
        public static STD_WKFACTIVITYTYPE GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 ID)
        {
            STD_WKFACTIVITYTYPE   objReturn = null;
            STD_WKFACTIVITYTYPEDB objDB     = new STD_WKFACTIVITYTYPEDB();

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

            return(objReturn);
        }
        public STD_WKFACTIVITYTYPE ParseReaderComplete(DataRow row)
        {
            STD_WKFACTIVITYTYPE objReturn = ParseReaderCustom(row);

            if (objReturn.STD_WKFCASETYPE_ID > 0)
            {
                STD_WKFCASETYPEDB sTD_WKFCASETYPEDB = new STD_WKFCASETYPEDB();
                objReturn.STD_WKFCASETYPE = sTD_WKFCASETYPEDB.ParseReaderCustom(row);
                objReturn.WORKSTREAM      = objReturn.STD_WKFCASETYPE.Name;
            }

            return(objReturn);
        }
コード例 #4
0
        private void LoadForm(int id)
        {
            ResetForm();

            STD_WKFACTIVITYTYPE activity = ServiceInterfaceManager.STD_WKFACTIVITYTYPE_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id);

            if (activity != null)
            {
                hideActivityId.Value = activity.ID.ToString();
                if (activity.STD_WKFCASETYPE_ID != null)
                {
                    listWorkstream.SelectedValue = activity.STD_WKFCASETYPE_ID.ToString();
                }
                txtActivityName.Text        = activity.NAME;
                txtActivityCode.Text        = activity.CODE;
                txtActivitySortOrder.Text   = activity.SORT_ORDER.ToString();
                txtActivityDescription.Text = activity.DESCRIPTION_TEXT;
                chkAutoCreated.Checked      = activity.AUTO_CREATE.GetValueOrDefault();
            }
        }
        public STD_WKFACTIVITYTYPE ParseReaderCustom(DataRow row)
        {
            STD_WKFACTIVITYTYPE objReturn = new STD_WKFACTIVITYTYPE
            {
                AUTO_CREATE      = (bool?)GetNullableObject(row.Field <object>("STD_WKFACTIVITYTYPE_AUTO_CREATE")),
                CODE             = (string)GetNullableObject(row.Field <object>("STD_WKFACTIVITYTYPE_CODE")),
                CREATED          = (DateTime)GetNullableObject(row.Field <object>("STD_WKFACTIVITYTYPE_CREATED")),
                CREATEDBY        = (string)GetNullableObject(row.Field <object>("STD_WKFACTIVITYTYPE_CREATEDBY")),
                DESCRIPTION_TEXT = (string)GetNullableObject(row.Field <object>("STD_WKFACTIVITYTYPE_DESCRIPTION_TEXT")),
                ID                 = (Int32)GetNullableObject(row.Field <object>("STD_WKFACTIVITYTYPE_ID")),
                INACTIVE_DATE      = (DateTime?)GetNullableObject(row.Field <object>("STD_WKFACTIVITYTYPE_INACTIVE_DATE")),
                INACTIVE_FLAG      = (bool)GetNullableObject(row.Field <object>("STD_WKFACTIVITYTYPE_INACTIVE_FLAG")),
                NAME               = (string)GetNullableObject(row.Field <object>("STD_WKFACTIVITYTYPE_NAME")),
                SORT_ORDER         = (Int32)GetNullableObject(row.Field <object>("STD_WKFACTIVITYTYPE_SORT_ORDER")),
                STD_REGISTRY_ID    = (Int32?)GetNullableObject(row.Field <object>("STD_WKFACTIVITYTYPE_STD_REGISTRY_ID")),
                STD_WKFCASETYPE_ID = (Int32?)GetNullableObject(row.Field <object>("STD_WKFACTIVITYTYPE_STD_WKFCASETYPE_ID")),
                UPDATED            = (DateTime)GetNullableObject(row.Field <object>("STD_WKFACTIVITYTYPE_UPDATED")),
                UPDATEDBY          = (string)GetNullableObject(row.Field <object>("STD_WKFACTIVITYTYPE_UPDATEDBY"))
            };

            return(objReturn);
        }
コード例 #6
0
        private bool SaveForm(ref string strResult)
        {
            STD_WKFACTIVITYTYPE activity = null;

            if (string.IsNullOrEmpty(txtActivityName.Text))
            {
                strResult = "Activity Name is Required<br /><br />";
            }
            else if (string.IsNullOrEmpty(txtActivityCode.Text))
            {
                strResult = "Activity Code is Required<br /><br />";
            }
            else if (string.IsNullOrEmpty(txtActivitySortOrder.Text))
            {
                strResult = "Sort Order is Required<br /><br />";
            }
            else if (string.IsNullOrEmpty(txtActivityDescription.Text))
            {
                strResult = "Description is Required<br /><br />";
            }
            else
            {
                int id = 0;
                if (!string.IsNullOrEmpty(hideActivityId.Value))
                {
                    int.TryParse(hideActivityId.Value, out id);
                }
                if (id > 0)
                {
                    activity = ServiceInterfaceManager.STD_WKFACTIVITYTYPE_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id);
                }
                if (activity == null)
                {
                    activity = new STD_WKFACTIVITYTYPE();
                }

                activity.STD_REGISTRY_ID = UserSession.CurrentRegistryId;
                activity.CREATEDBY       = activity.UPDATEDBY = HttpContext.Current.User.Identity.Name;

                int wf = 0;
                int.TryParse(listWorkstream.SelectedValue, out wf);

                activity.STD_WKFCASETYPE_ID = wf;
                activity.NAME = txtActivityName.Text;
                activity.CODE = txtActivityCode.Text;

                int order = 0;
                int.TryParse(txtActivitySortOrder.Text, out order);

                activity.SORT_ORDER       = order;
                activity.DESCRIPTION_TEXT = txtActivityDescription.Text;
                activity.AUTO_CREATE      = chkAutoCreated.Checked;

                activity.ID = ServiceInterfaceManager.STD_WKFACTIVITYTYPE_SAVE(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, activity);
                if (activity.ID > 0)
                {
                    hideActivityId.Value = activity.ID.ToString();
                    strResult            = "Save successful<br /><br />";
                    return(true);
                }
                else
                {
                    strResult = "Error saving Activity, please try again<br /><br />";
                }
                //}
                // else
                // {
                //    strResult = "<ul><li>Activity Name is Required</li></ul>";
                // }
            }
            return(false);
        }
 public static Boolean Delete(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, STD_WKFACTIVITYTYPE objDelete)
 {
     return(Delete(CURRENT_USER, CURRENT_REGISTRY_ID, objDelete.ID));
 }
        public STD_WKFACTIVITYTYPE GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 ID)
        {
            STD_WKFACTIVITYTYPE 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_WKFACTIVITYTYPE_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);
        }
        public Int32 Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, STD_WKFACTIVITYTYPE objSave)
        {
            Int32 objReturn = 0;

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

            try
            {
                sConn = new SqlConnection(SqlConnectionString);

                sConn.Open();

                sCmd = new SqlCommand("CRS.usp_STD_WKFACTIVITYTYPE_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("@AUTO_CREATE", SqlDbType.Bit, 1);
                p.Precision = 1;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.AUTO_CREATE);
                p           = new SqlParameter("@CODE", SqlDbType.VarChar, 50);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.CODE);
                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, 30);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.CREATEDBY);
                p           = new SqlParameter("@DESCRIPTION_TEXT", SqlDbType.VarChar, 500);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.DESCRIPTION_TEXT);
                p           = new SqlParameter("@ID", SqlDbType.Int, 4);
                p.Direction = ParameterDirection.InputOutput;
                p.Precision = 10;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.ID);
                p           = new SqlParameter("@INACTIVE_DATE", SqlDbType.DateTime, 8);
                p.Precision = 23;
                p.Scale     = 3;
                AddParameter(ref sCmd, ref p, objSave.INACTIVE_DATE);
                p           = new SqlParameter("@INACTIVE_FLAG", SqlDbType.Bit, 1);
                p.Precision = 1;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.INACTIVE_FLAG);
                p           = new SqlParameter("@NAME", SqlDbType.VarChar, 100);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.NAME);
                p           = new SqlParameter("@SORT_ORDER", SqlDbType.Int, 4);
                p.Precision = 10;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.SORT_ORDER);
                p           = new SqlParameter("@STD_REGISTRY_ID", SqlDbType.Int, 4);
                p.Precision = 10;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.STD_REGISTRY_ID);
                p           = new SqlParameter("@STD_WKFCASETYPE_ID", SqlDbType.Int, 4);
                p.Precision = 10;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.STD_WKFCASETYPE_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, 30);
                p.Precision = 0;
                p.Scale     = 0;
                AddParameter(ref sCmd, ref p, objSave.UPDATEDBY);

                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);
                //int cnt = sCmd.ExecuteNonQuery();
                sAdapter.Fill(objTemp);
                LogManager.LogTiming(logDetails);
                CheckDataSet(objTemp);

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