public JsonResult SaveNews(string news)
{
var serializer = new JavaScriptSerializer();
var newDTO = serializer.Deserialize <NewDTO>(news);
for (int i = 0; i < newDTO.baseImages.Count; i++)
{
byte[] bytes = Convert.FromBase64String(newDTO.baseImages[i]);
Image image;
using (MemoryStream ms = new MemoryStream(bytes))
{
image = Image.FromStream(ms);
}
string generateFileName = GenerateName.doGenerate(((AccountDTO)Session[Constants.USER_SESSION]).PhoneNum);
var fullPath = Path.Combine(Server.MapPath("~/Public/img/"), generateFileName);
try
{
new Bitmap(image).Save(fullPath, System.Drawing.Imaging.ImageFormat.Jpeg);
newDTO.baseImages[i] = "/Public/img/" + generateFileName;
}
catch
{
return(Json(new
{
data = false
}));
}
}
var check = newDTO.newId > 0 ? new NewsDAO().UpdateNew(newDTO) : new NewsDAO().AddNew(newDTO);
return(Json(new
{
data = check
}));
}
public void Run()
{
using (var db = new ApplicationDbContext()){
var category = new Category {
Name = GenerateName.NextProductName()
};
var product = new Product {
Name = GenerateName.NextProductName() + " EF", Category = category
};
db.Products.Add(product);
db.SaveChanges();
}
}
public void Run()
{
using (IDbConnection db = new SqlConnection(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=benchmarkef;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"))
{
string insertCategory = @"INSERT INTO Categories(Name) VALUES (@Name); SELECT CAST(SCOPE_IDENTITY() as int)";
var category = new Category {
Name = GenerateName.NextCategoryName()
};
var resultCategory = db.Query <int>(insertCategory, new { Name = category.Name });
string insertProduct = @"INSERT INTO Products(Name, CategoryId) VALUES (@Name, @CategoryId)";
var product = new Product {
Name = GenerateName.NextProductName(), Category = category
};
var resultProduct = db.Execute(insertProduct, new { Name = product.Name + " Dapper", CategoryId = resultCategory.Single() });
}
}
