예제 #1
0
        //update SuperCategory
        public int UpdateSuper(Master_SuperCategory a)
        {
            int i;

            using (SqlConnection con = new SqlConnection(cs))
            {
                con.Open();
                string     q   = "update Master_SuperCategory set SuperCategoryName=@SuperCategoryName, SuperCategoryDescription=@SuperCategoryDescription where SuperCategoryID=@SuperCategoryID";
                SqlCommand com = new SqlCommand(q, con);
                com.Parameters.AddWithValue("@SuperCategoryID", a.SuperCategoryID);
                com.Parameters.AddWithValue("@SuperCategoryName", a.SuperCategoryName);
                com.Parameters.AddWithValue("@SuperCategoryDescription", a.SuperCategoryDescription);

                i = com.ExecuteNonQuery();
            }
            return(i);
        }
        public JsonResult AddSuper(Master_SuperCategory sc)
        {
            HttpPostedFileBase file = Request.Files[0]; //Uploaded file
            int    fileSize         = file.ContentLength;
            string fileName         = file.FileName;
            string filePath         = "/SuperImages/" + fileName;

            file.SaveAs(Server.MapPath(filePath));
            string mimeType = file.ContentType;

            System.IO.Stream fileContent = file.InputStream;
            //To save file, use SaveAs method
            //fname = Path.Combine(Server.MapPath("~/SuperImages/" + fileName));
            //file.SaveAs(fname); //File will be saved in application root
            //sc.SuperCategoryIcon = fname;
            sc.SuperCategoryIcon = filePath;
            return(Json(db.AddSuperC(sc), JsonRequestBehavior.AllowGet));
        }
예제 #3
0
        //Add SuperCategory
        public int AddSuperC(Master_SuperCategory sc)
        {
            int i;

            using (SqlConnection con = new SqlConnection(cs))
            {
                con.Open();
                string q = "insert into Master_SuperCategory(SuperCategoryName,SuperCategoryDescription,SuperCategoryIcon) values(@SuperCategoryName,@SuperCategoryDescription,@SuperCategoryIcon)";

                SqlCommand com = new SqlCommand(q, con);
                // com.Parameters.AddWithValue("@SuperCategoryID", sc.SuperCategoryID);

                com.Parameters.AddWithValue("@SuperCategoryName", sc.SuperCategoryName);
                com.Parameters.AddWithValue("@SuperCategoryDescription", sc.SuperCategoryDescription);
                com.Parameters.AddWithValue("@SuperCategoryIcon", sc.SuperCategoryIcon);
                i = com.ExecuteNonQuery();



                //try
                //{
                //    if (SuperCategoryIcon != null && SuperCategoryIcon.ContentLength > 0)
                //    {
                //        string filename = Path.GetFileName(SuperCategoryIcon.FileName);
                //        //string fileExtension = Path.GetExtension(filename);
                //        string imgpath = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/SuperImages/"), filename);
                //        SuperCategoryIcon.SaveAs(imgpath);
                //    }
                //    com.Parameters.AddWithValue("@SuperCategoryIcon", "~/SuperImages/" + SuperCategoryIcon.FileName);
                //}

                //catch (Exception ex)
                //{

                //    return 0;



                //}

                return(i);
            }
        }
 public JsonResult update(Master_SuperCategory sc)
 {
     return(Json(db.UpdateSuper(sc), JsonRequestBehavior.AllowGet));
 }