コード例 #1
0
        public ActionResult Nuevo(ListTablaViewModelEmpleados model)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    using (Entities2 db = new Entities2())
                    {
                        var oTabla = new Empleados();
                        oTabla.Nombre            = model.Nombre;
                        oTabla.Habilidades       = model.Habilidades;
                        oTabla.Salario           = model.Salario;
                        oTabla.FechaContratacion = model.FechaContratacion;

                        db.Empleados.Add(oTabla);
                        db.SaveChanges();
                    }
                    return(Redirect("~/Tabla/"));
                }
                return(View(model));
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
コード例 #2
0
        public ActionResult Editar(ListTablaViewModelEmpleados model)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    using (Entities2 db = new Entities2())
                    {
                        var oTabla = db.Empleados.Find(model.IdEmpleados);
                        oTabla.Nombre            = model.Nombre;
                        oTabla.Habilidades       = model.Habilidades;
                        oTabla.Salario           = model.Salario;
                        oTabla.FechaContratacion = model.FechaContratacion;

                        db.Entry(oTabla).State = System.Data.Entity.EntityState.Modified;
                        db.SaveChanges();
                    }
                    return(Redirect("~/Tabla/"));
                }
                return(View(model));
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
コード例 #3
0
        //Sanstha Nawikaran List

        public List <GharkayamList> GetSansthanawikaranList(string loginId)
        {
            using (var context = new Entities2())
            {
                var           lgId         = Convert.ToInt32(loginId);
                var           selfData     = context.Sanstha_Nawikaran /*.Where(x => x.FormId == lgId)*/.ToList();
                GharkayamList Lastlistobj  = null;
                var           dataInfoList = new List <GharkayamList>();

                foreach (var s in selfData)
                {
                    Lastlistobj = new GharkayamList
                    {
                        FormId       = s.FormId,
                        Aabedan_miti = s.Aabedan_miti,
                        Naam         = s.Naam,
                        Pradesh      = s.Pradesh,
                        Jilla        = s.Jilla,
                        Gabisa       = s.Gabisa,
                        Ward         = s.Ward,
                        Sabikthegana = s.Sabik_thegana
                    };
                    dataInfoList.Add(Lastlistobj);
                }
                return(dataInfoList);
            }
        }
コード例 #4
0
        //View Sthayi Basobas
        public List <GharkayamList> GetSthayibasobasList(string loginId)
        {
            using (var context = new Entities2())
            {
                var           lgId         = Convert.ToInt32(loginId);
                var           selfData     = context.Sthayi_Basobas.Where(x => x.FormId == lgId).ToList();
                GharkayamList Lastlistobj  = null;
                var           dataInfoList = new List <GharkayamList>();

                foreach (var sbl in selfData)
                {
                    Lastlistobj = new GharkayamList
                    {
                        FormId         = sbl.FormId,
                        Aabedan_miti   = sbl.Aabedan_miti,
                        Aabedak_name   = sbl.Nibedak_naam,
                        Naam           = sbl.Naam,
                        Nagariktano    = sbl.Nagarikta_no,
                        Nagariktajilla = sbl.Nagarikta_Jilla,
                        Nagariktamiti  = sbl.Nagarikta_miti,
                        Basobasmiti    = sbl.Basobas_miti,
                        Pradesh        = sbl.Pradesh,
                        Jilla          = sbl.Jilla,
                        Gabisa         = sbl.Gabisa,
                        Ward           = sbl.Ward,
                        Sabikthegana   = sbl.Sabik_thegana,
                        Ghar_no        = sbl.Ghar_no,
                        Tole           = sbl.Tole,
                        Batokonaam     = sbl.Batoko_naam
                    };
                    dataInfoList.Add(Lastlistobj);
                }
                return(dataInfoList);
            }
        }
