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