public JsonResult GetOzelTuzelSahis(string vergiNo) { IGumruk iGumruk = new BSGumruk(); OzelTuzelSahis sahis = iGumruk.GetOzelTuzelSahisByVergiNo(vergiNo); return(Json(sahis, JsonRequestBehavior.AllowGet)); }
public JsonResult GetTasitBilgileri(int ID) { IGumruk iGumruk = new BSGumruk(); TasitBilgileri tst = iGumruk.GetTasitBilgileriByID(ID); return(Json(tst, JsonRequestBehavior.AllowGet)); }
public JsonResult GetBeyanSahibi(int ID) { IGumruk iGumruk = new BSGumruk(); OzelTuzelSahis shs = iGumruk.GetTasiyiciFirma(ID); return(Json(shs, JsonRequestBehavior.AllowGet)); }
public ActionResult GetKimlikTurleri() { IGumruk iGumruk = new BSGumruk(); List <KimlikTurleri> kimlikler = iGumruk.GetKimlikTurleri(); return(Json(kimlikler, JsonRequestBehavior.AllowGet)); }
public ActionResult GetLimanlar(int ulkeID) { IGumruk iGumruk = new BSGumruk(); List <Limanlar> limanlar = iGumruk.GetLimanlarByUlkeId(ulkeID); return(Json(limanlar, JsonRequestBehavior.AllowGet)); }
public JsonResult GetUlkeler() { IGumruk iGumruk = new BSGumruk(); List <Ulkeler> ulkeler = iGumruk.GetUlkeler(); return(Json(ulkeler, JsonRequestBehavior.AllowGet)); }
public JsonResult GetTableExplanations(double tableID) { IGumruk _iGumruk = new BSGumruk(); int tblID = (int)(tableID / 0.123123); List <d_b_table_explanation> listExps = _iGumruk.GetTableExplanationsByTableID(tblID); List <ColumnDetails> response = new List <ColumnDetails>(); foreach (var item in listExps) { ColumnDetails clmDetails = new ColumnDetails() { Date = item.created_at.ToString(), explanation = item.details, User = item.users.name, ExpID = item.id }; response.Add(clmDetails); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult GetTableById(double tableID) { IGumruk _iGumruk = new BSGumruk(); int tblID = (int)(tableID / 0.123123); d_b_tables dbTable = _iGumruk.GetTableById(tblID); //string json = JsonConvert.SerializeObject(schemas); TableProperties dt = new Models.TableProperties() { TableName = dbTable.name, SchemaName = dbTable.d_b_schemas.name, ColumnCount = dbTable.d_b_columns.Count, SchemaID = dbTable.d_b_schemasId, }; foreach (var item2 in dbTable.d_b_columns) { foreach (var item3 in item2.d_b_column_lookups) { item3.d_b_Column_to = _iGumruk.GetColumnById(item3.column_to_id); dt.RelatedTables = dt.RelatedTables + " " + item3.d_b_Column_to.d_b_tables.d_b_schemas.name + "." + item3.d_b_Column_to.d_b_tables.name + "." + item3.d_b_Column_to.name; } } return(Json(dt, JsonRequestBehavior.AllowGet)); }
public JsonResult BeyanTurleri() { IGumruk iGumruk = new BSGumruk(); List <BeyanTurleri> beyanturleri = iGumruk.GetBeyanTurleri(); return(Json(beyanturleri, JsonRequestBehavior.AllowGet)); }
public ActionResult ProceduresAddComment(string comment, int procedureID, string position, string sqlText) { IGumruk iGumruk = new BSGumruk(); int? pos = null; if (position != "") { pos = int.Parse(position); } SQLProceduresComments prosComment = new SQLProceduresComments() { created_at = DateTime.Now, updated_at = DateTime.Now, Details = comment, userID = GetCurrentUser().id, SQLProceduresID = procedureID, user = GetCurrentUser(), position = pos, }; iGumruk.AddSQLProcedureComment(prosComment, pos, sqlText); return(PartialView("ProceduresCommentList", iGumruk.GetSQLProcedureComments(procedureID))); }
public JsonResult SaveUser(users _user) { IGumruk igumruk = new BSGumruk(); users user = igumruk.SaveUser(_user); return(Json(user, JsonRequestBehavior.AllowGet)); }
public JsonResult GumrukIdareleri() { IGumruk iGumruk = new BSGumruk(); List <GumrukIdareleri> idareler = iGumruk.GetGumrukIdareleri(); return(Json(idareler, JsonRequestBehavior.AllowGet)); }
public ActionResult ModulesFiles(int ModuleID) { IGumruk igumruk = new BSGumruk(); List <ModulesFiles> model = igumruk.GetModulesFiles(ModuleID); return(PartialView("SubModulesFiles", model)); }
public JsonResult GetProcedures() { IGumruk iGumruk = new BSGumruk(); List <SQLProcedures> pros = iGumruk.GetAllProcedures("A", 1); return(Json(pros, JsonRequestBehavior.AllowGet)); }
public JsonResult GetProcedureByID(int id, string TXT) { IGumruk iGumruk = new BSGumruk(); SQLProcedures pros = iGumruk.GetSQLProcedure(id); return(Json(pros, JsonRequestBehavior.AllowGet)); }
public ActionResult GetTablePropertiesByNameSchemaName(string tableName, string schemaName) { IGumruk _iGumruk = new BSGumruk(); d_b_tables dbTable = _iGumruk.GetTableByNameSchemaName(tableName, schemaName); return(PartialView("../Home/Table", dbTable)); }
public void DeleteExp(int ExpID, int ColumnID) { IGumruk iGumruk = new BSGumruk(); iGumruk.DeleteExp(ExpID); GetDetails(ColumnID); }
public ActionResult GetFileTables(int FileID) { IGumruk igumruk = new BSGumruk(); List <ModulesTables> sqlModules = igumruk.GetModulesTablesByFileD(FileID); return(PartialView("GetSubModulesTables", sqlModules)); }
public ActionResult GetSQLProcedureModules(int procedureID) { IGumruk igumruk = new BSGumruk(); List <SQLProcedureModules> model = igumruk.GetSQLProcedureModules(procedureID); return(PartialView("GetSQLProcedureProperties", model)); }
// // GET: /Modules/ public ActionResult Index() { IGumruk igumruk = new BSGumruk(); List <Modules> modules = igumruk.GetModules(); return(View("ModuleMainPage", modules)); }
public ActionResult GetTablesModules(int ID) { IGumruk _iGumruk = new BSGumruk(); d_b_tables dbTable = _iGumruk.GetTableById(ID); return(PartialView("TableModules", dbTable.Modules)); }
public void DeleteTableExp(int ExpID, double tableID) { IGumruk iGumruk = new BSGumruk(); iGumruk.DeleteTableExp(ExpID); GetTableExplanations(tableID); }
public ActionResult GetModulesSPs(int ModuleID) { IGumruk igumruk = new BSGumruk(); List <SQLProcedureModules> sqlModules = igumruk.GetSQLProcedureModulesByModuleID(ModuleID); return(PartialView("GetSubModulesSPs", sqlModules)); }
public JsonResult GetProcedureID(string name, string schemaName) { IGumruk iGumruk = new BSGumruk(); SQLProcedures proc = iGumruk.GetProcedureByNameSchemaName(name, schemaName); return(Json(proc, JsonRequestBehavior.AllowGet)); }
public ActionResult GetSubModulesTables(int subModuleID) { IGumruk igumruk = new BSGumruk(); List <ModulesTables> sqlModules = igumruk.GetModulesTablesBySubModuleID(subModuleID); return(PartialView(sqlModules)); }
public ActionResult GetProceduresChildsByID(string procedureName) { IGumruk iGumruk = new BSGumruk(); DBObjects obj = iGumruk.GetDBObjectByID(procedureName); return(PartialView("DBObject", obj)); }
public ActionResult GetInnerModulesByModID(int ID) { IGumruk igumruk = new BSGumruk(); List <InnerModule> innMods = igumruk.GetInnerModule(ID); return(PartialView("InnerModules", innMods)); }
public JsonResult GetLookUps(int ColumnID) { IGumruk iGumruk = new BSGumruk(); List <LookUpModel> lookups = iGumruk.GetLookupModels(ColumnID); return(Json(lookups, JsonRequestBehavior.AllowGet)); }
public ActionResult SubModulesFiles(int subModuleID) { IGumruk igumruk = new BSGumruk(); List <ModulesFiles> model = igumruk.GetSubModulesFiles(subModuleID).OrderBy(p => p.Name).ToList(); return(PartialView(model)); }
public ActionResult DeleteComment(int ID, int procedureID) { IGumruk iGumruk = new BSGumruk(); iGumruk.deleteSQlProcedureComment(ID); return(PartialView("ProceduresCommentList", iGumruk.GetSQLProcedureComments(procedureID))); }