Esempio n. 1
0
        public DialogProduk(String id_produk)
        {
            InitializeComponent();


            k.sql = "select *from tb_produk where id_produk ='" + id_produk + "'";
            k.setdt();
            Byte[] tmpfoto = new Byte[0];
            foreach (DataRow baris in k.dt.Rows)
            {
                txt_id.Text   = baris[0].ToString();
                txt_nama.Text = baris[1].ToString();
                if (baris[2].ToString() == "Makanan")
                {
                    rb_makanan.IsChecked = true;
                }
                else
                {
                    rb_minuman.IsChecked = true;
                }
                txt_detail.Text = baris[3].ToString();
                txt_harga.Text  = Convert.ToDecimal(baris[4].ToString()).ToString("c");

                tmpfoto         = (Byte[])baris[5];
                img_foto.Source = ByteImageConverter.ByteToImage(tmpfoto);
            }
        }
Esempio n. 2
0
        public static void ProcessMembersPhoto(DataTable employees)
        {
            for (int i = 0; i < employees.Rows.Count; i++)
            {
                var row       = employees.Rows[i];
                var bytes     = row["Photo"];
                var fullImage = ByteImageConverter.FromByteArray(bytes as byte[]);

                var   size   = new Size(40, 40);
                float scaleX = ((float)size.Width) / fullImage.Width;
                float scaleY = ((float)size.Height) / fullImage.Height;
                float scale  = scaleX > scaleY ? scaleX : scaleY;

                var resizedImage = new Bitmap(size.Width, size.Height);
                using (Graphics g = Graphics.FromImage(resizedImage)) {
                    size = new Size(
                        (int)(fullImage.Width * scale + 0.5f),
                        (int)(fullImage.Height * scale + 0.5f));
                    g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic;
                    g.DrawImage(fullImage, new Rectangle(Point.Empty, size));
                }
                var          opt = new PictureEditOptionsMask(null);
                var          img = PictureMaskHelper.CreateCircleMaskImage(resizedImage, opt);
                MemoryStream ms  = new MemoryStream();
                img.Save(ms, ImageFormat.Png);
                var result = ms.ToArray();
                ms.Close();
                row["Photo"] = result;
            }
        }
        private static ImageSource ConvertAndFreeze(byte[] bytes)
        {
            var imageSource = ByteImageConverter.Convert(bytes);

            imageSource?.Freeze();
            return(imageSource);
        }
Esempio n. 4
0
        private void LoadIcon(BuildStatusEnum statusValue, bool isInProgress, bool isStuck)
        {
            var status = new BuildStatus(statusValue, isInProgress, isStuck);

            if (iconsByKey.ContainsKey(status.Key))
            {
                return;
            }

            try
            {
                var resourceName = string.Format("JenkinsTray.Resources.StatusIcons.{0}.gif", status.Key);
                var img          = ResourceImageHelper.CreateImageFromResources(resourceName, GetType().Assembly);
                var imgBytes     = ByteImageConverter.ToByteArray(img, ImageFormat.Gif);
                iconsByKey.Add(status.Key, imgBytes);
            }
            catch (Exception ex)
            {
                XtraMessageBox.Show(JenkinsTrayResources.FailedLoadingIcons_Text,
                                    JenkinsTrayResources.FailedLoadingIcons_Caption,
                                    MessageBoxButtons.OK, MessageBoxIcon.Error);
                LoggingHelper.LogError(logger, ex);
                throw new Exception("Failed loading icon: " + status, ex);
            }
        }
Esempio n. 5
0
 internal static Picture FromImage(Image image)
 {
     return((image == null) ? null : new Picture()
     {
         Data = ByteImageConverter.ToByteArray(image, image.RawFormat)
     });
 }
Esempio n. 6
0
 public Agent(DataRow person)
 {
     this.person = person;
     if (!(person["Photo"] is DBNull))
     {
         photo = ByteImageConverter.FromByteArray((byte[])person["Photo"]);
     }
 }
