Example #1
0
        private void PopulateData()
        {
            //using (bdEntities dc = new bdEntities())
            //{
            //    gvData.DataSource = dc.Pays.ToList();
            //    gvData.DataBind();
            //}
            //ds = new DataSet();
            //cmd.CommandText = "Select * from Pays";
            //cmd.Connection = con;
            //sda = new SqlDataAdapter(cmd);
            //sda.Fill(ds);
            //cmd.ExecuteNonQuery();
            //gvData.DataSource = ds;
            //gvData.DataBind();
            //con.Close();

            using (bdposbotEntities dc = new bdposbotEntities())
            {
                gvData.DataSource = dc.Pays.ToList();
                gvData.DataBind();
            }
        }
Example #2
0
        protected void btnImport_Click(object sender, EventArgs e)
        {
            byte[] xd;
            xd = FileUpload1.FileBytes;

            var      namefile = FileUpload1.PostedFile.FileName;
            clsExcel lmao     = new clsExcel();
            var      list     = lmao.mtdConvertirExcel(xd, null);
            //var name = list[1][1].ToString();

            SqlCommand cmd = new SqlCommand();

            cmd.CommandText = "Select * from Pays";
            cmd.Connection  = con;

            SqlDataAdapter sda = new SqlDataAdapter(cmd);

            DataSet ds = new DataSet();

            sda.Fill(ds);
            sda.Dispose();
            con.Close();
            con.Dispose();

            // Import to Database
            using (bdposbotEntities dc = new bdposbotEntities())
            {
                foreach (var ls in list)
                {
                    if (ls[0] != "Id")
                    {
                        string ci = ls[1];
                        var    v  = dc.Pays.Where(a => a.ci.Equals(ci)).FirstOrDefault();
                        if (v != null)
                        {
                            //Update here
                            v.ci          = ls[1];
                            v.apellidos   = ls[2];
                            v.nombres     = ls[3];
                            v.cuotaUno    = Convert.ToDouble(ls[4]);
                            v.cuotaDos    = Convert.ToDouble(ls[5]);
                            v.cuotaTres   = Convert.ToDouble(ls[6]);
                            v.cuotaCuatro = Convert.ToDouble(ls[7]);
                            v.cuotaCinco  = Convert.ToDouble(ls[8]);
                            v.cuotaSeis   = Convert.ToDouble(ls[9]);
                            v.idCurso     = ls[10];
                        }
                        else
                        {
                            //Insert
                            dc.Pays.Add(new Pays
                            {
                                id          = Convert.ToInt32(ls[0]),
                                ci          = ls[1],
                                apellidos   = ls[2],
                                nombres     = ls[3],
                                cuotaUno    = Convert.ToDouble(ls[4]),
                                cuotaDos    = Convert.ToDouble(ls[5]),
                                cuotaTres   = Convert.ToDouble(ls[6]),
                                cuotaCuatro = Convert.ToDouble(ls[7]),
                                cuotaCinco  = Convert.ToDouble(ls[8]),
                                cuotaSeis   = Convert.ToDouble(ls[9]),
                                idCurso     = ls[10]
                            });
                        }
                    }
                }
                dc.SaveChanges();
            }
            PopulateData();
            lblMessage.Text = "Successfully data import done!";
        }