Пример #1
0
        public int Insert(AgreementTypeEntity entity)
        {
            Parameters = new List<SqlParameter>();

            Parameters.Add(new SqlParameter("@UserID", entity.UserID));
            Parameters.Add(new SqlParameter("@Title", entity.Title));
            Parameters.Add(new SqlParameter("@AgreementTypeID", entity.AgreementTypeID));
            Parameters.Add(new SqlParameter("@AgreementType", entity.AgreementType));
            Parameters.Add(new SqlParameter("@BusinessTypeID", entity.BusinessTypeID));
            Parameters.Add(new SqlParameter("@WorkType", entity.WorkType));
            Parameters.Add(new SqlParameter("@VendorID", entity.VendorID));
            Parameters.Add(new SqlParameter("@USTaxIdentificationNo", entity.USTaxIdentificationNo));
            Parameters.Add(new SqlParameter("@UNIQUENo", entity.UNIQUENo));
            Parameters.Add(new SqlParameter("@TechnicalInformation", entity.TechnicalInformation));

            object id = null;
            if (entity.AgreementTypeID == 0)
            {
                Parameters.Add(new SqlParameter("@Action", "C"));
                id = ExecuteScalar(DBCommands.AgreementType);
            }
            else
            {
                Parameters.Add(new SqlParameter("@Action", "U"));
                ExecCommand(DBCommands.AgreementType);
                id = entity.AgreementTypeID;
            }
            return Convert.ToInt32(id);
        }
Пример #2
0
 protected void btnSerch_Click(object sender, EventArgs e)
 {
     AgreementTypeEntity entity = new AgreementTypeEntity();
     entity.AgreementType = rdoAgreementType.SelectedValue;
     entity.Title = txtTitle.Text;
     entity.BusinessTypeID = Convert.ToInt32(ddlBusinessType.SelectedIndex);
     AgreementTypeBI agreementType = new AgreementTypeBI();
     List<AgreementTypeEntity> list = agreementType.ReadSearchItem(entity);
     gvSearch.DataSource = list;
     gvSearch.DataBind();
 }
Пример #3
0
        //public void Delete(int id)
        //{
        //    Parameters = new List<SqlParameter>();
        //    Parameters.Add(new SqlParameter("@UserID", id));
        //    ExecCommand("USP_Delete_Users");
        //}
        public AgreementTypeEntity Read(int id)
        {
            Parameters = new List<SqlParameter>();

            Parameters.Add(new SqlParameter("@AgreementTypeID", id));
            AgreementTypeEntity entity = null;
            SqlDataReader reader = null;
            try
            {
                Parameters.Add(new SqlParameter("@Action", "R"));
                reader = ExecDataReader(DBCommands.AgreementType);
                if (reader.Read())
                {
                    entity = new AgreementTypeEntity();
                    if (reader["Title"] != DBNull.Value)
                        entity.Title = reader["Title"].ToStr();

                    if (reader["UserID"] != DBNull.Value)
                        entity.UserID = Convert.ToInt32(reader["UserID"]);

                    entity.UserID = reader["UserID"].ToInt32();
                    entity.AgreementType = reader["AgreementType"].ToStr();
                    entity.BusinessTypeID = reader["BusinessTypeID"].ToInt32();
                    entity.WorkType = reader["WorkType"].ToStr();

                    entity.VendorID = reader["VendorID"].ToInt32();
                    entity.USTaxIdentificationNo = reader["USTaxIdentificationNo"].ToStr();
                    entity.UNIQUENo = reader["UNIQUENo"].ToStr();
                    entity.TechnicalInformation = reader["TechnicalInformation"].ToStr();
                }
            }
            finally
            {
                if (reader != null)
                {
                    reader.Close();
                    reader.Dispose();
                }
            }

            return entity;
        }
        private int SaveData()
        {
            AgreementTypeEntity entity = new AgreementTypeEntity();
            if (SessionManager.AgreementTypeID != 0)
                entity.AgreementTypeID = SessionManager.AgreementTypeID;
            entity.UserID = SessionManager.UsersID;

            entity.AgreementType = rdoAgreementType.SelectedValue;
            if (rdoAgreementType.SelectedValue == "A")
            {
                entity.WorkType = rdoWorkType.SelectedValue;
                entity.Title = txtTitle.Text;
                entity.BusinessTypeID = Convert.ToInt32(ddlBusinessType.SelectedValue);
            }
            else
            {
                entity.VendorID = ddlRegisteredVendor.SelectedIndex;
                entity.Title = txtTitleRegistered.Text;
                entity.USTaxIdentificationNo = txtTaxIdentification.Text;
                entity.UNIQUENo = txtUNIQUE.Text;
                entity.TechnicalInformation = rdotechnical.SelectedValue;
            }
            AgreementTypeBI agreementType = new AgreementTypeBI();

            int agreementTypeID = agreementType.Insert(entity);
            return agreementTypeID;
        }