Esempio n. 7
0
 public Home(DataRow row)
 {
     this.row = row;
     features = DataHelper.GetFeaturesFormat(string.Format("{0}", row["Features"]));
     if (!(row["Photo"] is DBNull))
     {
         photo = ByteImageConverter.FromByteArray((byte[])row["Photo"]);
     }
 }
        private void btn_simpan_Click(object sender, RoutedEventArgs e)
        {
            if (txt_nama.Text == "" || txt_telp.Text == "" || txt_asalkota.Text == "" || txt_nik.Text == "")
            {
                var sampleMessageDialog = new SampleMessageDialog
                {
                    Message = { Text = "Lengkapi Dulu Data" }
                };
                DialogHost.Show(sampleMessageDialog, "SubDialogCustomer");
            }
            else
            {
                try
                {
                    String jk = "";
                    if (rb_laki.IsChecked == true)
                    {
                        jk = "P";
                    }
                    else
                    {
                        jk = "W";
                    }
                    DateTime tgllahir = tgl_lahir.SelectedDate.Value;
                    var      img      = ByteImageConverter.ConvertBitmapSourceToByteArray(img_foto.Source);

                    k.sql = "insert into customer values(@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12)";
                    k.setparam();
                    k.perintah.Parameters.AddWithValue("@1", null);
                    k.perintah.Parameters.AddWithValue("@2", txt_nik.Text);
                    k.perintah.Parameters.AddWithValue("@3", txt_nama.Text);
                    k.perintah.Parameters.AddWithValue("@4", txt_telp.Text);
                    k.perintah.Parameters.AddWithValue("@5", jk);
                    k.perintah.Parameters.AddWithValue("@6", tgllahir.ToString("yyyy-MM-dd"));
                    k.perintah.Parameters.AddWithValue("@7", txt_asalkota.Text);
                    k.perintah.Parameters.AddWithValue("@8", txt_alamat.Text);
                    k.perintah.Parameters.AddWithValue("@9", cmb_pekerjaan.Text);
                    k.perintah.Parameters.AddWithValue("@10", txt_instansi.Text);
                    k.perintah.Parameters.AddWithValue("@11", img);
                    k.perintah.Parameters.AddWithValue("@12", 0);

                    k.perintah.ExecuteNonQuery();
                    k.close();

                    DialogHost.CloseDialogCommand.Execute(null, this);
                    var sampleMessageDialog = new SampleMessageDialog
                    {
                        Message = { Text = "Data Berhasil Tersimpan" }
                    };
                    DialogHost.Show(sampleMessageDialog, "MainDialog");
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Data Gagal Didaftarkan " + ex);
                }
            }
        }
Esempio n. 9
0
        private void btn_simpan_Click(object sender, RoutedEventArgs e)
        {
            if (txt_id.Text == "" || txt_nama.Text == "" || txt_harga.Text == "")
            {
                var sampleMessageDialog = new SampleMessageDialog
                {
                    Message = { Text = "Lengkapi Dulu Data" }
                };
                DialogHost.Show(sampleMessageDialog, "MainDialog");
            }
            else
            {
                try
                {
                    String jenis = "";
                    int    harga = int.Parse(txt_harga.Text, System.Globalization.NumberStyles.Currency);

                    if (rb_makanan.IsChecked == true)
                    {
                        jenis = "Makanan";
                    }
                    else
                    {
                        jenis = "Minuman";
                    }

                    var img = ByteImageConverter.ConvertBitmapSourceToByteArray(img_foto.Source);

                    k.sql = "insert into tb_produk values(@id,@nama,@jenis,@detail,@harga,@foto)";
                    k.setparam();
                    k.perintah.Parameters.AddWithValue("@id", txt_id.Text);
                    k.perintah.Parameters.AddWithValue("@nama", txt_nama.Text);
                    k.perintah.Parameters.AddWithValue("@detail", txt_detail.Text);
                    k.perintah.Parameters.AddWithValue("@jenis", jenis);
                    k.perintah.Parameters.AddWithValue("@harga", harga);
                    k.perintah.Parameters.AddWithValue("@foto", img);

                    k.perintah.ExecuteNonQuery();
                    k.close();

                    var sampleMessageDialog = new SampleMessageDialog
                    {
                        Message = { Text = "Data Berhasil Tersimpan" }
                    };
                    DialogHost.Show(sampleMessageDialog, "MainDialog");
                    showdata();
                    bersih();
                    kodeotomatis();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Data Gagal Didaftarkan " + ex);
                }
            }
        }
