Esempio n. 1
0
        public int createCategory(string Cname, string Cdesc, int Createdby)
        {
            CategoryModelCSD m = new CategoryModelCSD();

            m.CategoryName        = Cname;
            m.CategoryDescription = Cdesc;
            m.CreatedBy           = Createdby;

            ProjectManagerCSD mng = new ProjectManagerCSD();

            return(mng.createCategory(m));
        }
Esempio n. 2
0
        public int updateCategory(int cid, string Cname, string Cdesc, int mby)
        {
            CategoryModelCSD m = new CategoryModelCSD();

            m.CategoryId          = cid;
            m.CategoryName        = Cname;
            m.CategoryDescription = Cdesc;
            m.LastModifiedBy      = mby;

            ProjectManagerCSD mng = new ProjectManagerCSD();

            return(mng.updateCategory(m));
        }
Esempio n. 3
0
        /// <summary>
        /// Create Category by adding name and description.
        /// </summary>
        /// <param name="mod"></param>
        /// <returns></returns>
        public int createCategory(CategoryModelCSD mod)
        {
            SqlParameter[] param = new SqlParameter[3];
            param[0]       = new SqlParameter("@categoryName", SqlDbType.VarChar);
            param[0].Value = mod.CategoryName;

            param[1]       = new SqlParameter("@categoryDesc", SqlDbType.VarChar);
            param[1].Value = mod.CategoryDescription;

            param[2]       = new SqlParameter("@createdBy", SqlDbType.Int);
            param[2].Value = mod.CreatedBy;

            int i = SqlHelper.ExecuteNonQuery("Data Source=.;Initial Catalog=HRS;Integrated Security=True", CommandType.StoredProcedure, "spCreateCategory", param);

            return(i);
        }
Esempio n. 4
0
 public int updateCategory(CategoryModelCSD mod)
 {
     return(new CategoryBCCSD().updateCategory(mod));
 }
Esempio n. 5
0
 //Category
 public int createCategory(CategoryModelCSD mod)
 {
     return(new CategoryBCCSD().createCategory(mod));
 }
Esempio n. 6
0
 public int updateCategory(CategoryModelCSD mod) 
 {
     return new CategoryDAOCSD().updateCategory(mod);
 }
Esempio n. 7
0
 public int createCategory(CategoryModelCSD mod)
 {
     return new CategoryDAOCSD().createCategory(mod);
 
 }