コード例 #5
0
        /// <summary>
        /// Pronalazi Glasanja čiji podaci odgovaraju traženom stringu iz txtSreachBar-a.
        /// </summary>
        private void PrikaziGlasanja()
        {
            int AdminID = 0;

            listaGlasanja = new BindingList <Glasanje>();

            using (var db = new Entities2())
            {
                foreach (Administrator admin in db.Administrator)
                {
                    if (admin.Korisnicko_ime == lblKIme.Text)
                    {
                        AdminID = admin.ID_administrator;
                    }
                }

                foreach (Glasanje glasanje in db.Glasanje)
                {
                    if (glasanje.AdministratorID_administrator == AdminID)
                    {
                        listaGlasanja.Add(glasanje);
                    }
                }
            }
            dgvGlasanja.DataSource = listaGlasanja;
        }
コード例 #6
0
        //saving Sampati Mulyankan
        public string SaveSampatimulyankan(Sampati_Muluyankan smn)
        {
            var message = "";

            using (var context = new Entities2())
            {
                var user = new Sampati_Muluyankan()
                {
                    Applicated_date   = smn.Applicated_date,
                    Full_name         = smn.Full_name,
                    Pradesh           = smn.Pradesh,
                    Jilla             = smn.Jilla,
                    Gabisa            = smn.Gabisa,
                    Ward              = smn.Ward,
                    Owners            = smn.Owners,
                    Particular_plotno = smn.Particular_plotno,
                    Bigga             = smn.Bigga,
                    Kattha            = smn.Kattha,
                    Dhur              = smn.Dhur,
                    Total_value       = smn.Total_value,
                    Remarks           = smn.Remarks
                };
                context.Sampati_Muluyankan.Add(user);

                context.SaveChanges();
                message = "save successfull";
            }
            return(message);
        }
コード例 #7
0
        //View Kar Sabdhani
        public List <GharkayamList> GetKarsabdhaniList(string loginId)
        {
            using (var context = new Entities2())
            {
                var           lgId         = Convert.ToInt32(loginId);
                var           selfData     = context.Kar_Sambandhi.Where(x => x.FormId == lgId).ToList();
                GharkayamList Lastlistobj  = null;
                var           dataInfoList = new List <GharkayamList>();

                foreach (var ksl in selfData)
                {
                    Lastlistobj = new GharkayamList
                    {
                        FormId       = ksl.FormId,
                        Aabedan_miti = ksl.Applicated_date,
                        Aabedak_name = ksl.Full_name,
                        Pradesh      = ksl.Pradesh,
                        Jilla        = ksl.Jilla,
                        Gabisa       = ksl.Gabisa,
                        Ward         = ksl.Ward,
                        Rakam        = ksl.Tax_amount,
                        Kitta_no     = ksl.Plot_no,
                        Wardno       = ksl.Property_wardno
                    };
                    dataInfoList.Add(Lastlistobj);
                }
                return(dataInfoList);
            }
        }
コード例 #8
0
        //View Barsik Aaya Pramanikaran
        public List <GharkayamList> GetBarsikpramanikaranList(string loginId)
        {
            using (var context = new Entities2())
            {
                var           lgId         = Convert.ToInt32(loginId);
                var           selfData     = context.Barsik_Pramanikaran.Where(x => x.FormId == lgId).ToList();
                GharkayamList Lastlistobj  = null;
                var           dataInfoList = new List <GharkayamList>();

                foreach (var bpl in selfData)
                {
                    Lastlistobj = new GharkayamList
                    {
                        FormId                = bpl.FormId,
                        Aabedan_miti          = bpl.Applicated_date,
                        Aabedak_name          = bpl.Full_name,
                        Pradesh               = bpl.Pradesh,
                        Jilla                 = bpl.Jilla,
                        Gabisa                = bpl.Gabisa,
                        Ward                  = bpl.Ward,
                        Relationwithapplicant = bpl.Relation_with_applicant,
                        Partiesname           = bpl.Parties_name,
                        Annualincome          = bpl.Annual_income,
                        Remarks               = bpl.Remarks,
                    };
                    dataInfoList.Add(Lastlistobj);
                }
                return(dataInfoList);
            }
        }