Esempio n. 10
0
        private void loadIcon(string strIconResourceName)
        {
            Stream stm = ManifestResources.GetManifestResource(strIconResourceName);
            Image  img = ByteImageConverter.StreamToImage(stm);

            img.Width  = 20;
            img.Height = 20;
            img.HorizontalAlignment = HorizontalAlignment.Stretch;
            img.VerticalAlignment   = VerticalAlignment.Stretch;
            this.Icon = img;
        }
 Image CreateImage(byte[] data)
 {
     if (data == null)
     {
         return(ResourceImageHelper.CreateImageFromResourcesEx("DevExpress.DevAV.Resources.Unknown-user.png", typeof(Employee).Assembly));
     }
     else
     {
         return(ByteImageConverter.FromByteArray(data));
     }
 }
Esempio n. 12
0
 internal static Image CreateImage(this Picture picture, string defaultImage = null)
 {
     if (picture == null)
     {
         if (string.IsNullOrEmpty(defaultImage))
         {
             defaultImage = DefaultPic;
         }
         return(ResourceImageHelper.CreateImageFromResourcesEx(defaultImage, typeof(Picture).Assembly));
     }
     return(ByteImageConverter.FromByteArray(picture.Data));
 }
Esempio n. 13
0
        private void cmdAbriImagen_Click(object sender, EventArgs e)
        {
            OpenFileDialog openFileDialog = new OpenFileDialog
            {
                Filter = @"Archivos de imagen|*.jpg;*.jpeg;*.png;*.gif;*.tif;"
            };

            if (openFileDialog.ShowDialog() == DialogResult.OK)
            {
                Image  img  = Image.FromFile(openFileDialog.FileName);
                byte[] data = ByteImageConverter.ToByteArray(img, img.RawFormat);
                iFoto.EditValue = data;
            }
        }
Esempio n. 14
0
        List <TileViewItemElement> GetMembersElements(string taskId)
        {
            var memberRows = membersData.Select("TaskID = " + taskId);
            var result     = new List <TileViewItemElement>();

            foreach (var memberRow in memberRows)
            {
                var photoBytes = employeesData.Rows.Find(memberRow["MemberID"])["Photo"];
                var element    = new TileViewItemElement();
                element.Image = ByteImageConverter.FromByteArray(photoBytes as byte[]);
                result.Add(element);
            }
            return(result);
        }
Esempio n. 15
0
        internal static List <Image> GetPhotos(Home home)
        {
            List <Image> ret = new List <Image>();

            ret.Add(home.Photo);
            foreach (DataRow row in PhotosTable.Rows)
            {
                int id = home.ID % 7 + 1;
                if (id.Equals(row["ParentID"]))
                {
                    ret.Add(ByteImageConverter.FromByteArray((byte[])row["Photo"]));
                }
            }
            return(ret);
        }