Пример #5
0
 public List<AgreementTypeEntity> ReadSearchItem(AgreementTypeEntity entity)
 {
     //logic goes here
     AgreementDao AgreementDao = new AgreementDao();
     return AgreementDao.ReadSearchItem(entity);
 }
Пример #6
0
 public int Insert(AgreementTypeEntity entity)
 {
     //logic goes here
     AgreementDao AgreementDao = new AgreementDao();
     return AgreementDao.Insert(entity);
 }
Пример #7
0
        public AgreementTypeEntity ReadTitle(int id)
        {
            Parameters = new List<SqlParameter>();

            Parameters.Add(new SqlParameter("@AgreementTypeID", id));
            AgreementTypeEntity entity = null;
            SqlDataReader reader = null;
            try
            {
                Parameters.Add(new SqlParameter("@Action", "RT"));
                reader = ExecDataReader(DBCommands.AgreementType);

                if (reader.Read())
                {
                    entity = new AgreementTypeEntity();

                    entity.Email = reader["Email"].ToStr();
                    while (reader.NextResult())
                    {
                        if (reader.Read())
                        {
                            entity.Title = reader["Title"].ToStr();
                            //entity.AgreementType = reader["AgreementType"].ToString();
                            //entity.BusinessTypeID = Convert.ToInt32(reader["BusinessTypeID"]);
                            //entity.WorkType = reader["WorkType"].ToString();
                        }
                    }
                }
            }
            finally
            {
                if (reader != null)
                {
                    reader.Close();
                    reader.Dispose();
                }
            }

            return entity;
        }
Пример #8
0
        public List<AgreementTypeEntity> ReadSearchItem(AgreementTypeEntity searchEntity)
        {
            Parameters = new List<SqlParameter>();
            Parameters.Add(new SqlParameter("@Title", searchEntity.Title));
            Parameters.Add(new SqlParameter("@AgreementType", searchEntity.AgreementType));
            Parameters.Add(new SqlParameter("@BusinessTypeID", searchEntity.BusinessTypeID));
            List<AgreementTypeEntity> list = new List<AgreementTypeEntity>();
            AgreementTypeEntity entity = null;
            SqlDataReader reader = null;
            try
            {
                reader = ExecDataReader(DBCommands.Search);
                while (reader.Read())
                {

                    entity = new AgreementTypeEntity();
                    entity.Title = reader["Title"].ToStr();
                    // entity.UserID = reader["UserID"].ToInt32();
                    entity.AgreementType = reader["AgreementType"].ToStr();
                    entity.BusinessType = reader["BusinessType"].ToStr();
                    entity.Status = reader["Status"].ToStr();
                    entity.WorkType = reader["WorkType"].ToStr();
                    list.Add(entity);
                }

            }
            finally
            {
                if (reader != null)
                {
                    reader.Close();
                    reader.Dispose();
                }
            }
            return list;
        }
Пример #9
0
        public List<AgreementTypeEntity> ReadList()
        {
            List<AgreementTypeEntity> list = new List<AgreementTypeEntity>();
            SqlDataReader reader = null;
            try
            {
                reader = ExecDataReader("USP_DDLBusinessType");
                while (reader.Read())
                {
                    AgreementTypeEntity entity = new AgreementTypeEntity();
                    entity.BusinessTypeID = Convert.ToInt32(reader["BusinessTypeID"]);
                    entity.BusinessType = reader["BusinessType"].ToStr();
                    list.Add(entity);
                }

            }
            finally
            {
                if (reader != null)
                {
                    reader.Close();
                    reader.Dispose();
                }
            }
            return list;
        }