コード例 #9
0
        //saving Kar Sabdhani Pramanpatra
        public string SaveKarsabdhani(Kar_Sambandhi ksi)
        {
            var message = "";

            using (var context = new Entities2())
            {
                var user = new Kar_Sambandhi()
                {
                    Applicated_date = ksi.Applicated_date,
                    Full_name       = ksi.Full_name,
                    Pradesh         = ksi.Pradesh,
                    Jilla           = ksi.Jilla,
                    Gabisa          = ksi.Gabisa,
                    Ward            = ksi.Ward,
                    Plot_no         = ksi.Plot_no,
                    Tax_amount      = ksi.Tax_amount,
                    Property_wardno = ksi.Property_wardno
                };
                context.Kar_Sambandhi.Add(user);

                context.SaveChanges();
                message = "save successfull";
            }
            return(message);
        }
コード例 #10
0
        //saving Barsik Aaya Pramanikaran
        public string SaveBarsikpramanikaran(Barsik_Pramanikaran bpn)
        {
            var message = "";

            using (var context = new Entities2())
            {
                var user = new Barsik_Pramanikaran()
                {
                    Applicated_date         = bpn.Applicated_date,
                    Full_name               = bpn.Full_name,
                    Pradesh                 = bpn.Pradesh,
                    Jilla                   = bpn.Jilla,
                    Gabisa                  = bpn.Gabisa,
                    Ward                    = bpn.Ward,
                    Relation_with_applicant = bpn.Relation_with_applicant,
                    Parties_name            = bpn.Parties_name,
                    Annual_income           = bpn.Annual_income,
                    Remarks                 = bpn.Remarks
                };
                context.Barsik_Pramanikaran.Add(user);

                context.SaveChanges();
                message = "save successfull";
            }
            return(message);
        }
コード例 #11
0
        //View Sampati Mulyankan
        public List <GharkayamList> GetSampatimulyankanList(string loginId)
        {
            using (var context = new Entities2())
            {
                var           lgId         = Convert.ToInt32(loginId);
                var           selfData     = context.Sampati_Muluyankan.Where(x => x.FormId == lgId).ToList();
                GharkayamList Lastlistobj  = null;
                var           dataInfoList = new List <GharkayamList>();

                foreach (var sml in selfData)
                {
                    Lastlistobj = new GharkayamList
                    {
                        FormId           = sml.FormId,
                        Aabedan_miti     = sml.Applicated_date,
                        Aabedak_name     = sml.Full_name,
                        Pradesh          = sml.Pradesh,
                        Jilla            = sml.Jilla,
                        Gabisa           = sml.Gabisa,
                        Ward             = sml.Ward,
                        Owner            = sml.Owners,
                        Particularplotno = sml.Particular_plotno,
                        Bigga            = sml.Bigga,
                        Kattha           = sml.Kattha,
                        Dhur             = sml.Dhur,
                        TotalValue       = sml.Total_value,
                        Remarks          = sml.Remarks,
                    };
                    dataInfoList.Add(Lastlistobj);
                }
                return(dataInfoList);
            }
        }
コード例 #12
0
        public ActionResult Showcase()
        {
            Entities2 db         = new Entities2();
            var       imagesList = (from img in db.Images select img).ToList();

            return(View(imagesList));
        }