Esempio n. 16
0
        static List <Vehicle> InitMDBData(string connectionString)
        {
            string Model     = "Model";
            string Trademark = "Trademark";

            DataSet ds = new DataSet();

            FillTable(Model, connectionString, ds);
            FillTable(Trademark, connectionString, ds);

            List <Trademark> listTrademarks = new List <Trademark>();

            foreach (DataRow row in ds.Tables[Trademark].Rows)
            {
                listTrademarks.Add(new Trademark()
                {
                    ID   = (int)(long)row["ID"],
                    Name = (string)row["Name"],
                });
            }

            var listModels = new List <Vehicle>();

            foreach (DataRow row in ds.Tables[Model].Rows)
            {
                listModels.Add(new Vehicle()
                {
                    ID                 = (int)(long)row["ID"],
                    Name               = (string)row["Name"],
                    Trademark          = (int)(long)row["TrademarkID"],
                    Modification       = (string)row["Modification"],
                    MPGCity            = System.DBNull.Value.Equals(row["MPG City"]) ? null : (int?)(long)row["MPG City"],
                    MPGHighway         = System.DBNull.Value.Equals(row["MPG City"]) ? null : (int?)(long)row["MPG Highway"],
                    Doors              = (int)(long)row["Doors"],
                    Cylinders          = (int)(long)row["Cylinders"],
                    Horsepower         = (string)row["Horsepower"],
                    Torque             = (string)row["Torque"],
                    TransmissionSpeeds = Convert.ToInt32(row["Transmission Speeds"]),
                    TransmissionType   = (int)(long)row["Transmission Type"],
                    Description        = string.Format("{0}", row["Description"]),
                    Photo              = ByteImageConverter.FromByteArray((byte[])row["Photo"]),
                    TrademarkName      = GetTrademarkName(ds.Tables[Trademark], (int)(long)row["TrademarkID"])
                });
            }
            return(listModels);
        }
Esempio n. 17
0
        private void btn_ubah_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                String jk = "";
                if (rb_laki.IsChecked == true)
                {
                    jk = "P";
                }
                else
                {
                    jk = "W";
                }
                DateTime tgllahir = tgl_lahir.SelectedDate.Value;
                var      img      = ByteImageConverter.ConvertBitmapSourceToByteArray(img_foto.Source);

                k.sql = "update customer set nama=@1,no_hp=@2,jenis_kelamin=@3,tgl_lahir=@4,kota=@5,alamat=@6,pekerjaan=@7,nama_instansi=@8,foto=@9, nik=@10 where id_customer = '" + idCustomer + "'";
                k.setparam();
                k.perintah.Parameters.AddWithValue("@1", txt_nama.Text);
                k.perintah.Parameters.AddWithValue("@2", txt_telp.Text);
                k.perintah.Parameters.AddWithValue("@3", jk);
                k.perintah.Parameters.AddWithValue("@4", tgllahir.ToString("yyyy-MM-dd"));
                k.perintah.Parameters.AddWithValue("@5", txt_asalkota.Text);
                k.perintah.Parameters.AddWithValue("@6", txt_alamat.Text);
                k.perintah.Parameters.AddWithValue("@7", cmb_pekerjaan.Text);
                k.perintah.Parameters.AddWithValue("@8", txt_instansi.Text);
                k.perintah.Parameters.AddWithValue("@9", img);
                k.perintah.Parameters.AddWithValue("@10", txt_nik.Text);

                k.perintah.ExecuteNonQuery();
                k.close();

                DialogHost.CloseDialogCommand.Execute(null, this);

                var sampleMessageDialog = new SampleMessageDialog
                {
                    Message = { Text = "Data Berhasil Diubah" }
                };
                DialogHost.Show(sampleMessageDialog, "MainDialog");
            }
            catch (Exception ex)
            {
                MessageBox.Show("error " + ex.ToString());
            }
        }
Esempio n. 18
0
        public Contacto(DataRow customer, DataRow person)
        {
            this.customer = customer;
            this.person   = person;
            if (!(customer["foto"] is DBNull))
            {
                foto     = ByteImageConverter.FromByteArray((byte[])customer["foto"]);
                hay_foto = true;
            }
            //else foto = global::DevExpress.MailClient.Win.Properties.Resources.Unknown_user;

            name             = new NombreCompleto(string.Format("{0}", person["FirstName"]), string.Format("{0}", customer["MiddleName"]), string.Format("{0}", person["LastName"]));
            email            = string.Format("{0}", customer["Email"]).Replace("dxvideorent.com", "dxmail.net");
            genero           = (eGenero)person["Gender"];
            fecha_nacimiento = (DateTime?)person["BirthDate"];
            telefono         = string.Format("{0}", customer["Phone"]);
            direccion        = new Address(string.Format("{0}", customer["Address"]));
        }
