private IDBTable UserDetail(IDBSchema sch) { var rev = new DBRevision(new DateTime(2019, 9, 9), 0, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("UserDetail", sch, rev); ret.AddConstraint(new DBForeignKeyConstraintDescriptor(new List <string>() { "ID" }, "Common.Principal", new List <string>() { "ID" }), new DBRevision(rev)); ret.AddField("Username", new DBFieldDescriptor() { FieldType = new DBFieldTypeNvarchar(), Size = 512, Nullable = false }, new DBRevision(rev)); ret.AddConstraint(new DBUniqueConstraintDescriptor("Username"), new DBRevision(rev)); ret.AddField("Email", new DBFieldDescriptor() { FieldType = new DBFieldTypeNvarchar(), Size = 512, Nullable = false }, new DBRevision(rev)); var fldFullName = ret.AddField("Fullname", new DBFieldDescriptor() { FieldType = new DBFieldTypeNvarchar(), Size = 512, Nullable = false }, new DBRevision(rev)); fldFullName.AddRevision(new DBRevision(new DateTime(2019, 10, 10), 0, eDBRevisionType.Delete)); ret.AddField("FirstName", new DBFieldDescriptor() { FieldType = new DBFieldTypeNvarchar(), Size = 512, Nullable = false }, new DBRevision(rev)); ret.AddField("LastName", new DBFieldDescriptor() { FieldType = new DBFieldTypeNvarchar(), Size = 512, Nullable = false }, new DBRevision(rev)); var fldNickName = ret.AddField("Nickname", new DBFieldDescriptor() { FieldType = new DBFieldTypeNvarchar(), Size = 512, Nullable = false }, new DBRevision(rev)); fldNickName.AddRevision(new DBRevision(new DateTime(2019, 10, 10), 0, eDBRevisionType.Delete)); return(ret); }
public override void CreateTimeLine() { var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create); IDBSchema sch = AddSchema(DefaultSchemaName, new DBSchemaDescriptor()); if (DefaultSchemaName != "dbo") { sch.AddRevision(new DBRevision(rev)); } UserDetail(sch); Organization(sch); Line(sch); LineEmployee(sch); LineEmployeeInvited(sch); LineEmployeeAccepted(sch); Country(sch); LineLocation(sch); LinePhoto(sch); BusinessDay(sch); LineBusinessHour(sch); LineStatus(sch); ClearDbForTesting.Create(sch); Tasks(sch); }
public static DBRevisionWork Find(DB db, DBLane lane, DBHost host, DBRevision revision) { DBRevisionWork result; using (IDbCommand cmd = db.CreateCommand()) { cmd.CommandText = "SELECT * FROM RevisionWork WHERE lane_id = @lane_id AND revision_id = @revision_id "; if (host != null) { cmd.CommandText += " AND host_id = @host_id;"; DB.CreateParameter(cmd, "host_id", host.id); } DB.CreateParameter(cmd, "lane_id", lane.id); DB.CreateParameter(cmd, "revision_id", revision.id); using (IDataReader reader = cmd.ExecuteReader()) { if (!reader.Read()) { return(null); } result = new DBRevisionWork(reader); if (reader.Read()) { throw new ApplicationException(string.Format("Found more than one revision work for the specified lane/host/revision ({0}/{1}/{2})", lane.lane, host == null ? "null" : host.host, revision.revision)); } return(result); } } }
private IDBTable RolePermission(IDBSchema sch) { var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("RolePermission", sch, rev); var fld = DBMacros.AddForeignKeyFieldID("RoleID", true, ret, sch.Name + ".Role", new DBRevision(new DateTime(2016, 6, 10), 1, eDBRevisionType.Create)); fld.AddRevision(new DBRevision(new DateTime(2016, 6, 10), 2, eDBRevisionType.Modify), new DBFieldDescriptor(fld.Descriptor) { Nullable = false }); DBMacros.AddForeignKeyFieldID("ClaimID", true, ret, sch.Name + ".Claim", new DBRevision(new DateTime(2016, 6, 10), 1, eDBRevisionType.Create)); ret.AddField("CanExecute", DBMacros.DBFieldBitDescriptor(false), new DBRevision(new DateTime(2016, 6, 10), 2, eDBRevisionType.Create)); ret.AddIndex(new DBIndexDescriptor(new List <string>() { "RoleID", "ClaimID" }, new List <string>() { "CanExecute" }) { Unique = true }, new DBRevision(new DateTime(2016, 6, 10), 3, eDBRevisionType.Create)); return(ret); }
private IDBTable tblCases(IDBSchema sch) { var rev = new DBRevision(new DateTime(2016, 9, 19), 0, eDBRevisionType.Create); var ret = DBMacros.AddDBTableIDNaziv("tblCases", sch, rev); return(ret); }
private string GetJobInfo() { var lane_id = Utils.TryParseInt32(Request ["lane_id"]); var host_id = Utils.TryParseInt32(Request ["host_id"]); var response = Utils.LocalWebService.GetViewLaneData2( login, lane_id, Request ["lane"], host_id, Request ["host"], Utils.TryParseInt32(Request ["revision_id"]), Request ["revision"], false); DBRevision dbr = response.Revision; DBRevisionWork revisionwork = response.RevisionWork; DBLane lane = response.Lane; DBHost host = response.Host; DBRevision revision = response.Revision; var jobinfo = new { revision = dbr.revision, status = revisionwork.State, author = dbr.author, commit_date = dbr.date.ToUniversalTime(), host = response.WorkHost.host, host_id = response.WorkHost.id }; return(JsonConvert.SerializeObject(jobinfo, Formatting.Indented)); }
protected void Page_Load(object sender, EventArgs e) { try { GetViewLaneDataResponse response; response = Master.WebService.GetViewLaneData2(Master.WebServiceLogin, Utils.TryParseInt32(Request ["lane_id"]), Request ["lane"], Utils.TryParseInt32(Request ["host_id"]), Request ["host"], Utils.TryParseInt32(Request ["revision_id"]), Request ["revision"], false); DBHost host = response.Host; DBLane lane = response.Lane; DBRevision revision = response.Revision; if (lane == null || host == null || revision == null) { Response.Redirect("index.aspx", false); return; } header.InnerHtml = ViewLane.GenerateHeader(response, lane, host, revision, "Html report for"); htmlreport.Attributes ["src"] = Request.Url.ToString().Replace("Embedded", ""); htmlreport.Attributes ["onload"] = "javascript: resizeToFillIFrame (document.getElementById ('" + htmlreport.ClientID + "'));"; ClientScript.RegisterStartupScript(GetType(), "resizeIFrame", "<script type='text/javascript'>resizeToFillIFrame (document.getElementById ('" + htmlreport.ClientID + "'));</script>"); } catch (Exception ex) { Response.Write(ex.ToString().Replace("\n", "<br/>")); } }
private IDBTable Mjesto(IDBSchema sch) { var rev = new DBRevision(new DateTime(2016, 7, 8), 1, eDBRevisionType.Create); var ret = DBMacros.AddDBTableIDNaziv("Mjesto", sch, rev); return(ret); }
private IDBTable MjestoTroska(IDBSchema sch) { var rev = new DBRevision(new DateTime(2016, 9, 19), 0, eDBRevisionType.Create); var ret = DBMacros.AddDBTableIDNaziv("MjestoTroska", sch, rev); //ret.AddRevision(new DBRevision(new DateTime(2016, 6, 28), 0, eDBRevisionType.Task, null, null)); return(ret); }
private IDBTable Claim(IDBSchema sch) { var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("Claim", sch, rev); ret.AddField("Name", DBMacros.DBFieldNazivDescriptor(false), rev); return(ret); }
private IDBTable Drzava(IDBSchema sch) { var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create); var ret = DBMacros.AddDBTableIDNaziv("Drzava", sch, rev); ret.AddRevision(new DBRevision(new DateTime(2016, 6, 28), 0, eDBRevisionType.Task, FillDrzava, null, 150)); return(ret); }
private IDBTable Organization(IDBSchema sch) { var rev = new DBRevision(new DateTime(2020, 4, 14), 0, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("Organization", sch, new DBRevision(rev)); ret.AddField("Name", DBMacros.DBFieldNazivDescriptor(false), new DBRevision(rev)); return(ret); }
private IDBTable Principal(IDBSchema sch) { var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("Principal", sch, rev); ret.AddField("Username", DBMacros.DBFieldNazivDescriptor(false), rev); ret.AddField("SuperAdmin", DBMacros.DBFieldBitDescriptor(false), rev); return(ret); }
private IDBTable PrincipalHasRole(IDBSchema sch) { var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("PrincipalHasRole", sch, rev); DBMacros.AddForeignKeyFieldID("PrincipalID", true, ret, sch.Name + ".Principal", new DBRevision(new DateTime(2016, 6, 10), 1, eDBRevisionType.Create)); DBMacros.AddForeignKeyFieldID("RoleID", true, ret, sch.Name + ".Role", new DBRevision(new DateTime(2016, 6, 10), 1, eDBRevisionType.Create)); return(ret); }
public override void CreateTimeLine() { var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create); IDBSchema sch = AddSchema(DefaultSchemaName, new DBSchemaDescriptor()); if (DefaultSchemaName != "dbo") { sch.AddRevision(new DBRevision(rev)); } MjestoTroska(sch); }
void GenerateActionLink(StringBuilder header, DBLane lane, DBHost host, DBRevision dbr, string cmd, string short_label, string long_label, bool hidden = false) { var href = confirmViewLaneAction(lane, host, dbr, cmd, short_label); if (hidden) { header.AppendFormat("- <a style='{0}' href='{1}'>{2}</a>", "display:none", href, long_label); } else { header.AppendFormat("- <a href='{0}'>{1}</a>", href, long_label); } }
private IDBTable BusinessDay(IDBSchema sch) { var rev = new DBRevision(new DateTime(2020, 4, 14), 0, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("BusinessDay", sch, new DBRevision(rev)); ret.AddField("ShortName", DBMacros.DBFieldNazivDescriptor(false), new DBRevision(rev)); ret.AddField("FullName", DBMacros.DBFieldNazivDescriptor(false), new DBRevision(rev)); ret.AddConstraint(new DBUniqueConstraintDescriptor("ShortName"), new DBRevision(rev)); ret.AddConstraint(new DBUniqueConstraintDescriptor("FullName"), new DBRevision(rev)); return(ret); }
private IDBTable LineEmployee(IDBSchema sch) { var rev = new DBRevision(new DateTime(2020, 4, 14), 2, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("LineEmployee", sch, new DBRevision(rev)); DBMacros.AddForeignKeyFieldID("LineID", false, ret, sch.Name + ".Line", new DBRevision(rev)); DBMacros.AddForeignKeyFieldID("EmployeeID", false, ret, sch.Name + ".UserDetail", new DBRevision(rev)); return(ret); }
public static void FindPeopleForCommit(DBLane lane, DBRevision revision, List <DBPerson> people) { if (lane.source_control == "git") { GITUpdater.FindPeopleForCommit(lane, revision, people); /* * } else if (lane.source_control == "svn") { * SVNUpdater.FindPeopleForCommit (lane, revision, people); * */ } else { Logger.Log("FindPeopleForCommit (): unknown source control: '{0}'", lane.source_control); } }
public static void FindPeopleForCommit(DBLane lane, DBRevision revision, List <DBPerson> people) { if (lane.source_control == "git") { GITUpdater.FindPeopleForCommit(lane, revision, people); /* * } else if (lane.source_control == "svn") { * SVNUpdater.FindPeopleForCommit (lane, revision, people); * */ } else { log.ErrorFormat("Unknown source control for lane {0}: {1}", lane.lane, lane.source_control); } }
private IDBTable Grad(IDBSchema sch) { var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("Grad", sch, rev); ret.AddField("Naziv", new DBFieldDescriptor() { Nullable = false, FieldType = new DBFieldTypeNvarchar(), Size = 512 }, new DBRevision(rev)); DBMacros.AddForeignKeyFieldID("DrzavaID", true, ret, sch.Name + ".Drzava", new DBRevision(new DateTime(2016, 6, 10), 1, eDBRevisionType.Create)); return(ret); }
private IDBTable LinePhoto(IDBSchema sch) { var rev = new DBRevision(new DateTime(2020, 4, 14), 2, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("LinePhoto", sch, new DBRevision(rev)); DBMacros.AddForeignKeyFieldID("LineID", false, ret, sch.Name + ".Line", new DBRevision(rev)); ret.AddField("PhotoName", DBMacros.DBFieldNazivDescriptor(false), new DBRevision(rev)); ret.AddField("PhotoUrl", DBMacros.DBFieldLongTextDescriptor(false), new DBRevision(rev)); return(ret); }
public override void CreateTimeLine() { var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create); IDBSchema sch = AddSchema(DefaultSchemaName, new DBSchemaDescriptor()); if (DefaultSchemaName != "dbo") { sch.AddRevision(new DBRevision(rev)); } UserDetail(sch); ClearDbForTesting.Create(sch); Tasks(sch); }
public override void CreateTimeLine() { var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create); IDBSchema sch = AddSchema(DefaultSchemaName, new DBSchemaDescriptor()); if (DefaultSchemaName != "dbo") { sch.AddRevision(new DBRevision(rev)); } tblCases(sch); var ass = System.Reflection.Assembly.GetExecutingAssembly(); sch.AddExecuteOnceTask(new DateTime(2016, 9, 21), 0, Framework.Core.Helpers.ReadEmbeddedTextResource(ass, "Resources.CentrixCore.sp_Zbroji_v1.txt")); }
private IDBTable LineLocation(IDBSchema sch) { var rev = new DBRevision(new DateTime(2020, 4, 14), 2, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("LineLocation", sch, new DBRevision(rev)); ret.AddField("Longitude", new DBFieldDescriptor() { Size = 18, Precision = 6, FieldType = new DBFieldTypeDecimal(), DefaultValue = "0", Nullable = false }, new DBRevision(rev)); ret.AddField("Latitude", new DBFieldDescriptor() { Size = 18, Precision = 6, FieldType = new DBFieldTypeDecimal(), DefaultValue = "0", Nullable = false }, new DBRevision(rev)); DBMacros.AddForeignKeyFieldID("CountryID", false, ret, sch.Name + ".Country", new DBRevision(rev)); ret.AddField("StreetAddress", DBMacros.DBFieldNazivDescriptor(false), new DBRevision(rev)); ret.AddField("City", DBMacros.DBFieldNazivDescriptor(false), new DBRevision(rev)); ret.AddField("State", DBMacros.DBFieldNazivDescriptor(true), new DBRevision(rev)); ret.AddField("ZipCode", DBMacros.DBFieldNazivDescriptor(true), new DBRevision(rev)); ret.AddConstraint(new DBForeignKeyConstraintDescriptor(new List <string>() { "ID" }, sch.Name + ".Line", new List <string>() { "ID" }), new DBRevision(rev)); return(ret); }
private IDBTable LineBusinessHour(IDBSchema sch) { var rev = new DBRevision(new DateTime(2020, 4, 14), 2, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("LineBusinessHour", sch, new DBRevision(rev)); DBMacros.AddForeignKeyFieldID("LineID", false, ret, sch.Name + ".Line", new DBRevision(rev)); DBMacros.AddForeignKeyFieldID("BusinessDayID", false, ret, sch.Name + ".BusinessDay", new DBRevision(rev)); ret.AddField("StartTime", DBMacros.DBFieldIntegerDescriptor(false), new DBRevision(rev)); ret.AddField("EndTime", DBMacros.DBFieldIntegerDescriptor(false), new DBRevision(rev)); return(ret); }
private IDBTable LineStatus(IDBSchema sch) { var rev = new DBRevision(new DateTime(2020, 4, 14), 2, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("LineStatus", sch, new DBRevision(rev)); ret.AddConstraint(new DBForeignKeyConstraintDescriptor(new List <string>() { "ID" }, sch.Name + ".Line", new List <string>() { "ID" }), new DBRevision(rev)); ret.AddField("IsReadyForWork", DBMacros.DBFieldBitDescriptor(false), new DBRevision(rev)); return(ret); }
private IDBTable LineEmployeeAccepted(IDBSchema sch) { var rev = new DBRevision(new DateTime(2020, 4, 14), 4, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("LineEmployeeAccepted", sch, new DBRevision(rev)); ret.AddConstraint(new DBForeignKeyConstraintDescriptor(new List <string>() { "ID" }, sch.Name + ".LineEmployee", new List <string>() { "ID" }), new DBRevision(rev)); ret.AddField("InviteAcceptedOn", DBMacros.DBFieldDateTimeDescriptor(false), new DBRevision(rev)); return(ret); }
public override void CreateTimeLine() { var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create); IDBSchema sch = AddSchema(DefaultSchemaName, new DBSchemaDescriptor()); if (DefaultSchemaName != "dbo") { sch.AddRevision(new DBRevision(rev)); } Drzava(sch); Grad(sch); Always(sch); DBStoredProcedure sp = (DBStoredProcedure)sch.AddDBObject("sp_Stora", new DBStoredProcedureDescriptor() { Parameters = "@broj int, @broj2 int, @tekst nvarchar(max)", Body = "SELECT Dijeljenje = @broj / @broj2, Tekst = @tekst", ErrorHandling = true }, new DBRevision(new DateTime(2016, 9, 19), 0, eDBRevisionType.Create)); }
public DBRevision GetRevision(string lane, int revision) { using (IDbCommand cmd = CreateCommand()) { cmd.CommandText = "SELECT * from revisions where lane = @lane AND revision = @revision"; DB.CreateParameter(cmd, "lane", lane); DB.CreateParameter(cmd, "revision", revision.ToString()); using (IDataReader reader = cmd.ExecuteReader()) { if (!reader.Read()) { return(null); } if (reader.IsDBNull(0)) { return(null); } DBRevision rev = new DBRevision(); rev.Load(reader); return(rev); } } }