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;
}
