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);
}
}
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);
}
}
//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);
}
}
//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);
}
}
/// <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;
}
//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);
}
//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);
}
}
//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);
}
}
//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);
}
//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);
}
//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);
}
}
public ActionResult Showcase()
{
Entities2 db = new Entities2();
var imagesList = (from img in db.Images select img).ToList();
return(View(imagesList));
}
//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);
}
//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);
}
}
//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);
}
//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);
}
}
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);
}
}
//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);
}
//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);
}
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);
}
}
//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);
}
//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);
}
}
//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);
}
//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);
}
}
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));
}
//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);
}
//व्यवसाय बन्द बारे
//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);
}
public ActionResult Drawings()
{
Entities2 db = new Entities2();
var user = db.AspNetUsers.Find(User.Identity.GetUserId());
var imagesList = user.Images.ToList();
return(View(imagesList));
}
public ActionResult Delete(int id)
{
Entities2 db = new Entities2();
Images img = db.Images.Find(id);
db.Images.Remove(img);
db.SaveChanges();
return(RedirectToAction("Drawings"));
}
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));
}
public void Perform(Action execute)
{
using (var ctx = new Entities2())
{
AddToPool(ctx);
try
{
execute();
ctx.SaveChanges(); //No commit if Exception.
}
finally
{
RemoveFromPool();
}
}
}
private void AddToPool(Entities2 ctx)
{
_pool.TryAdd(Key, ctx);
}