public static bool EditStroymat(StroymatDTO order) { //List<ProductDTO> ProductsList = new List<ProductDTO>(); using (SqlConnection conn = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("sp_update_kraska", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", order.Id); cmd.Parameters.AddWithValue("@name", order.Name); cmd.Parameters.AddWithValue("@desc", order.Description); cmd.Parameters.AddWithValue("@price", order.Price); cmd.Parameters.AddWithValue("@country", order.Country); cmd.Parameters.AddWithValue("@man", order.Manufacturer); cmd.Parameters.AddWithValue("@type", order.Type); cmd.Parameters.AddWithValue("@discount", order.Discount); conn.Open(); //dt.Load(cmd.ExecuteReader()); cmd.ExecuteNonQuery(); return(true); } }
public static bool AddStroymat(StroymatDTO order, out int id) { int cnt = 0; if (order.Img1 != null) { cnt++; } if (order.Img2 != null) { cnt++; } if (order.Img3 != null) { cnt++; } //DataTable dt = new DataTable(); //List<ProductDTO> ProductsList = new List<ProductDTO>(); using (SqlConnection conn = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("sp_insert_stroymateryal", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@name", order.Name); cmd.Parameters.AddWithValue("@desc", order.Description); cmd.Parameters.AddWithValue("@price", order.Price); cmd.Parameters.AddWithValue("@country", order.Country); cmd.Parameters.AddWithValue("@man", order.Manufacturer); cmd.Parameters.AddWithValue("@type", order.Type); cmd.Parameters.AddWithValue("@discount", order.Discount); cmd.Parameters.AddWithValue("@imgscount", cnt); SqlParameter outParameter = new SqlParameter("@id", SqlDbType.Int); outParameter.Direction = ParameterDirection.Output; cmd.Parameters.Add(outParameter); //cmd.Parameters.Add("@items", SqlDbType.Structured); //cmd.Parameters.Add("@items", SqlDbType.Structured); //cmd.Parameters.Add("@items", SqlDbType.Structured); //cmd.Parameters["@items"].Value = order.Items; //cmd.Parameters.AddWithValue("@items", order.Items); conn.Open(); //dt.Load(cmd.ExecuteReader()); cmd.ExecuteNonQuery(); id = Convert.ToInt32(outParameter.Value); //foreach (DataRow dr in dt.Rows) //{ // ProductsList.Add(dr.ConvertToProductDTO()); //} return(true); } }
public bool EditStroymat(StroymatDTO str) { bool isAdded = false; isAdded = DataProvider.EditStroymat(str); return(isAdded); }
public string CreateStroymat([FromForm] StroymatDTO str) { bool isAdded = false; isAdded = DataProvider.AddStroymat(str, out var id); try { string path = @"imgs\stroymateryali\" + id; Directory.CreateDirectory(path); if (str.Img1?.Length > 0) { var filePath = path + @"\1.jpg"; using (var fileStream = new FileStream(filePath, FileMode.Create)) { str.Img1.CopyTo(fileStream); } } if (str.Img2?.Length > 0) { var filePath = path + @"\2.jpg"; using (var fileStream = new FileStream(filePath, FileMode.Create)) { str.Img2.CopyTo(fileStream); } } if (str.Img3?.Length > 0) { var filePath = path + @"\3.jpg"; using (var fileStream = new FileStream(filePath, FileMode.Create)) { str.Img3.CopyTo(fileStream); } } } catch (Exception ex) { return(ex.Message); } return(id.ToString()); }