Exemplo n.º 1
0
 public DocStatementAdminBlank(SqlTransaction trans, int id, int departmentId, string userName) : base(trans, id, userName)
 {
     ControlCards = ControlCard.GetCardsExternalToDepartment(trans, DocumentID, departmentId, UserName);
 }
Exemplo n.º 2
0
        private string SetOpenWorker(int documentId, int controlCardId)
        {
            ControlCard card;

            SqlConnection connection = new SqlConnection(Config.ConnectionString);

            try
            {
                connection.Open();
                SqlTransaction trans = null;
                try
                {
                    trans = connection.BeginTransaction();

                    if (documentId > 0)
                    {
                        SqlParameter[] prms = new SqlParameter[4];
                        prms[0]           = new SqlParameter("@DocumentActionID", SqlDbType.Int);
                        prms[0].Direction = ParameterDirection.Output;

                        prms[1]       = new SqlParameter("@DocumentID", SqlDbType.Int);
                        prms[1].Value = documentId;

                        prms[2]       = new SqlParameter("@WorkerID", SqlDbType.Int);
                        prms[2].Value = Worker.ID;

                        prms[3]       = new SqlParameter("@DocumentActionTypeID", SqlDbType.Int);
                        prms[3].Value = 1;

                        SPHelper.ExecuteNonQuery("usp_DocumentAction_Insert", prms);
                    }
                    else
                    {
                        throw new CustomException.CustomException("Null documentId");
                    }


                    if (controlCardId > 0)
                    {
                        card = new ControlCard(trans, controlCardId, UserName);

                        if (card.WorkerID == Worker.ID || card.FixedWorkerID == Worker.ID)
                        {
                            ControlCard.SetOpenWorker(card.ID, Worker.ID, UserName);
                        }
                        else
                        {
                            //throw new CustomException.CustomException("Not worker card");
                        }
                    }
                    else
                    {
                        card = new ControlCard();
                    }

                    trans.Commit();
                } catch (Exception) {
                    if (trans != null)
                    {
                        trans.Rollback();
                    }
                    throw;
                }
            }
            finally
            {
                connection.Close();
            }

            return(new JavaScriptSerializer().Serialize(card));
        }
Exemplo n.º 3
0
 public DocStatementWorkerBlank(SqlTransaction trans, int id, int workerId, string userName) : base(trans, id, userName)
 {
     ControlCards = ControlCard.GetCardsExternalToWorker(trans, DocumentID, workerId, UserName);
 }
Exemplo n.º 4
0
 void setStateCardFlip()
 {
     stateCard = StateCard.FLIP;
     ControlCard.cardFlip();
 }