Practika24/СУБД Швейная фабрика/FormGetMaterial.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Drawing.Imaging;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace СУБД_Швейная_фабрика
{
    public partial class FormGetMaterial : Form
    {
        public FormGetMaterial()
        {
            InitializeComponent();
        }

        public struct Tkani
        {
            public string NameTkan, ColorTkan, WidthTkan, LengthTkan, Description;
            public Image PhotoTkan;
        }

        List<Tkani> LstTkani = new List<Tkani>();

        private void BtnLoadPhotoTkan_Click(object sender, EventArgs e)
        {
            try
            {
                if (openFileDialog1.ShowDialog() == DialogResult.OK)
                    PbxPhotoTkan.Image = Image.FromFile(openFileDialog1.FileName);
            }
            catch { }
        }

        private void BtnClearPhotoTkan_Click(object sender, EventArgs e)
        {
            DialogResult res = MessageBox.Show("Очистить фотографию?", "Внимание!",
                MessageBoxButtons.YesNo, MessageBoxIcon.Question);
            if (res == DialogResult.Yes)
                PbxPhotoTkan.Image = null;
        }

        private void BtnAddTkan_Click(object sender, EventArgs e)
        {
            Tkani Tk1 = new Tkani();
            Tk1.NameTkan = TbxNameTkan.Text;
            Tk1.ColorTkan = TbxColorTkan.Text;
            Tk1.WidthTkan = TbxWidthTkan.Text;
            Tk1.LengthTkan = TbxLengthTkan.Text;
            Tk1.Description = TbxDescriptionTkan.Text;
            Tk1.PhotoTkan = PbxPhotoTkan.Image;
            LstTkani.Add(Tk1);
            DgvTkani.Rows.Add(Tk1.NameTkan, Tk1.ColorTkan, Tk1.WidthTkan, Tk1.LengthTkan, Tk1.Description);
        }

        private void BtnDelTkan_Click(object sender, EventArgs e)
        {
            int NumTkan = DgvTkani.CurrentRow.Index;
            if (NumTkan >= 0)
            {
                DialogResult res = MessageBox.Show("Удалить выделенную ткань?",
                    "Внимание!", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (res == DialogResult.Yes)
                {
                    LstTkani.RemoveAt(NumTkan);
                    DgvTkani.Rows.RemoveAt(NumTkan);
                }
            }
        }

        private void BtnOK_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(Properties.Settings.Default.dbFabrikaOAAConnectionString);
            foreach (Tkani Tk1 in LstTkani)
            {
                con.Open();
                if (Tk1.PhotoTkan != null)
                {
                    string t = string.Format(@"
insert into Tkan (Title, id_color, Width, Length, Comment, NamePhoto)
values ('{0}', '{1}', {2}, {3}, '{4}', @phototkan)",
    Tk1.NameTkan, Tk1.ColorTkan, Tk1.WidthTkan, Tk1.LengthTkan, Tk1.Description);
                    SqlCommand query1 = new SqlCommand(t, con);

                    MemoryStream ms = new MemoryStream();
                    Tk1.PhotoTkan.Save(ms, ImageFormat.Jpeg);
                    query1.Parameters.AddWithValue("@NamePhoto", ms.ToArray());
                    query1.ExecuteNonQuery();
                }
                else
                {
                    string t = string.Format(@"
insert into Tkan (Title, id_color, Width, Length, Comment)
values ('{0}', '{1}', {2}, {3}, '{4}')",
    Tk1.NameTkan, Tk1.ColorTkan, Tk1.WidthTkan, Tk1.LengthTkan, Tk1.Description);
                    SqlCommand query1 = new SqlCommand(t, con);
                    query1.ExecuteNonQuery();
                }

                con.Close();

                MessageBox.Show("Документ принят к учету.", "Внимание!",
                MessageBoxButtons.OK, MessageBoxIcon.Information);
                this.Close();
            }
        }
    }
}