コード例 #13
0
        //saving Asthayi Basobas
        public string SaveAsthayibasobas(Asthayi_Basobas ab)
        {
            var message = "";

            using (var context = new Entities2())
            {
                var user = new Asthayi_Basobas()
                {
                    Aabedan_miti = ab.Aabedan_miti,
                    Aabedak_naam = ab.Aabedak_naam,

                    Nagarikta_no     = ab.Nagarikta_no,
                    Nagarikta_Jilla  = ab.Nagarikta_Jilla,
                    Nagarikta_miti   = ab.Nagarikta_miti,
                    Pradesh          = ab.Pradesh,
                    Jilla            = ab.Jilla,
                    Gabisa           = ab.Gabisa,
                    Ward             = ab.Ward,
                    Sabik_thegana    = ab.Sabik_thegana,
                    Basobas_miti     = ab.Basobas_miti,
                    Ghardhaniko_naam = ab.Ghardhaniko_naam,
                    Ghar_no          = ab.Ghar_no,
                    Tole             = ab.Tole,
                    Batoko_naam      = ab.Batoko_naam
                };
                context.Asthayi_Basobas.Add(user);

                context.SaveChanges();
                message = "save successfull";
            }
            return(message);
        }
コード例 #14
0
        //Aabedan Biwaran

        public List <GharkayamList> GetSelfList(string loginId)
        {
            using (var context = new Entities2())
            {
                var           lgId         = Convert.ToInt32(loginId);
                var           selfData     = context.Ghar_kayamko_sifaris /*.Where(x => x.FormId == lgId)*/.ToList();
                GharkayamList Lastlistobj  = null;
                var           dataInfoList = new List <GharkayamList>();

                foreach (var lbd in selfData)
                {
                    Lastlistobj = new GharkayamList
                    {
                        FormId               = lbd.FormId,
                        Aabedan_miti         = lbd.Aabedan_miti,
                        Aabedak_name         = lbd.Aabedak_name,
                        Pradesh              = lbd.Pradesh,
                        Jilla                = lbd.Jilla,
                        Gabisa               = lbd.Gabisa,
                        Ward                 = lbd.Ward,
                        Gajjako_sabikthegana = lbd.Gajjako_sabikthegana,
                        Naksa_sheetno        = lbd.Naksa_sheetno,
                        Kitta_no             = lbd.Kitta_no,
                        Bigga                = lbd.Bigga,
                        Kattha               = lbd.Kattha,
                        Dhur                 = lbd.Dhur,
                        Ghar_no              = lbd.Ghar_no,
                        Gharko_prakaar       = lbd.Gharko_prakaar,
                        Gharnirmaan_saal     = lbd.Gharnirmaan_saal
                    };
                    dataInfoList.Add(Lastlistobj);
                }
                return(dataInfoList);
            }
        }
コード例 #15
0
        //Kittakat Sifaris
        //saving Kittakat Sifaris

        public string SaveKittakatsifaris(Kittakat_Sifaris ks)
        {
            var message = "";

            using (var context = new Entities2())
            {
                var user = new Kittakat_Sifaris()
                {
                    Aabedan_miti       = ks.Aabedan_miti,
                    Jagga_Dhaniko_Naam = ks.Jagga_Dhaniko_Naam,
                    Chetrafal          = ks.Chetrafal,
                    Pradesh            = ks.Pradesh,
                    Jilla                 = ks.Jilla,
                    Gabisa                = ks.Gabisa,
                    Ward                  = ks.Ward,
                    Sabik_thegana         = ks.Sabik_thegana,
                    Disa                  = ks.Disa,
                    Bigga                 = ks.Bigga,
                    Kattha                = ks.Kattha,
                    Dhur                  = ks.Dhur,
                    Sheet_no              = ks.Sheet_no,
                    Kitta_no              = ks.Kitta_no,
                    Jamma_chetrafal       = ks.Jamma_chetrafal,
                    Bhui_talako_chetrafal = ks.Bhui_talako_chetrafal,
                    Paune_faar            = ks.Paune_faar,
                    Karan                 = ks.Karan,
                    Prabidhik_naam        = ks.Prabidhik_naam
                };
                context.Kittakat_Sifaris.Add(user);

                context.SaveChanges();
                message = "save successfull";
            }
            return(message);
        }
