public async Task <IActionResult> PostProductDescription(ProductDescriptionModel productDescriptionModel) { try { var productDescription = new ProductDescription() { Title = productDescriptionModel.ProductName, CategoryName = productDescriptionModel.ProductCategory, AuthorName = productDescriptionModel.AuthorName, AuthorDescription = productDescriptionModel.AuthorDescription, AuthorImage = productDescriptionModel.AuthorImageValue, ProductSummary = productDescriptionModel.ProductSummary, PublisherName = productDescriptionModel.PublisherName, Edition = productDescriptionModel.Edition, NumOfPages = productDescriptionModel.NumofPages, Country = productDescriptionModel.Country, Language = productDescriptionModel.Language, ProductId = productDescriptionModel.ProductId }; await _context.ProductDescriptions.AddAsync(productDescription); await _context.SaveChangesAsync(); return(Ok(productDescription)); } catch (Exception ex) { throw ex; } }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test ProductDescriptionModel inserted = new ProductDescriptionModel(); inserted.Description = TestSession.Random.RandomString(400); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new ProductDescriptionModelPrimaryKey() { ProductDescriptionID = inserted.ProductDescriptionID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.ProductDescriptionID, selectedAfterInsert.ProductDescriptionID); Assert.AreEqual(inserted.Description, selectedAfterInsert.Description); Assert.AreEqual(inserted.rowguid, selectedAfterInsert.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.Description = TestSession.Random.RandomString(400); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new ProductDescriptionModelPrimaryKey() { ProductDescriptionID = inserted.ProductDescriptionID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.ProductDescriptionID, selectedAfterUpdate.ProductDescriptionID); Assert.AreEqual(inserted.Description, selectedAfterUpdate.Description); Assert.AreEqual(inserted.rowguid, selectedAfterUpdate.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new ProductDescriptionModelPrimaryKey() { ProductDescriptionID = inserted.ProductDescriptionID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public static int InsertProductConfigBrand(SqlDbHelper dbhelper, ProductDescriptionModel brandItem, string userName) { using (var cmd = new SqlCommand("[Gungnir]..[ProductModel_AddConfigBrandInfo]")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ModuleID", brandItem.ModuleID); cmd.Parameters.AddWithValue("@CategoryName", brandItem.CategoryName); cmd.Parameters.AddWithValue("@Brand", brandItem.Brand); cmd.Parameters.AddWithValue("@CreatedUser", userName); return(dbhelper.ExecuteNonQuery(cmd)); } }
public ActionResult ProductDescriptionIndex() { var model = new ProductDescriptionModel { Id = GetParams <int>("id"), ProductId = GetParams <int>("productid"), Description = GetParams <string>("description"), Status = GetParams <int>("status"), Createtime = GetParams <DateTime>("createtime"), Updatetime = GetParams <DateTime>("updatetime"), }; return(View(model)); }
public static int InsertProductConfigPID(SqlDbHelper dbhelper, ProductDescriptionModel pidItem, ProductDescriptionModel productModuleModel, string userName) { using (var cmd = new SqlCommand("[Gungnir]..[ProductModel_AddConfigPIDInfo]")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ModuleID", pidItem.ModuleID); cmd.Parameters.AddWithValue("@PID", pidItem.PID); cmd.Parameters.AddWithValue("@AddOrDel", productModuleModel.AddOrDel); cmd.Parameters.AddWithValue("@CreatedUser", userName); return(dbhelper.ExecuteNonQuery(cmd)); } }
public static ProductDescriptionPO ToPO(this ProductDescriptionModel item) { if (item == null) { return(null); } return(new ProductDescriptionPO { Id = item.Id, ProductId = item.ProductId, Description = item.Description, Status = item.Status, Createtime = item.Createtime, Updatetime = item.Updatetime, }); }
public static ProductDescriptionConfig IsExcistProductDescriptionItem(ProductDescriptionModel item, ProductDescriptionConfig data) { ProductDescriptionConfig configDetails = new ProductDescriptionConfig(); ProductDescriptionBrand brandItem = new ProductDescriptionBrand(); if (item.AddOrDel > 0 && data.AddOrDel == 0) { data.AddOrDel = item.AddOrDel; } if (!string.IsNullOrEmpty(item.CategoryName) && string.IsNullOrEmpty(item.Brand) && !data.Categories.Contains(item.CategoryName)) { data.Categories.Add(item.CategoryName); } if (!string.IsNullOrEmpty(item.PID) && !data.Pids.Contains(item.PID)) { data.Pids.Add(item.PID); } if (!string.IsNullOrEmpty(item.Brand)) { if (data.BrandDetails.Where(o => o.BrandCategoryName.Equals(item.CategoryName)).Count() > 0) { foreach (var configItem in data.BrandDetails) { if (String.Equals(configItem.BrandCategoryName, item.CategoryName)) { if (String.Equals(configItem.BrandCategoryName, item.CategoryName) && !configItem.Brands.Contains(item.Brand)) { configItem.Brands.Add(item.Brand); } } } } else { brandItem.Brands = new List <string>(); brandItem.BrandCategoryName = item.CategoryName; brandItem.Brands.Add(item.Brand); data.BrandDetails.Add(brandItem); } } return(data); }
public static int InsertProductModule(SqlDbHelper dbhelper, ProductDescriptionModel model, int moduleID, ProductDescriptionModel platformItem, string userName) { using (var cmd = new SqlCommand("[Gungnir]..[ProductModel_InsertProductModuleInfo]")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ModuleID", moduleID); cmd.Parameters.AddWithValue("@ModuleName", model.ModuleName); cmd.Parameters.AddWithValue("@ModuleOrder", model.ModuleOrder); cmd.Parameters.AddWithValue("@StartDateTime", model.StartDateTime); cmd.Parameters.AddWithValue("@EndDateTime", model.EndDateTime); cmd.Parameters.AddWithValue("@IsAdvert", model.IsAdvert); cmd.Parameters.AddWithValue("@ShowPlatform", model.IsAdvert == false ? model.ShowPlatform : platformItem.ShowPlatform); cmd.Parameters.AddWithValue("@BigImageUrl", model.IsAdvert == false ? null : platformItem.BigImageUrl); cmd.Parameters.AddWithValue("@SmallImageUrl", model.IsAdvert == false ? null : platformItem.SmallImageUrl); cmd.Parameters.AddWithValue("@AppHandlekey", model.IsAdvert == false ? null : platformItem.AppHandleKey); cmd.Parameters.AddWithValue("@AppSpecialkey", model.IsAdvert == false ? null : platformItem.AppSpecialKey); cmd.Parameters.AddWithValue("@URL", model.IsAdvert == false ? null : platformItem.URL); cmd.Parameters.AddWithValue("@ModuleContent", model.IsAdvert == false ? (model.ModuleContent == "" ? null : model.ModuleContent) : (platformItem.ModuleContent == "" ? null : platformItem.ModuleContent)); cmd.Parameters.AddWithValue("@CreatedUser", userName); return(dbhelper.ExecuteNonQuery(cmd)); } }
public bool Save(ProductDescriptionModel model) { return(new ProductDescriptionService().Save(model)); }
/// <summary> /// /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Save(ProductDescriptionModel model) { return(ProductDescriptionRepository.Save(model.ToPO())); }
public static int InsertProductConfig(ProductDescriptionModel productModuleModel, List <ProductDescriptionModel> platformList, List <ProductDescriptionModel> categoryList, List <ProductDescriptionModel> pidList, List <ProductDescriptionModel> brandList, string userName, out int moduleID) { var conn = ConfigurationManager.ConnectionStrings["Gungnir"].ConnectionString; if (SecurityHelp.IsBase64Formatted(conn)) { conn = SecurityHelp.DecryptAES(conn); } using (var dbhelper = new SqlDbHelper(conn)) { dbhelper.BeginTransaction(); var result = 0; moduleID = DALProductModuleConfig.GetProductModuleMaxID(dbhelper) + 1; if (platformList.Count() <= 0) { result = DALProductModuleConfig.InsertProductModule(dbhelper, productModuleModel, moduleID, null, userName); } else { foreach (var item in platformList) { var r = DALProductModuleConfig.InsertProductModule(dbhelper, productModuleModel, moduleID, item, userName); if (r <= 0) { dbhelper.Rollback(); moduleID = 0; return(-1); } } result = 1; } if (result > 0) { foreach (var item in categoryList) { item.ModuleID = moduleID; var r = InsertProductConfigCategory(dbhelper, item, productModuleModel, userName); if (r <= 0) { dbhelper.Rollback(); moduleID = 0; return(-1); } } foreach (var item in pidList) { item.ModuleID = moduleID; var r = InsertProductConfigPID(dbhelper, item, productModuleModel, userName); if (r <= 0) { dbhelper.Rollback(); moduleID = 0; return(-1); } } foreach (var item in brandList) { item.ModuleID = moduleID; var r = InsertProductConfigBrand(dbhelper, item, userName); if (r <= 0) { dbhelper.Rollback(); moduleID = 0; return(-1); } } dbhelper.Commit(); return(moduleID); } else { dbhelper.Rollback(); moduleID = 0; return(-1); } } }
public async Task <IActionResult> UpdateProductDescriptionData(int productDescId, ProductDescriptionModel productDescriptionModel) { try { var productDescriptionDetails = await _context.ProductDescriptions.FirstOrDefaultAsync(x => x.ProductDescId == productDescId); productDescriptionDetails.AuthorName = productDescriptionModel.AuthorName; productDescriptionDetails.AuthorDescription = productDescriptionModel.AuthorDescription; productDescriptionDetails.AuthorImage = productDescriptionModel.AuthorImageValue; productDescriptionDetails.ProductSummary = productDescriptionModel.ProductSummary; productDescriptionDetails.PublisherName = productDescriptionModel.PublisherName; productDescriptionDetails.Edition = productDescriptionModel.Edition; productDescriptionDetails.NumOfPages = productDescriptionModel.NumofPages; productDescriptionDetails.Country = productDescriptionModel.Country; productDescriptionDetails.Language = productDescriptionModel.Language; var resultProductStock = _context.ProductDescriptions.Update(productDescriptionDetails); await _context.SaveChangesAsync(); return(NoContent()); } catch (Exception ex) { throw ex; } }
public static int UpdateProductConfig(ProductDescriptionModel productModuleModel, List <ProductDescriptionModel> platformList, List <ProductDescriptionModel> categoryList, List <ProductDescriptionModel> pidList, List <ProductDescriptionModel> brandList, int ParentID, string userName) { return(DALProductModuleConfig.UpdateProductConfig(productModuleModel, platformList, categoryList, pidList, brandList, ParentID, userName)); }
public static int InsertProductConfig(ProductDescriptionModel productModuleModel, List <ProductDescriptionModel> platformList, List <ProductDescriptionModel> categoryList, List <ProductDescriptionModel> pidList, List <ProductDescriptionModel> brandList, string userName, out int moduleID) { return(DALProductModuleConfig.InsertProductConfig(productModuleModel, platformList, categoryList, pidList, brandList, userName, out moduleID)); }