Esempio n. 19
0
        private void btn_ubah_Click(object sender, RoutedEventArgs e)
        {
            String jenis = "";

            if (rb_makanan.IsChecked == true)
            {
                jenis = "Makanan";
            }
            else
            {
                jenis = "Minuman";
            }

            int harga = int.Parse(txt_harga.Text, System.Globalization.NumberStyles.Currency);
            var img   = ByteImageConverter.ConvertBitmapSourceToByteArray(img_foto.Source);

            try
            {
                k.sql = "update tb_produk set nama=@nama,jenis=@jenis,detail=@detail,harga=@harga,foto=@foto where id_produk = '" + txt_id.Text + "'";
                k.setparam();
                k.perintah.Parameters.AddWithValue("@nama", txt_nama.Text);
                k.perintah.Parameters.AddWithValue("@jenis", jenis);
                k.perintah.Parameters.AddWithValue("@detail", txt_detail.Text);
                k.perintah.Parameters.AddWithValue("@harga", harga);
                k.perintah.Parameters.AddWithValue("@foto", img);

                k.perintah.ExecuteNonQuery();
                k.close();

                DialogHost.CloseDialogCommand.Execute(null, this);

                var sampleMessageDialog = new SampleMessageDialog
                {
                    Message = { Text = "Data Berhasil Diubah" }
                };
                DialogHost.Show(sampleMessageDialog, "MainDialog");
            }
            catch (Exception ex)
            {
                MessageBox.Show("error " + ex.ToString());
            }
        }
Esempio n. 20
0
        private async void loadData()
        {
            await Task.Delay(300);

            try
            {
                k.sql = "select *from customer where id_customer ='" + idCustomer + "'";
                k.setdt();
                Byte[] tmpfoto = new Byte[0];
                foreach (DataRow baris in k.dt.Rows)
                {
                    txt_nik.Text  = baris[1].ToString();
                    txt_nama.Text = baris[2].ToString();
                    txt_telp.Text = baris[3].ToString();
                    if (baris[4].ToString() == "P")
                    {
                        rb_laki.IsChecked = true;
                    }
                    else
                    {
                        rb_perempuan.IsChecked = true;
                    }
                    String   tgllahir = baris[5].ToString();
                    DateTime dt       = Convert.ToDateTime(tgllahir);
                    tgl_lahir.SelectedDate = dt;
                    txt_asalkota.Text      = baris[6].ToString();
                    txt_alamat.Text        = baris[7].ToString();
                    cmb_pekerjaan.Text     = baris[8].ToString();
                    txt_instansi.Text      = baris[9].ToString();

                    if (!baris[10].Equals(null))
                    {
                        tmpfoto         = (Byte[])baris[10];
                        img_foto.Source = ByteImageConverter.ByteToImage(tmpfoto);
                    }
                }
            }
            catch (Exception ex)
            {
                //MessageBox.Show("error di open " + ex);
            }
        }
Esempio n. 21
0
 public Contact(DataRow customer, DataRow person)
 {
     this.customer = customer;
     this.person   = person;
     if (!(customer["Photo"] is DBNull))
     {
         photo    = ByteImageConverter.FromByteArray((byte[])customer["Photo"]);
         hasPhoto = true;
     }
     else
     {
         photo = global::DevExpress.MailClient.Win.Properties.Resources.Unknown_user;
     }
     name      = new FullName(string.Format("{0}", person["FirstName"]), string.Format("{0}", customer["MiddleName"]), string.Format("{0}", person["LastName"]));
     email     = string.Format("{0}", customer["Email"]).Replace("dxvideorent.com", "dxmail.net");
     gender    = (ContactGender)person["Gender"];
     birthDate = (DateTime?)person["BirthDate"];
     phone     = string.Format("{0}", customer["Phone"]);
     address   = new Address(string.Format("{0}", customer["Address"]));
 }
Esempio n. 22
0
        public UserInfo(DataRow customer, DataRow person)
        {
            this.customer = customer;
            this.person   = person;
            if (!(customer["Photo"] is DBNull))
            {
                photo    = ByteImageConverter.FromByteArray((byte[])customer["Photo"]);
                hasPhoto = true;
            }
            else
            {
                photo = global::DevExpress.ProductsDemo.Win.Properties.Resources.Unknown_user;
            }



            name = string.Format("{0}", person["Name"]);

            phone = string.Format("{0}", customer["Phone"]);
        }