コード例 #16
0
        //View Bato Kayam
        public List <GharkayamList> GetBatokayamList(string loginId)
        {
            using (var context = new Entities2())
            {
                var           lgId         = Convert.ToInt32(loginId);
                var           selfData     = context.Bato_Kayam.Where(x => x.FormId == lgId).ToList();
                GharkayamList Lastlistobj  = null;
                var           dataInfoList = new List <GharkayamList>();

                foreach (var bkm in selfData)
                {
                    Lastlistobj = new GharkayamList
                    {
                        FormId           = bkm.FormId,
                        Aabedan_miti     = bkm.Aabedan_miti,
                        Jaggadhanikonaam = bkm.Jagga_Dhaniko_Naam,
                        Kitta_no         = bkm.Kitta_no,
                        Bigga            = bkm.Bigga,
                        Kattha           = bkm.Kattha,
                        Dhur             = bkm.Dhur,
                        Pradesh          = bkm.Pradesh,
                        Jilla            = bkm.Jilla,
                        Gabisa           = bkm.Gabisa,
                        Ward             = bkm.Ward,
                        Sabikthegana     = bkm.sabik_thegana,
                        Batodisa         = bkm.Bato_Disa,
                        Sadaklambai      = bkm.Sadak_Lambai,
                        Sadakchaudai     = bkm.Sadak_Chaudai
                    };
                    dataInfoList.Add(Lastlistobj);
                }
                return(dataInfoList);
            }
        }
コード例 #17
0
        public ActionResult Editar_Sala(ListTablaViewModelSalaJuntas model)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    using (Entities2 db = new Entities2())
                    {
                        var oTablas = db.SalaJuntas.Find(model.IdSala);
                        oTablas.Sala           = model.Sala;
                        oTablas.NombreEmpleado = model.NombreEmpleado;
                        oTablas.FechaRecepcion = model.FechaRecepcion;
                        oTablas.TotalPersonas  = model.TotalPersonas;
                        oTablas.Horas          = model.Horas;

                        db.Entry(oTablas).State = System.Data.Entity.EntityState.Modified;
                        db.SaveChanges();
                    }
                    return(Redirect("~/TablaJuntas/Index_Sala"));
                }
                return(View(model));
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
コード例 #18
0
        //Ghar sifarisko Bibaran
        //Saving Ghar sifarisko Bibaran
        public string SaveGharkayamkosifaris(Ghar_kayamko_sifaris gks)
        {
            var message = "";

            using (var context = new Entities2())
            {
                var user = new Ghar_kayamko_sifaris()
                {
                    Aabedan_miti         = gks.Aabedan_miti,
                    karyalaya            = gks.karyalaya,
                    Aabedak_name         = gks.Aabedak_name,
                    Pradesh              = gks.Pradesh,
                    Jilla                = gks.Jilla,
                    Gabisa               = gks.Gabisa,
                    Ward                 = gks.Ward,
                    Gajjako_sabikthegana = gks.Gajjako_sabikthegana,
                    Naksa_sheetno        = gks.Naksa_sheetno,
                    Kitta_no             = gks.Kitta_no,
                    Bigga                = gks.Bigga,
                    Kattha               = gks.Kattha,
                    Dhur                 = gks.Dhur,
                    Ghar_no              = gks.Ghar_no,
                    Gharko_prakaar       = gks.Gharko_prakaar,
                    Gharnirmaan_saal     = gks.Gharnirmaan_saal
                };
                context.Ghar_kayamko_sifaris.Add(user);

                context.SaveChanges();
                message = "save successfull";
            }
            return(message);
        }
