示例#1
0
        private void bntSave_Click(object sender, EventArgs e)
        {
            try
            {
                BO.ProductCategory ObjProductCategory = new BO.ProductCategory();
                ObjProductCategory.Name        = txtCategoryName.Text;
                ObjProductCategory.Description = txtDescription.Text;

                if (bntSave.Text == "Update" && txtCategoryName.Text != "")
                {
                    ObjProductCategory.Id = ID;
                    if (_IProductCategory.Update(ObjProductCategory) > 0)
                    {
                        MessageBox.Show("Successfully Update");
                        Reset();
                    }
                }
                else if (ObjProductCategory.Name != "")
                {
                    if (_IProductCategory.Insert(ObjProductCategory) > 0)
                    {
                        MessageBox.Show("Operation Success");
                        Reset();
                    }
                    else
                    {
                        lblMessageBox.Text      = "Operation Failed";
                        lblMessageBox.ForeColor = System.Drawing.Color.Red;
                    }
                }
                else
                {
                    MsgBox msgbox = new MsgBox();
                    msgbox.Show();
                    txtCategoryName.Focus();
                    lblMessageBox.ForeColor = System.Drawing.Color.Red;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
示例#2
0
        public IList <BO.ProductCategory> GetProductCategoryList()
        {
            try
            {
                SqlConnection  con = CreateCon();
                SqlDataAdapter da  = new SqlDataAdapter();
                da.SelectCommand             = new SqlCommand();
                da.SelectCommand.CommandText = "[POS_SP_GET_SET_ProductCategory]";
                da.SelectCommand.CommandType = CommandType.StoredProcedure;
                da.SelectCommand.Connection  = con;

                if (con.State == ConnectionState.Closed)
                {
                    con.Open();
                }
                DataSet ds = new DataSet();
                da.Fill(ds);
                if (con.State == ConnectionState.Open)
                {
                    con.Close();
                }
                DataTable dt = ds.Tables[0];
                List <BO.ProductCategory> objDoctorList = new List <POS.BO.ProductCategory>();
                int index = 1;
                POS.BO.ProductCategory obj = null;
                foreach (DataRow row in dt.Rows)
                {
                    obj             = new BO.ProductCategory();
                    obj.Sln         = index++;
                    obj.Id          = Convert.ToInt32(row["ProductCategoryID"]);
                    obj.Name        = row["CategoryName"].ToString();
                    obj.Description = row["Description"].ToString();
                    objDoctorList.Add(obj);
                }
                return(objDoctorList);
            }
            catch (Exception)
            {
                throw;
            }
        }
示例#3
0
        public int Update(BO.ProductCategory objProductCategory, int Id)
        {
            try
            {
                int            returnStatus = 0;
                SqlConnection  con          = CreateCon();
                SqlDataAdapter da           = new SqlDataAdapter();
                da.SelectCommand = new SqlCommand();

                da.SelectCommand.CommandText = "[POS_SP_Update_SET_ProductCategory]";
                da.SelectCommand.CommandType = CommandType.StoredProcedure;
                da.SelectCommand.Connection  = con;
                da.SelectCommand.Parameters.Add("@CategoryName", SqlDbType.VarChar, 100).Value = objProductCategory.Name;
                da.SelectCommand.Parameters.Add("@Description", SqlDbType.VarChar, 200).Value  = objProductCategory.Description;
                if (con.State == ConnectionState.Closed)
                {
                    con.Open();
                }

                if (da.SelectCommand.ExecuteNonQuery() == 1)
                {
                    returnStatus = 1;
                }
                else
                {
                    returnStatus = 0;
                }
                if (con.State == ConnectionState.Open)
                {
                    con.Close();
                }
                return(returnStatus);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
示例#4
0
 public IList <BO.ProductCategory> GetProductCategoryByObject(BO.ProductCategory objProductCategory, int pageIndex, int pageSize, string orderBy, string sortindex)
 {
     return(_iProductCategory.GetProductCategoryByObject(objProductCategory, pageIndex, pageSize, orderBy, sortindex));
 }
示例#5
0
 public int Update(BO.ProductCategory objProductCategory, int Id)
 {
     return(_iProductCategory.Update(objProductCategory, Id));
 }
示例#6
0
 public int Insert(BO.ProductCategory objProductCategory)
 {
     return(_iProductCategory.Insert(objProductCategory));
 }
示例#7
0
 public IList <BO.ProductCategory> GetProductCategoryByObject(BO.ProductCategory objProductCategory, int pageIndex, int pageSize, string orderBy, string sortindex)
 {
     return(new List <POS.BO.ProductCategory>());
 }