Esempio n. 23
0
        void PopulateMembers()
        {
            tileGroup.Items.Clear();
            addMemberItem.Visible = true;
            tileGroup.Items.Add(addMemberItem);

            var memberIDs = GetMemeberIDs();

            foreach (var memberId in memberIDs)
            {
                var bytes = Employees.Rows.Find(memberId)["Photo"];
                var item  = new TileItem();
                item.Image          = ByteImageConverter.FromByteArray(bytes as byte[]);
                item.ImageAlignment = TileItemContentAlignment.MiddleCenter;
                var superTip = new SuperToolTip();
                superTip.Items.AddTitle(GetEmployeeFullName(memberId));
                item.SuperTip = superTip;
                item.Tag      = memberId;
                tileGroup.Items.Insert(0, item);
                addMemberItem.Visible = tileGroup.Items.Count == 5 ? false : true;
            }
        }
        protected override void OnEditValueChanged()
        {
            if (!(EditValue is EditValueInstance))
            {
                return;
            }
            if ((EditValue != null) && (EditValue as EditValueInstance).Image != null)
            {
                this.image = ByteImageConverter.FromByteArray(ByteImageConverter.ToByteArray((EditValue as EditValueInstance).Image));
            }
            Point offset = new Point(0, 0);

            if ((EditValue as EditValueInstance) != null)
            {
                offset = (EditValue as EditValueInstance).Offset;
            }
            if ((EditValue != null) && (offset != null))
            {
                this.HorizontOffset = offset.X;
                this.VerticalOffset = offset.Y;
            }
        }
        protected virtual Image GetImage()
        {
            Image      img = null;
            MyTreeList mtl = TreeList as MyTreeList;

            if (mtl.AvatarImageFieldName == string.Empty)
            {
                return(img);
            }

            try
            {
                DevExpress.XtraTreeList.Columns.TreeListColumn col = TreeList.Columns[mtl.AvatarImageFieldName];
                byte[] buffer = (byte[])GetValue(TreeList.Columns.IndexOf(col));
                img = ByteImageConverter.FromByteArray(buffer);
            }
            catch
            {
                img = null;
            }

            return(img);
        }
Esempio n. 26
0
        private void tableView_RowUpdated(object sender, RowEventArgs e)
        {
            NhanVienViewList row = (NhanVienViewList)grid.SelectedItem;

            if (row == null)
            {
                return;
            }
            grid.RefreshData();

            foreach (NhanVien i in dc.NhanViens.Where(x => x.nvid == row.nvid))
            {
                if (i != null)
                {
                    i.tennv = row.tennv;
                    if (row.gioitinh == "Nam")
                    {
                        i.gioitinh = true;
                    }
                    else
                    {
                        i.gioitinh = false;
                    }
                    i.hinh     = ByteImageConverter.ToByteArray(row.hinh);
                    i.diachi   = row.diachi;
                    i.doanhthu = row.doanhthu;
                    i.ngaysinh = row.ngaysinh;
                    i.matkhau  = row.matkhau;
                    i.email    = row.email;
                    i.sdt      = row.sdt;
                    i.quyen    = row.quyen;
                    dc.SubmitChanges();
                    MessageBox.Show("Đã cập nhật thành công !");
                }
            }
            grid.ItemsSource = new NhanVienModelView().DSNVList;
        }
 public static Image GetImage(byte[] array)
 {
     return(ByteImageConverter.FromByteArray(array));
 }
 internal byte[] ImageToByteArray(Image inp)
 {
     return(ByteImageConverter.ToByteArray(inp));
 }
 internal Image ByteArrayToImage(byte[] inp)
 {
     return(ByteImageConverter.FromByteArray(ByteImageConverter.ToByteArray(inp)));
 }