コード例 #19
0
        //saving Bato Kayam
        public string SaveBatokayam(Bato_Kayam bkm)
        {
            var message = "";

            using (var context = new Entities2())
            {
                var user = new Bato_Kayam()
                {
                    Aabedan_miti       = bkm.Aabedan_miti,
                    Jagga_Dhaniko_Naam = bkm.Jagga_Dhaniko_Naam,
                    Kitta_no           = bkm.Kitta_no,
                    Bigga         = bkm.Bigga,
                    Kattha        = bkm.Kattha,
                    Dhur          = bkm.Dhur,
                    Pradesh       = bkm.Pradesh,
                    Jilla         = bkm.Jilla,
                    Gabisa        = bkm.Gabisa,
                    Ward          = bkm.Ward,
                    sabik_thegana = bkm.sabik_thegana,
                    Bato_Disa     = bkm.Bato_Disa,
                    Sadak_Lambai  = bkm.Sadak_Lambai,
                    Sadak_Chaudai = bkm.Sadak_Chaudai
                };
                context.Bato_Kayam.Add(user);

                context.SaveChanges();
                message = "save successfull";
            }
            return(message);
        }
コード例 #20
0
        public ActionResult Nueva_Sala(ListTablaViewModelSalaJuntas model)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    using (Entities2 db = new Entities2())
                    {
                        var oTablas = new SalaJuntas();
                        oTablas.Sala           = model.Sala;
                        oTablas.NombreEmpleado = model.NombreEmpleado;
                        oTablas.FechaRecepcion = model.FechaRecepcion;
                        oTablas.TotalPersonas  = model.TotalPersonas;
                        oTablas.Horas          = model.Horas;

                        db.SalaJuntas.Add(oTablas);
                        db.SaveChanges();
                    }
                    return(Redirect("~/TablaJuntas/Index_Sala"));
                }
                return(View(model));
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
コード例 #21
0
        //saving Mohi Lagat Katta
        public string SaveMohilagatkatta(Mohi_Lagat_Katta mlk)
        {
            var message = "";

            using (var context = new Entities2())
            {
                var user = new Mohi_Lagat_Katta()
                {
                    Aabedan_miti      = mlk.Aabedan_miti,
                    Jaggadhaniko_naam = mlk.Jaggadhaniko_naam,
                    Mohiko_naam       = mlk.Mohiko_naam,
                    Kitta_no          = mlk.Kitta_no,
                    Sheet_no          = mlk.Sheet_no,
                    Bigga             = mlk.Bigga,
                    Kattha            = mlk.Kattha,
                    Dhur          = mlk.Dhur,
                    Pradesh       = mlk.Pradesh,
                    Jilla         = mlk.Jilla,
                    Gabisa        = mlk.Gabisa,
                    Ward          = mlk.Ward,
                    Sabik_thegana = mlk.Sabik_thegana,
                    Sarjamin_miti = mlk.Sarjamin_miti
                };
                context.Mohi_Lagat_Katta.Add(user);

                context.SaveChanges();
                message = "save successfull";
            }
            return(message);
        }
コード例 #22
0
        //View Mohi Lagat Katta
        public List <GharkayamList> GetMohilagatkattaList(string loginId)
        {
            using (var context = new Entities2())
            {
                var           lgId         = Convert.ToInt32(loginId);
                var           selfData     = context.Mohi_Lagat_Katta.Where(x => x.Form_Id == lgId).ToList();
                GharkayamList Lastlistobj  = null;
                var           dataInfoList = new List <GharkayamList>();

                foreach (var mlk in selfData)
                {
                    Lastlistobj = new GharkayamList
                    {
                        FormId           = mlk.Form_Id,
                        Aabedan_miti     = mlk.Aabedan_miti,
                        Jaggadhanikonaam = mlk.Jaggadhaniko_naam,
                        Mohikonaam       = mlk.Mohiko_naam,
                        Kitta_no         = mlk.Kitta_no,
                        Sheetno          = mlk.Sheet_no,
                        Bigga            = mlk.Bigga,
                        Kattha           = mlk.Kattha,
                        Dhur             = mlk.Dhur,
                        Pradesh          = mlk.Pradesh,
                        Jilla            = mlk.Jilla,
                        Gabisa           = mlk.Gabisa,
                        Ward             = mlk.Ward,
                        Sabikthegana     = mlk.Sabik_thegana,
                        Sarjaminmiti     = mlk.Sarjamin_miti
                    };
                    dataInfoList.Add(Lastlistobj);
                }
                return(dataInfoList);
            }
        }
