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