public string updatedelete(string id, string obj) { string rs = ""; datacontext db = new datacontext(); string table = ""; if (obj == "customer") { table = "customer"; } else if (obj == "ItemList") { table = "ItemList"; } else if (obj == "house") { table = "warehouse"; } else if (obj == "employer") { table = "employee"; } rs = db.updatecolumndelete(id, table); return(rs); }
public string savadata_sale_ship(string jsonbill, string jsondetail, string codeid) { common cm = new common(); datacontext db = new datacontext(); int status = -1; if (codeid == "") { codeid = cm.getcodeId("order"); } else { status = 1; } List <string> strbill = db.orderbill_str(jsonbill, codeid, status); List <string> strdetail = db.detailorder_str(jsondetail, codeid, status); List <string> lw = new List <string>(); lw.AddRange(strbill); lw.AddRange(strdetail); sql sql = new sql(); sql.Executesql(string.Join(";", lw)); return(""); }
public ActionResult Haber(int id) { datacontext db = new datacontext(); ortakmodel nesne = new ortakmodel(); NewsFinder news = new NewsFinder(); try { if (news.getnew(id).icerik != "") { } } catch (Exception) { return(RedirectToAction("Index")); } if (news.getnew(id).icerik != "") { ViewData["oncehaberler"] = db.haberler.Where(p => p.id < id).OrderByDescending(p => p.id).Take(4).ToList(); ViewData["sonrahaberler"] = db.haberler.Where(p => p.id > id).OrderBy(p => p.id).Take(4).ToList(); ViewData["ilkhaberler"] = db.haberler.OrderBy(p => p.id).Skip(1).Take(4).ToList(); ViewData["sonhaberler"] = db.haberler.OrderBy(p => p.id).Skip(1).Take(4).ToList(); return(View(news.getnew(id))); } else { return(RedirectToAction("Index")); } }
public string savadatabill_ship(string jsondetail, string codebill, string inforbill) { common cm = new common(); datacontext db = new datacontext(); List <string> lw = db.ship_STR(jsondetail, codebill, inforbill); sql sql = new sql(); sql.Executesql(string.Join(";", lw)); return(""); }
public string ExportExcel(string json, string obj, string id) { string rs = ""; datacontext db = new datacontext(); if (obj == "customer") { rs = db.customer(json, int.Parse(id)); } return(rs); }
public EnrollmentController(datacontext context, IHostingEnvironment env) { _context = context; _env = env; }
public ValuesController(datacontext context) { _context = context; }
public EnrollmentApiController(datacontext context) { _context = context; }
public CourseApiController(datacontext context) { _context = context; }
public BibliotecasController(datacontext context) { _context = context; }
public StudentApiController(datacontext context) { _context = context; }
public StudentController(datacontext context, IWebHostEnvironment hostEnvironment) { _context = context; webHostEnvironment = hostEnvironment; }
public TeacherController(datacontext context, IWebHostEnvironment hostEnvironment) { _context = context; webHostEnvironment = hostEnvironment; }
public string savadata(string json, string obj, string id) { string rs = ""; datacontext db = new datacontext(); if (obj == "customer") { rs = db.customer(json, int.Parse(id)); } else if (obj == "styleitem") { rs = db.styleItem(json, int.Parse(id)); } else if (obj == "standard") { rs = db.standards(json, int.Parse(id)); } else if (obj == "itemlist") { rs = db.itemlist(json, int.Parse(id)); } else if (obj == "house") { rs = db.warehouse(json, int.Parse(id)); } else if (obj == "employer") { rs = db.employee(json, int.Parse(id)); } else if (obj == "billbuy") { rs = db.buybill(json, id); } else if (obj == "detailbuy") { rs = db.detailbuybill(json, id); } else if (obj == "subdetailbuybill") { rs = db.subdetailbuybill(json, id); } else if (obj == "ship") { rs = db.ship(json, id); } else if (obj == "subship") { rs = db.subship(json, int.Parse(id)); } else if (obj == "payment") { rs = db.payment(json, id); } else if (obj == "editpayment") { rs = db.editpayment(json, id); } else if (obj == "paymentorder") { rs = db.paymentorder(json, id); } else if (obj == "orderbill") { rs = db.orderbill(json, id); } else if (obj == "carship") { rs = db.carship(json, id); } else if (obj == "Editcarship") { rs = db.Editcarship(json, id); } else if (obj == "detailorder") { rs = db.detailorder(json, id); } else if (obj == "serienumber") { rs = db.serinumber(json, id); } else if (obj == "inspection") { rs = db.inspection(json, id); } else if (obj == "plans") { rs = db.plans(json, id); } else if (obj == "changehouse") { rs = db.changehouse(json, id); } else if (obj == "detailchange") { rs = db.detailchange(json, id); } else if (obj == "TableErorr") { rs = db.tberorr(json, id); } else if (obj == "Table_qlt_erorr") { rs = db.table_detail_erorr_qlt(json, id); } else if (obj == "up_Table_qlt_erorr") { rs = db.update_table_detail_erorr_qlt(json, id); } return(rs); }
public haber getnew(int id1) { datacontext db = new datacontext(); return(db.haberler.Where(p => p.id == id1).FirstOrDefault <haber>()); }
public ActionResult Index(int page, string category) { datacontext db = new datacontext(); ortakmodel nesne = new ortakmodel(); if (category.ToLower() == "siyaset") { if (page < 1) { page = 1; } if (page > (db.haberler.Where(q => q.konu == "Siyaset").ToList().Count() / 14) + 1) { page = (db.haberler.Where(q => q.konu == "Siyaset").ToList().Count() / 14) + 1; } Element eleme = new Element(); int element = (page * 14) - 14; try { nesne.haber = db.haberler.Where(q => q.konu == "Siyaset").OrderByDescending(p => p.id).Skip(element).Take(14).ToList(); } catch (Exception) { nesne.haber = db.haberler.Where(q => q.konu == "Siyaset").OrderByDescending(p => p.id).Take(14).ToList(); // RedirectToAction("Index", beforePage.beforeIndexpage); } ViewData["Category"] = "Siyaset"; ViewData["Pagenum"] = eleme.Pagelist(page, db.haberler.Where(q => q.konu == "Siyaset").ToList().Count()); return(View(nesne)); } if (category.ToLower() == "spor") { if (page < 1) { page = 1; } if (page > (db.haberler.Where(q => q.konu == "Spor").ToList().Count() / 14) + 1) { page = (db.haberler.Where(q => q.konu == "Spor").ToList().Count() / 14) + 1; } Element eleme = new Element(); int element = (page * 14) - 14; try { nesne.haber = db.haberler.Where(q => q.konu == "Spor").OrderByDescending(p => p.id).Skip(element).Take(14).ToList(); } catch (Exception) { nesne.haber = db.haberler.Where(q => q.konu == "Spor").OrderByDescending(p => p.id).Take(14).ToList(); // RedirectToAction("Index", beforePage.beforeIndexpage); } ViewData["Category"] = "Spor"; ViewData["Pagenum"] = eleme.Pagelist(page, db.haberler.Where(q => q.konu == "Spor").ToList().Count()); return(View(nesne)); } if (category.ToLower() == "para") { if (page < 1) { page = 1; } if (page > (db.haberler.Where(q => q.konu == "Para").ToList().Count() / 14) + 1) { page = (db.haberler.Where(q => q.konu == "Para").ToList().Count() / 14) + 1; } Element eleme = new Element(); int element = (page * 14) - 14; try { nesne.haber = db.haberler.Where(q => q.konu == "Para").OrderByDescending(p => p.id).Skip(element).Take(14).ToList(); } catch (Exception) { nesne.haber = db.haberler.Where(q => q.konu == "Para").OrderByDescending(p => p.id).Take(14).ToList(); // RedirectToAction("Index", beforePage.beforeIndexpage); } ViewData["Category"] = "Para"; ViewData["Pagenum"] = eleme.Pagelist(page, db.haberler.Where(q => q.konu == "Para").ToList().Count()); return(View(nesne)); } if (category.ToLower() == "farkli") { if (page < 1) { page = 1; } if (page > (db.haberler.Where(q => q.konu == "Farklı").ToList().Count() / 14) + 1) { page = (db.haberler.Where(q => q.konu == "Farklı").ToList().Count() / 14) + 1; } Element eleme = new Element(); int element = (page * 14) - 14; try { nesne.haber = db.haberler.Where(q => q.konu == "Farklı").OrderByDescending(p => p.id).Skip(element).Take(14).ToList(); } catch (Exception) { nesne.haber = db.haberler.Where(q => q.konu == "Farklı").OrderByDescending(p => p.id).Take(14).ToList(); // RedirectToAction("Index", beforePage.beforeIndexpage); } ViewData["Category"] = "Farkli"; ViewData["Pagenum"] = eleme.Pagelist(page, db.haberler.Where(q => q.konu == "Farklı").ToList().Count()); return(View(nesne)); } else { if (page < 1) { page = 1; } if (page > (db.haberler.ToList().Count() / 14) + 1) { page = (db.haberler.ToList().Count() / 14) + 1; } Element eleme = new Element(); int element = (page * 14) - 14; try { nesne.haber = db.haberler.OrderByDescending(p => p.id).Skip(element).Take(14).ToList(); } catch (Exception) { nesne.haber = db.haberler.OrderByDescending(p => p.id).Take(14).ToList(); // RedirectToAction("Index", beforePage.beforeIndexpage); } ViewData["Category"] = "hepsi"; ViewData["Pagenum"] = eleme.Pagelist(page, db.haberler.ToList().Count()); return(View(nesne)); } }
public TeacherApiController(datacontext context) { _context = context; }
public MarcasController(datacontext context) { _context = context; }
public CarrosController(datacontext context) { _context = context; }