Esempio n. 30
0
        private void Aceptar_simpleButton_Click(object sender, EventArgs e)
        {
            try
            {
                if (!ValidaFormulario())
                {
                    return;
                }
                ConfiguracionGeneral configuracion = AConfiguracionId == 0 ? (new ConfiguracionGeneral()) : AGlobalDataContext.ConfiguracionGeneral.FirstOrDefault();
                if (configuracion != null)
                {
                    configuracion.Agencia           = Convert.ToString(NombreCentro_textEdit.EditValue);
                    configuracion.DireccionEmpresa  = Convert.ToString(Direccion_textEdit.EditValue);
                    configuracion.TelefonosAgencia  = Convert.ToString(Tel_textEdit.EditValue);
                    configuracion.CorreoElectronico = Convert.ToString(Email_textEdit.EditValue);
                    configuracion.SitioWeb          = Convert.ToString(SitioWeb_textEdit.EditValue);



                    if (pictureEdit1.Image != null)
                    {
                        {
                            Image  img  = pictureEdit1.Image;
                            byte[] data = ByteImageConverter.ToByteArray(img, img.RawFormat);
                            configuracion.LogoAgencia = data;
                        }
                    }
                    // pictureEdit1.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
                    //pictureEdit1.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
                    //binary = new Binary(ms.GetBuffer());
                    //byte[] _Imagen = binary.ToArray();
                    //configuracion.LogoAgencia = _Imagen;



                    #region Generales

                    configuracion.AnnoDeTrabajo = Convert.ToInt32(Anno_textEdit.EditValue);

                    configuracion.PrimerNumeroContratoNacionalAnual = Convert.ToInt32(PrimerCttoNacional_textEdit5.EditValue);
                    configuracion.CaminoContratosNacionales         = Convert.ToString(CaminoCttoNacional_buttonEdit.EditValue);

                    configuracion.PrimerNumeroContratoInternacionalAnual =
                        Convert.ToInt32(PrimerCttoIntern_textEdit.EditValue);
                    configuracion.CaminoContratoInternacionales =
                        Convert.ToString(CaminoCttoInternacional_buttonEdit.EditValue);

                    configuracion.Reup         = Convert.ToString(Reup_textEdit.EditValue).Trim();
                    configuracion.NitAgencia   = Convert.ToString(NIT_textEdit.EditValue).Trim();
                    configuracion.CerrandoAnno = EnCierre_checkEdit.Checked;

                    #endregion

                    #region cargos

                    configuracion.NombreDeJefeAgencia  = Convert.ToString(NombreDirigeAgencia_textEdit.EditValue);
                    configuracion.CargoDeJefeDeAgencia = Convert.ToString(CargoDirigeAgencia_textEdit.EditValue);

                    configuracion.NombreJefeDeDptoTramite = Convert.ToString(NombreDirigTram_textEdit.EditValue);
                    configuracion.CargoJefeDptoTramite    = Convert.ToString(CargoDirTram_textEdit.EditValue);

                    configuracion.Destinatario_O_DirigidoA = Convert.ToString(NombreDirEmpRect_textEdit.EditValue);
                    configuracion.CargoDestinatario        = Convert.ToString(CargoDirEmpRect_textEdit.EditValue);
                    configuracion.EmpresaDestinatario      = Convert.ToString(NombEmpRect_textEdit.EditValue);

                    #endregion

                    #region Otras
                    configuracion.VigenciaContrato = VigenciaContrato_textEdit.EditValue == null ? 0 : Convert.ToInt32(VigenciaContrato_textEdit.EditValue);
                    if (IndiceIngInst_textEdit.EditValue != null)
                    {
                        configuracion.IndiceParticipacionInstitucion = Convert.ToDecimal(IndiceIngInst_textEdit.EditValue);
                    }

                    #endregion

                    if (AConfiguracionId == 0)
                    {
                        AGlobalDataContext.ConfiguracionGeneral.InsertOnSubmit(configuracion);
                    }
                }

                AGlobalDataContext.SubmitChanges();
                ACambiosRealizados = true;
            }
            catch (Exception exception)
            {
                XtraMessageBox.Show(exception.Message);
            }
        }