Beispiel #1
0
        //Convert DataTable To List method
        public List <BusinessCategoryClass> ConvertToList(DataTable dt)
        {
            List <BusinessCategoryClass> BusinessCategorylist = new List <BusinessCategoryClass>();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                BusinessCategoryClass obj_BusinessCategory = new BusinessCategoryClass();

                if (Convert.ToString(dt.Rows[i]["Businesscategoryid"]) != "")
                {
                    obj_BusinessCategory.Businesscategoryid = Convert.ToInt32(dt.Rows[i]["Businesscategoryid"]);
                }

                if (Convert.ToString(dt.Rows[i]["Businessid"]) != "")
                {
                    obj_BusinessCategory.Businessid = Convert.ToInt32(dt.Rows[i]["Businessid"]);
                }

                if (Convert.ToString(dt.Rows[i]["Categoryid"]) != "")
                {
                    obj_BusinessCategory.Categoryid = Convert.ToInt32(dt.Rows[i]["Categoryid"]);
                }


                BusinessCategorylist.Add(obj_BusinessCategory);
            }
            return(BusinessCategorylist);
        }
Beispiel #2
0
        //Select Constructor
        public BusinessCategoryCtl(Int32?id)
        {
            obj_con = new ConnectionCls();
            BusinessCategoryClass obj_Bus = new BusinessCategoryClass();

            using (DataTable dt = selectdatatable(id))
            {
                if (dt.Rows.Count > 0)
                {
                    obj_Bus.Businesscategoryid = Convert.ToInt32(dt.Rows[0]["Businesscategoryid"]);
                    obj_Bus.Businessid         = Convert.ToInt32(dt.Rows[0]["Businessid"]);
                    obj_Bus.Categoryid         = Convert.ToInt32(dt.Rows[0]["Categoryid"]);
                }
            }
        }
Beispiel #3
0
 //insert data into database
 public Int32?insert(BusinessCategoryClass obj)
 {
     try
     {
         obj_con.clearParameter();
         createParameter(obj, DBTrans.Insert);
         obj_con.BeginTransaction();
         obj_con.ExecuteNoneQuery("sp_BusinessCategory_insert", CommandType.StoredProcedure);
         obj_con.CommitTransaction();
         return(obj.Businesscategoryid = Convert.ToInt32(obj_con.getValue("@Businesscategoryid")));
     }
     catch (Exception ex)
     {
         obj_con.RollbackTransaction();
         throw new Exception("sp_BusinessCategory_insert:" + ex.Message);
     }
 }
Beispiel #4
0
        //update edited object
        public BusinessCategoryClass updateObject(BusinessCategoryClass obj)
        {
            try
            {
                BusinessCategoryClass oldObj = selectById(obj.Businesscategoryid);
                if (obj.Businessid == null)
                {
                    obj.Businessid = oldObj.Businessid;
                }

                if (obj.Categoryid == null)
                {
                    obj.Categoryid = oldObj.Categoryid;
                }

                return(obj);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
Beispiel #5
0
        //create parameter
        public void createParameter(BusinessCategoryClass obj, DB_con.DBTrans trans)
        {
            try
            {
                obj_con.clearParameter();

                if (Convert.ToString(obj.Businessid) != "")
                {
                    obj_con.addParameter("@Businessid", string.IsNullOrEmpty(Convert.ToString(obj.Businessid)) ? 0 : obj.Businessid);
                }
                else
                {
                    obj_con.addParameter("@Businessid", DBNull.Value);
                }

                if (Convert.ToString(obj.Categoryid) != "")
                {
                    obj_con.addParameter("@Categoryid", string.IsNullOrEmpty(Convert.ToString(obj.Categoryid)) ? 0 : obj.Categoryid);
                }
                else
                {
                    obj_con.addParameter("@Categoryid", DBNull.Value);
                }

                if (Convert.ToString(obj.Businesscategoryid) != "")
                {
                    obj_con.addParameter("@Businesscategoryid", Convert.ToInt32(obj.Businesscategoryid), trans);
                }
                else
                {
                    obj_con.addParameter("@Businesscategoryid", DBNull.Value);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #6
0
        //Convert DataTable To object method
        public BusinessCategoryClass ConvertToOjbect(DataTable dt)
        {
            BusinessCategoryClass obj_BusinessCategory = new BusinessCategoryClass();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (Convert.ToString(dt.Rows[i]["Businesscategoryid"]) != "")
                {
                    obj_BusinessCategory.Businesscategoryid = Convert.ToInt32(dt.Rows[i]["Businesscategoryid"]);
                }

                if (Convert.ToString(dt.Rows[i]["Businessid"]) != "")
                {
                    obj_BusinessCategory.Businessid = Convert.ToInt32(dt.Rows[i]["Businessid"]);
                }

                if (Convert.ToString(dt.Rows[i]["Categoryid"]) != "")
                {
                    obj_BusinessCategory.Categoryid = Convert.ToInt32(dt.Rows[i]["Categoryid"]);
                }
            }
            return(obj_BusinessCategory);
        }