コード例 #23
0
        //saving Jagga Ghar Kayam
        public string SaveJaggagharkayam(Jagga_Ghar_Kayam jgk)
        {
            var message = "";

            using (var context = new Entities2())
            {
                var user = new Jagga_Ghar_Kayam()
                {
                    Aabedan_miti  = jgk.Aabedan_miti,
                    Aabedak_naam  = jgk.Aabedak_naam,
                    Bigga         = jgk.Bigga,
                    Kattha        = jgk.Kattha,
                    Dhur          = jgk.Dhur,
                    Pradesh       = jgk.Pradesh,
                    Jilla         = jgk.Jilla,
                    Gabisa        = jgk.Gabisa,
                    Ward          = jgk.Ward,
                    sabik_thegana = jgk.sabik_thegana,
                    Kitta_no      = jgk.Kitta_no
                };
                context.Jagga_Ghar_Kayam.Add(user);

                context.SaveChanges();
                message = "save successfull";
            }
            return(message);
        }
コード例 #24
0
        //View Jagga Ghar Kayam
        public List <GharkayamList> GetJaggagharkayamList(string loginId)
        {
            using (var context = new Entities2())
            {
                var           lgId         = Convert.ToInt32(loginId);
                var           selfData     = context.Jagga_Ghar_Kayam.Where(x => x.FormId == lgId).ToList();
                GharkayamList Lastlistobj  = null;
                var           dataInfoList = new List <GharkayamList>();

                foreach (var jgk in selfData)
                {
                    Lastlistobj = new GharkayamList
                    {
                        FormId       = jgk.FormId,
                        Aabedan_miti = jgk.Aabedan_miti,
                        Aabedak_name = jgk.Aabedak_naam,
                        Bigga        = jgk.Bigga,
                        Kattha       = jgk.Kattha,
                        Dhur         = jgk.Dhur,
                        Pradesh      = jgk.Pradesh,
                        Jilla        = jgk.Jilla,
                        Gabisa       = jgk.Gabisa,
                        Ward         = jgk.Ward,
                        Sabikthegana = jgk.sabik_thegana,
                        Kitta_no     = jgk.Kitta_no
                    };
                    dataInfoList.Add(Lastlistobj);
                }
                return(dataInfoList);
            }
        }
コード例 #25
0
ファイル: invoicesController.cs プロジェクト: moebrahim/myway
        public IHttpActionResult getinvoices(string id)
        {
            List <INVOICE_Result> pendinglist = new List <INVOICE_Result>();
            var test    = new Entities2();
            var reslist = test.INVOICE(id).ToList();

            foreach (var pen in reslist.ToList())
            {
                pendinglist.Add(
                    new INVOICE_Result
                {
                    DOC_ID    = pen.DOC_ID,
                    ITEM_ID   = pen.ITEM_ID,
                    ANAME     = pen.ANAME,
                    COUNTER   = pen.COUNTER,
                    QTY       = pen.QTY,
                    PRICE     = pen.PRICE,
                    NET_TOTAL = pen.NET_TOTAL,
                    ITEM_BP   = pen.ITEM_BP,
                    TOTAL_BP  = pen.TOTAL_BP,
                    DOC_DATE  = pen.DOC_DATE
                }
                    );
            }
            return(Ok(pendinglist));
        }
