Example #1
0
        public int Delete(TC_OA_DocumentModel ObjModel)
        {
            int num = 0;

            using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
            {
                connection.Open();
                SqlTransaction transaction = connection.BeginTransaction();
                try
                {
                    try
                    {
                        num = new TC_OA_DocumentBLL().Delete(ObjModel.Code, transaction);
                        transaction.Commit();
                    }
                    catch (SqlException exception)
                    {
                        transaction.Rollback();
                        connection.Close();
                        throw exception;
                    }
                    return(num);
                }
                finally
                {
                    connection.Close();
                }
            }
            return(num);
        }
Example #2
0
        public int ModifyPassAuditing(int Code, SqlTransaction Transaction)
        {
            TC_OA_DocumentModel objModel = this.GetModel(Code, Transaction);

            objModel.Auditing = 3;
            return(this.Update(objModel, Transaction));
        }
Example #3
0
        public TC_OA_DocumentModel GetTC_OA_Document(int Code)
        {
            TC_OA_DocumentModel model = new TC_OA_DocumentModel();

            using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
            {
                try
                {
                    model = new TC_OA_DocumentBLL().GetModel(Code, connection);
                    connection.Close();
                }
                catch (SqlException exception)
                {
                    throw exception;
                }
            }
            return(model);
        }
Example #4
0
 public int Update(TC_OA_DocumentModel ObjModel, SqlTransaction Transaction)
 {
     TC_OA_DocumentDAL tdal = new TC_OA_DocumentDAL(Transaction);
     return tdal.Update(ObjModel);
 }
Example #5
0
 public int ModifyAlreadyAuditing(int Code, SqlTransaction Transaction)
 {
     TC_OA_DocumentModel objModel = this.GetModel(Code, Transaction);
     objModel.Auditing = 2;
     return this.Update(objModel, Transaction);
 }
Example #6
0
 public int Insert(TC_OA_DocumentModel ObjModel, SqlTransaction Transaction)
 {
     TC_OA_DocumentDAL tdal = new TC_OA_DocumentDAL(Transaction);
     return tdal.Insert(ObjModel);
 }