Beispiel #1
0
        public string Insert_Update(SubCategory_DataModel SubCategory_DM, HttpPostedFileBase file)
        {
            string Status          = string.Empty;
            int    Sub_Category_Id = 0;
            List <KeyValuePair <string, string> > insert_Parameters = new List <KeyValuePair <string, string> >();

            insert_Parameters.Add(new KeyValuePair <string, string>("@Id", SubCategory_DM.Id));
            insert_Parameters.Add(new KeyValuePair <string, string>("@CategoryId", SubCategory_DM.CategoryId));
            insert_Parameters.Add(new KeyValuePair <string, string>("@SubCategoryName", SubCategory_DM.SubCategoryName));
            insert_Parameters.Add(new KeyValuePair <string, string>("@SubCategoryDesc", SubCategory_DM.SubCategoryDesc));
            insert_Parameters.Add(new KeyValuePair <string, string>("@IsActive", Convert.ToString(SubCategory_DM.IsActive)));
            insert_Parameters.Add(new KeyValuePair <string, string>("@CreatedBy", ""));
            insert_Parameters.Add(new KeyValuePair <string, string>("@SubCategoryCode", SubCategory_DM.SubCategoryCode));

            var result = obj_SubCategory_DAL.Insert_Update(insert_Parameters);

            //var result = CategoryMasterDAL.InsertCategory(parameters);
            if (result != "")
            {
                var statusObj = JObject.Parse(result);
                Status          = (string)statusObj["Status"];
                Sub_Category_Id = (int)statusObj["SubCategoryId"];
            }
            //if (file != null)
            if (!string.IsNullOrEmpty(file.FileName))
            {
                var ResumefileName = "";

                var Resumepath = "";

                string ResumeDirectory = "";

                string UniqueFilename = "";

                ResumeDirectory = HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["SubCategoryImage"].ToString());

                string[] ext             = ResumefileName.Split('.');
                string   extension       = Path.GetExtension(file.FileName);
                bool     directoryExists = System.IO.Directory.Exists(ResumeDirectory);

                if (!directoryExists)
                {
                    System.IO.Directory.CreateDirectory(ResumeDirectory);
                }
                ResumefileName = SubCategory_DM.SubCategoryName.Substring(0, 3) + "_Img_" + Sub_Category_Id + extension;

                Resumepath = Path.Combine(ResumeDirectory, ResumefileName);
                file.SaveAs(Resumepath);

                insert_Parameters = new List <KeyValuePair <string, string> >();
                insert_Parameters.Add(new KeyValuePair <string, string>("@SubCategoryId", Convert.ToString(Sub_Category_Id)));
                insert_Parameters.Add(new KeyValuePair <string, string>("@Filename", ResumefileName));
                obj_SubCategory_DAL.UpdateSubCategoryImage(insert_Parameters);
            }
            return(Status);
        }
 public SubCategory_ViewModel()
 {
     subCategory     = new SubCategory_DataModel();
     lst_subCategory = new List <SubCategory_DataModel>();
     drpDwn_Category = new List <CategoryMasterDataModel>();
 }