コード例 #26
0
        //Edit Aabedan Biwaran
        public string UpdateData(Ghar_kayamko_sifaris bd, string loginId)
        {
            var message = "";

            using (var context = new Entities2())
            {
                var decId        = Convert.ToDecimal(loginId);
                var dataToUpdate = context.Ghar_kayamko_sifaris.Where(x => x.FormId == decId).FirstOrDefault();
                dataToUpdate.Aabedan_miti         = bd.Aabedan_miti;
                dataToUpdate.karyalaya            = bd.karyalaya;
                dataToUpdate.Aabedak_name         = bd.Aabedak_name;
                dataToUpdate.Pradesh              = bd.Pradesh;
                dataToUpdate.Jilla                = bd.Jilla;
                dataToUpdate.Gabisa               = bd.Gabisa;
                dataToUpdate.Ward                 = bd.Ward;
                dataToUpdate.Gajjako_sabikthegana = bd.Gajjako_sabikthegana;
                dataToUpdate.Naksa_sheetno        = bd.Naksa_sheetno;
                dataToUpdate.Kitta_no             = bd.Kitta_no;
                dataToUpdate.Bigga                = bd.Bigga;
                dataToUpdate.Kattha               = bd.Kattha;
                dataToUpdate.Dhur                 = bd.Dhur;
                dataToUpdate.Ghar_no              = bd.Ghar_no;
                dataToUpdate.Gharko_prakaar       = bd.Gharko_prakaar;
                dataToUpdate.Gharnirmaan_saal     = bd.Gharnirmaan_saal;

                context.SaveChanges();
                message = "Update successfull";
            }
            return(message);
        }
コード例 #27
0
        //व्यवसाय बन्द बारे
        //Saving व्यवसाय बन्द बारे
        public string SaveByawasayabanda(Byawasaya_Banda_Barey bd)
        {
            var message = "";

            using (var context = new Entities2())
            {
                var user = new Byawasaya_Banda_Barey()
                {
                    Aabedan_miti        = bd.Aabedan_miti,
                    Byawasaya_naam      = bd.Byawasaya_naam,
                    Byawasayi_naam      = bd.Byawasayi_naam,
                    Darta_no            = bd.Darta_no,
                    Prakaar             = bd.Prakaar,
                    Prakriti            = bd.Prakriti,
                    Pradesh             = bd.Pradesh,
                    Jilla               = bd.Jilla,
                    Gabisa              = bd.Gabisa,
                    Ward                = bd.Ward,
                    Sabik_thegana       = bd.Sabik_thegana,
                    Haal_thegana        = bd.Haal_thegana,
                    Toleko_naam         = bd.Toleko_naam,
                    Batoko_naam         = bd.Batoko_naam,
                    Gharno              = bd.Gharno,
                    Byawasaya_Bandamiti = bd.Byawasaya_Bandamiti,
                    Sarjamin_miti       = bd.Sarjamin_miti,
                    ImagePath           = bd.ImagePath
                };
                context.Byawasaya_Banda_Barey.Add(user);

                context.SaveChanges();
                message = "save successfull";
            }
            return(message);
        }
コード例 #28
0
        public ActionResult Drawings()
        {
            Entities2 db         = new Entities2();
            var       user       = db.AspNetUsers.Find(User.Identity.GetUserId());
            var       imagesList = user.Images.ToList();

            return(View(imagesList));
        }
コード例 #29
0
        public ActionResult Delete(int id)
        {
            Entities2 db  = new Entities2();
            Images    img = db.Images.Find(id);

            db.Images.Remove(img);
            db.SaveChanges();
            return(RedirectToAction("Drawings"));
        }
コード例 #30
0
        public ActionResult Update()
        {
            Entities2 entities2 = new Entities2();
            //_list = _list.OrderBy(c => c.ID).Skip(int.Parse(LastPageSize)).Take(PageSize).ToList();
            //var m = (from temp in entities.AAAs where temp.ID == a.ID select temp).
            List <CUSTOMER> list = entities2.CUSTOMERs.ToList();

            return(View(list));
        }
コード例 #31
0
 public void Perform(Action execute)
 {
     using (var ctx = new Entities2())
     {
         AddToPool(ctx);
         try
         {
             execute();
             ctx.SaveChanges(); //No commit if Exception.
         }
         finally
         {
             RemoveFromPool();
         }
     }
 }
コード例 #32
0
 private void AddToPool(Entities2 ctx)
 {
     _pool.TryAdd(Key, ctx);
 }