public void SalvarLoteRps(Layouts.Betha.EnviarLoteRpsEnvio lote, Core.ArquivosEnvio localArquivos)
{
if (string.IsNullOrWhiteSpace(localArquivos.SalvarEnvioLoteEm))
throw new ArgumentNullException("localArquivos.SalvarEnvioLoteEm");
if (!System.IO.Directory.Exists(System.IO.Path.GetDirectoryName(localArquivos.SalvarEnvioLoteEm)))
System.IO.Directory.CreateDirectory(System.IO.Path.GetDirectoryName(localArquivos.SalvarEnvioLoteEm));
var serializar = new Layouts.Serializador();
serializar.SalvarXml<Layouts.Betha.EnviarLoteRpsEnvio>(lote, localArquivos.SalvarEnvioLoteEm);
}
public Core.RespostaCancelamentoNfse CancelarNfse(Layouts.Betha.CancelarNfseEnvio envioCancelamento, Core.Empresa empresa, Core.ArquivosEnvio localArquivos)
{
try
{
ValidarCaminhos(localArquivos);
var serializar = new Layouts.Serializador();
serializar.SalvarXml<Layouts.Betha.CancelarNfseEnvio>(envioCancelamento, localArquivos.SalvarCancelarNfseEnvioEm);
var envio = new NFSE.Net.Envio.Processar();
ExecutarConsultas(() =>
{
envio.ProcessaArquivo(empresa, localArquivos.SalvarCancelarNfseEnvioEm, localArquivos.SalvarCancelarNfseRespostaEm, Servicos.CancelarNfse);
});
bool erro = false;
var respostaEnvioLote = serializar.TryLerXml<Layouts.Betha.CancelarNfseReposta>(localArquivos.SalvarCancelarNfseRespostaEm, out erro);
if (respostaEnvioLote != null)
{
if (respostaEnvioLote.Item is ListaMensagemRetorno)
{
var retorno = new Core.RespostaCancelamentoNfse();
ListaMensagemRetorno mensagensErro = (ListaMensagemRetorno)respostaEnvioLote.Item;
retorno.Sucesso = false;
retorno.CodigoErro = mensagensErro.MensagemRetorno[0].Codigo;
retorno.Correcao = mensagensErro.MensagemRetorno[0].Correcao;
retorno.MensagemErro = mensagensErro.MensagemRetorno[0].Mensagem;
return retorno;
}
else
{
var retorno = new Core.RespostaCancelamentoNfse();
tcCancelamentoNfse cancelamento = (tcCancelamentoNfse)respostaEnvioLote.Item;
retorno.Sucesso = cancelamento.Confirmacao.InfConfirmacaoCancelamento.Sucesso;
retorno.DataHoraCancelamento = cancelamento.Confirmacao.InfConfirmacaoCancelamento.DataHora;
retorno.NumeroNfse = cancelamento.Confirmacao.Pedido.InfPedidoCancelamento.IdentificacaoNfse.Numero;
return retorno;
}
}
else
return new Core.RespostaCancelamentoNfse() { Sucesso = false, CodigoErro = "00", MensagemErro = "Erro desconhecido" };
}
catch (System.Reflection.TargetInvocationException e)
{
throw e.InnerException;
}
}
/// <summary>
/// Measure the layout size required to arrange all elements.
/// </summary>
/// <param name="availableSize">Available size that can be given to elements.</param>
/// <returns>Size the layout determines it needs based on child element sizes.</returns>
protected override Size MeasureOverride(Size availableSize)
{
// To ensure correct operation when transitioning between being an items host and
// not being an items host (and vica versa) we need to ask for the InternalChildren
// property. The base class implementation will automatically handle creating the
// item container generator and pulling it down again.
int c = InternalChildren.Count;
// Delegate calculation to the panel layout instance
if (_children != null)
{
// Use default layout so that any children not handled by the layout definitions is still processed
_defaultLayout.MeasureChildren(string.Empty, this, _stateDict, _children.CompoundElements, availableSize);
// Ask the layout strategy to measure the elements for us
return(Layouts.MeasureChildren(LayoutId, this, _stateDict, _children.CompoundElements, availableSize));
}
else
{
return(new Size());
}
}
/// <summary>
/// Provides access to the entities of the layout with the given name.
/// </summary>
/// <param name="name">The name of the layout.</param>
/// <returns>An EntityContainer to access the layout's entities.</returns>
public EntityContainer PaperSpace(string name)
{
if (name == null)
{
throw Error.ArgumentNull("name");
}
try
{
var layout = Layouts.Element(name);
if (layout.ModelType)
{
throw Error.Generic("Not a paper space layout");
}
return(new EntityContainer(Database, transaction, layout.BlockTableRecordId));
}
catch (Exception e)
{
throw Error.AutoCadException(e);
}
}
BaseLayoutElement GetSelectedLayout()
{
if (Layouts.Count(l => l.IsSelected == true) > 0)
{
BaseLayoutElement selectedLayout = Layouts.Where(l => l.IsSelected == true)
.ToList().SingleOrDefault();
return(selectedLayout);
}
else
{
Layouts[0].IsSelected = true;
if (Get.i.Layouts.ContainsKey(Layouts[0].Id))
{
Get.i.Layouts.SaveLayout(Layouts[0]);
}
else
{
Get.i.Layouts.InsertLayout(Layouts[0]);
}
}
return(Layouts[0]);
}
/// <summary>
/// Moves the specified entity under the parent at the specified path.
/// </summary>
/// <param name="entity">
/// The entity to move.
/// </param>
/// <param name="parentPath">
/// The path to the new parent.
/// </param>
/// <returns>
/// The new path.
/// </returns>
public Guid[] MoveEntity(IEntity entity, Guid[] parentPath)
{
// Update path.
var path = parentPath.Concat(new[] { entity.Id }).ToArray();
entity.Path = path;
// Persist entity based on the entity type.
if (entity is Form)
{
Forms.Persist(entity as Form);
}
else if (entity is Layout)
{
Layouts.Persist(entity as Layout);
}
else if (entity is Validation)
{
Validations.Persist(entity as Validation);
}
else if (entity is DataValue)
{
DataValues.Persist(entity as DataValue);
}
else if (entity is Folder)
{
Folders.Persist(entity as Folder);
}
else if (entity is ConfiguredForm)
{
ConfiguredForms.Persist(entity as ConfiguredForm);
}
// Return new path.
return(path);
}
public Linclon2019()
{
Name = "Newark - Lincoln Model Rail Club Post Modernisation Exhibition";
Location = new NewarkShowground();
EventDates = "19th and 20th October 2019";
Descrption = "Lincoln Model Rail Club Post Modernisation Exhibition";
ImagesPath = Constants.RawDataPath + @"ModelEvents\2019-10-19 Newark Model LincolnModelRailClub";
TripDate = new DateTime(2019, 10, 19);
YouTubeLink = "https://www.youtube.com/embed/sfhv8iYXiYU";
ImageFolder = "20191019-Lincoln";
Title = "Lincoln Model Rail Club 2019";
ImagePreview = "PA196601-Newark-Model-Lincoln-model-rail-club-Crimson-road-thumb.JPG";
Keywords.AddRange(ModelEventKeywords());
Keywords.AddRange(new string[] { "Linclon", "Lincoln Model Rail Club", "Newark Showground", "Post Modernisation Exhibition" });
Layouts.Add(new LayoutDetails("Crimson Road", Gauges.NONE, "CrimsonRoad"));
Layouts.Add(new LayoutDetails("Cumanavago", Gauges.NONE, "Cumanavago"));
Layouts.Add(new LayoutDetails("Dovington Camp", Gauges.NONE, "DovingtonCamp"));
Layouts.Add(new LayoutDetails("Eight Dollar Canyon", Gauges.NONE, "EightDollarCanyon"));
Layouts.Add(new LayoutDetails("Euxton Junction", Gauges.NONE, "EuxtonJunction"));
Layouts.Add(new LayoutDetails("Gillingbourne", Gauges.NONE, "Gillingbourne"));
Layouts.Add(new LayoutDetails("Holland Beck", Gauges.NONE, "HollandBeck"));
Layouts.Add(new LayoutDetails("Illie Town", Gauges.NONE, "IllieTown"));
Layouts.Add(new LayoutDetails("K Street Yard", Gauges.NONE, "KStreetYard"));
Layouts.Add(new LayoutDetails("Lea Green Yard", Gauges.NONE, "LeaGreenYard"));
Layouts.Add(new LayoutDetails("Loch Tat", Gauges.NONE, "LochTat"));
Layouts.Add(new LayoutDetails("Low Moor", Gauges.NONE, "LowMoor"));
Layouts.Add(new LayoutDetails("Lynchwood Sidings", Gauges.NONE, "LynchwoodSidings"));
Layouts.Add(new LayoutDetails("Norton Folgate", Gauges.NONE, "NortonFolgate"));
Layouts.Add(new LayoutDetails("Oil DrumLane", Gauges.NONE, "OilDrumLane"));
Layouts.Add(new LayoutDetails("Penna Lane", Gauges.NONE, "PennaLane"));
Layouts.Add(new LayoutDetails("Sutherland Street", Gauges.NONE, "SutherlandStreet"));
Layouts.Add(new LayoutDetails("Titheridge Junction", Gauges.NONE, "TitheridgeJunction"));
Layouts.Add(new LayoutDetails("Weaver Hill", Gauges.NONE, "WeaverHill"));
Layouts.Add(new LayoutDetails("West Street Station", Gauges.NONE, "WestStreetStation"));
Layouts.Add(new LayoutDetails("Zlata Vychod", Gauges.NONE, "ZlataVychod"));
}
public DomainObject1PivotGridSetup()
{
Layouts.Add(new PivotGridLayout(Default1LayoutName, LayoutFields));
Layouts.Add(new PivotGridLayout(Default2LayoutName, LayoutFields));
TranYearField = new PivotGridFieldBase("TranDate", PivotArea.FilterArea);
TranYearField.Name = "fieldTranYear";
TranYearField.Caption = "Tran Year";
TranYearField.GroupInterval = PivotGroupInterval.DateYear;
Fields.Add(TranYearField);
TranDateField = new PivotGridFieldBase("TranDate", PivotArea.FilterArea);
TranDateField.Name = "fieldTranDate";
TranDateField.Caption = "Tran Date";
TranDateField.ValueFormat.FormatType = DevExpress.Utils.FormatType.Custom;
TranDateField.ValueFormat.FormatString = "{0:dd-MMM-yy}";
Fields.Add(TranDateField);
NameField = new PivotGridFieldBase("Name", PivotArea.ColumnArea);
NameField.Name = "fieldName";
NameField.Caption = "My Name";
Fields.Add(NameField);
Category1Field = new PivotGridFieldBase("Category1", PivotArea.ColumnArea);
Category1Field.Name = "fieldCategory1";
Category1Field.Caption = "My Category1";
Fields.Add(Category1Field);
Category2Field = new PivotGridFieldBase("Category2", PivotArea.ColumnArea);
Category2Field.Name = "fieldCategory2";
Category2Field.Caption = "My Category2";
Fields.Add(Category2Field);
AmountField = new PivotGridFieldBase("Amount", PivotArea.ColumnArea);
//AmountField.Name = "fieldAmount";
AmountField.Caption = "My Amount";
Fields.Add(AmountField);
}
public void Setup(Layouts layouts, ImagePool.FrontTypes frontTypes, ImagePool.BackTypes backTypes)
{
cards.Clear();
switch (layouts)
{
case Layouts.FourByFour:
MakeFourByFour(frontTypes, backTypes);
break;
case Layouts.FiveByFive:
MakeFiveByFive(frontTypes, backTypes);
break;
case Layouts.FourBySix:
MakeFourBySix(frontTypes, backTypes);
break;
case Layouts.SixBySix:
MakeSixBySix(frontTypes, backTypes);
break;
}
}
/// <summary>
/// Position child elements according to already provided size.
/// </summary>
/// <param name="finalSize">Size that layout should use to arrange child elements.</param>
/// <returns>Size used by the panel.</returns>
protected override Size ArrangeOverride(Size finalSize)
{
// Implement any ClipToBounds property setting
ImplementClipToBounds(finalSize);
// Grab the collection of appropriate elements
ICollection elements = MetaChildren;
// Ask the panel layout to calculate the target display rectangles for elements
Layouts.TargetChildren(LayoutId, this, _stateDict, elements, finalSize);
// Ask the chain of animation handlers to update animation state and elements
bool needAnimating = AnimateChildren(_stateDict, elements);
// Faster perf to only set the IsAnimating when we notice a change
if (needAnimating != IsAnimating)
{
IsAnimating = needAnimating;
}
// Finally ask the panel layout to arrange elements in animation determined positions
return(Layouts.ArrangeChildren(LayoutId, this, _stateDict, elements, finalSize));
}
/// <summary>
/// Provides access to the entities of the layout with the given tab index.
/// </summary>
/// <param name="index">The zero-based tab index of the layout.</param>
/// <returns>An EntityContainer to access the layout's entities.</returns>
public EntityContainer PaperSpace(int index)
{
var layouts = Layouts.ToArray();
if (index < 0 || index >= layouts.Length)
{
throw Error.IndexOutOfRange("index", layouts.Length);
}
var blockId = Layouts.Where(l => !l.ModelType)
.OrderBy(l => l.TabOrder)
.ElementAt(index)
.BlockTableRecordId;
try
{
return(new EntityContainer(Database, transaction, blockId));
}
catch (Exception e)
{
throw Error.AutoCadException(e);
}
}
private void Next_Click(object sender, RoutedEventArgs e)
{
List <LayoutInfo> infos = Layouts.ItemsSource as List <LayoutInfo>;
if (infos == null)
{
return;
}
int index = infos.IndexOf(CurrentSelectedLayoutInfo);
if (index >= infos.Count - 1)
{
index = -1;
}
CurrentSelectedLayoutInfo = infos.ElementAtOrDefault(index + 1);
if (CurrentSelectedLayoutInfo != null)
{
LayoutsListBox.SelectedItem = Layouts.SelectedItem = CurrentSelectedLayoutInfo;
Layouts.ScrollIntoView(CurrentSelectedLayoutInfo);
LayoutsListBox.ScrollIntoView(CurrentSelectedLayoutInfo);
}
}
/// <summary>
/// Gets the entity with the specified ID.
/// </summary>
/// <param name="entityId">The ID of the entity.</param>
/// <returns>
/// The entity.
/// </returns>
public IEntity Retrieve(Guid entityId)
{
// Root-level node?
if (EntityHelper.IsRoot(entityId))
{
return(new EntityRoot()
{
Id = entityId,
Path = new[] { entityId },
Name = EntityHelper.GetNameForRoot(entityId),
Icon = EntityHelper.GetIconForRoot(entityId)
});
}
else
{
// Specific entities (e.g., forms or layouts).
return(Folders.Retrieve(entityId) as IEntity
?? Forms.Retrieve(entityId) as IEntity
?? ConfiguredForms.Retrieve(entityId) as IEntity
?? Layouts.Retrieve(entityId) as IEntity
?? Validations.Retrieve(entityId) as IEntity
?? DataValues.Retrieve(entityId) as IEntity);
}
}
public void SelectLayout(Guid key)
{
Layouts.Where(w => w.IsSelected == true)
.ToList()
.ForEach(f => f.IsSelected = false);
Get.i.Layouts.UnselectAll();
SelectedLayout = Layouts.Where(w => w.Id == key).ToList().Single();
SelectedLayout.IsSelected = true;
if (Get.i.Layouts.ContainsKey(key))
{
Get.i.Layouts.SaveLayout(SelectedLayout);
}
else
{
Get.i.Layouts.InsertLayout(SelectedLayout);
}
SelectedLayout.SerializeToXml();
Logger.Debug("Selected layout changed to: {0}", SelectedLayout.Name);
}
/// <summary>
/// Load state from data
/// </summary>
/// <param name="data">Data to load from</param>
public void Load(Data data)
{
cardsLeftCount = data.cardsLeftCount;
layout = data.layout;
switch (layout)
{
case Layouts.FourByFour:
LoadFourByFour(data.cards);
break;
case Layouts.FiveByFive:
LoadFiveByFive(data.cards);
break;
case Layouts.SixByFour:
LoadSixByFour(data.cards);
break;
case Layouts.SixBySix:
LoadSixBySix(data.cards);
break;
}
}
public void DrawThreeLayerVertical(RawShape centreShape, List<RawShape> topLevelShapes, List<RawShape> bottomLevelShapes, List<RawShape> rightAlignedShapes)
{
if (topLevelShapes == null)
topLevelShapes = new List<RawShape>();
if (bottomLevelShapes == null)
bottomLevelShapes = new List<RawShape>();
DiagramType = Layouts.ThreeLayerVertical;
DrawThreeLayer(centreShape, topLevelShapes, bottomLevelShapes, rightAlignedShapes);
}
protected void createTable(int count)
{
DataTable dt = new DataTable();
dt.Columns.Add("ID", typeof(string));
dt.Columns.Add("Time", typeof(string));
dt.Columns.Add("Title", typeof(string));
dt.Columns.Add("Type", typeof(string));
dt.Columns.Add("Creator", typeof(string));
string id = "", title = "", type = "", creator = "", time = "";
connect.Open();
SqlCommand cmd = connect.CreateCommand();
for (int i = 1; i <= count; i++)
{
//Get the topic ID:
cmd.CommandText = "select [topicId] from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY topicId ASC), * FROM [Topics] where topic_isApproved = 1 and topic_isDenied = 0 and topic_isDeleted = 0) as t where rowNum = '" + i + "'";
id = cmd.ExecuteScalar().ToString();
//Get type:
cmd.CommandText = "select [topic_time] from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY topicId ASC), * FROM [Topics] where topic_isApproved = 1 and topic_isDenied = 0 and topic_isDeleted = 0) as t where rowNum = '" + i + "'";
time = cmd.ExecuteScalar().ToString();
//Get title:
cmd.CommandText = "select [topic_title] from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY topicId ASC), * FROM [Topics] where topic_isApproved = 1 and topic_isDenied = 0 and topic_isDeleted = 0) as t where rowNum = '" + i + "'";
title = cmd.ExecuteScalar().ToString();
//Get type:
cmd.CommandText = "select [topic_type] from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY topicId ASC), * FROM [Topics] where topic_isApproved = 1 and topic_isDenied = 0 and topic_isDeleted = 0) as t where rowNum = '" + i + "'";
type = cmd.ExecuteScalar().ToString();
//Get creator's ID:
cmd.CommandText = "select [topic_createdBy] from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY topicId ASC), * FROM [Topics] where topic_isApproved = 1 and topic_isDenied = 0 and topic_isDeleted = 0) as t where rowNum = '" + i + "'";
string creatorId = cmd.ExecuteScalar().ToString();
//Get creator's name:
cmd.CommandText = "select user_firstname from users where userId = '" + creatorId + "' ";
creator = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select user_lastname from users where userId = '" + creatorId + "' ";
creator = creator + " " + cmd.ExecuteScalar().ToString();
dt.Rows.Add(id, Layouts.getTimeFormat(time), title, type, creator);
}
grdTopics.DataSource = dt;
grdTopics.DataBind();
//grdTopics.AutoGenerateColumns = true;
//Hide the header called "ID":
grdTopics.HeaderRow.Cells[1].Visible = false;
//Hide IDs column and content which are located in column index 1:
for (int i = 0; i < grdTopics.Rows.Count; i++)
{
grdTopics.Rows[i].Cells[1].Visible = false;
}
for (int row = 0; row < grdTopics.Rows.Count; row++)
{
id = grdTopics.Rows[row].Cells[1].Text;
//Get creator's ID:
cmd.CommandText = "select [topic_createdBy] FROM [Topics] where topicId = " + id + " ";
string creatorId = cmd.ExecuteScalar().ToString();
//Get creator's name:
cmd.CommandText = "select user_firstname from users where userId = '" + creatorId + "' ";
creator = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select user_lastname from users where userId = '" + creatorId + "' ";
creator = creator + " " + cmd.ExecuteScalar().ToString();
HyperLink creatorLink = new HyperLink();
creatorLink.Text = creator + " ";
creatorLink.NavigateUrl = "Profile.aspx?id=" + creatorId;
grdTopics.Rows[row].Cells[5].Controls.Add(creatorLink);
}
connect.Close();
}
public void SaveLayouts()
{
Properties.Settings.Default.Layouts = JsonConvert.SerializeObject(Layouts.ToList(), Formatting.Indented, new LayoutsConverter());
Properties.Settings.Default.Save();
}
public LayoutInjectorAttribute(Layouts layout)
{
_layout = layout;
}
protected void printInfo()
{
SqlCommand cmd = connect.CreateCommand();
connect.Open();
cmd.CommandText = "select project_name from Projects where projectId = '" + projectId + "' ";
string project_name = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select project_description from Projects where projectId = '" + projectId + "' ";
string project_description = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select count(*) from UsersForProjects where projectId = '" + projectId + "' ";
int totalUsersForProject = Convert.ToInt32(cmd.ExecuteScalar());
List <string> names = new List <string>();
for (int i = 1; i <= totalUsersForProject; i++)
{
cmd.CommandText = "select userId from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY userId ASC), * FROM usersForProjects where projectId = '" + projectId + "' ) as t where rowNum = '" + i + "' ";
string userId = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select (user_firstname + ' ' + user_lastname) from Users where userId = '" + userId + "' ";
string name = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select loginId from Users where userId = '" + userId + "' ";
string loginId = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select roleId from Logins where loginId = '" + loginId + "' ";
int int_roleId = Convert.ToInt32(cmd.ExecuteScalar());
if (int_roleId == 2)
{
name = "Project Master: " + name + "";
}
else
{
name = "Developer: " + name + "";
}
names.Add(name);
}
string projectHeader = "<h1>" + project_name + "</h1></br>" + project_description + "</br></br>";
foreach (string n in names)
{
projectHeader += n + "</br>";
}
projectHeader += "</br></br></br>";
string userStoriesTable =
"<h3>User Stories</h3>" +
"<table border='1' style='width:100%;' >" +
"<tr><th>Unique user story ID</th>" + "<th>As a \"type of user\"</th>" + "<th>I want to \"some goal\"</th>" + "<th>so that \"reason\"</th>" + "<th>Date introduced</th>" + "<th>Date considered for implementation</th>" + "<th>Developer responsible for</th>" + "<th>Current Status</th></tr>";
string sprintTasksTable =
"<h3>Sprint Tasks</h3>" +
"<table border='1' style='width:100%;' >" +
"<tr><th>Unique sprint task ID</th>" + "<th>Unique user story ID</th>" + "<th>Task description</th>" + "<th>Date introduced</th>" + "<th>Date considered for implementation</th>" + "<th>Date completed</th>" + "<th>Developer responsible for</th>" + "<th>Current Status</th></tr>";
string testCasesTables =
"<h3>Test Cases</h3>";
cmd.CommandText = "select count(*) from UserStories where projectId = '" + projectId + "' ";
int totalUserStories = Convert.ToInt32(cmd.ExecuteScalar());
int totalSprintTasks = 0;
int totalTestCases = 0;
//int sprintTaskCounter = 0;
for (int i = 1; i <= totalUserStories; i++)
{
cmd.CommandText = "select userStoryId from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY CAST(userStory_uniqueId AS float) ASC), * FROM UserStories where projectId = '" + projectId + "' ) as t where rowNum = '" + i + "' ";
string userStoryId = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select userStory_uniqueId from UserStories where userStoryId = '" + userStoryId + "' ";
string userStory_uniqueId = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select userStory_asARole from UserStories where userStoryId = '" + userStoryId + "' ";
string userStory_asARole = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select userStory_iWantTo from UserStories where userStoryId = '" + userStoryId + "' ";
string userStory_iWantTo = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select userStory_soThat from UserStories where userStoryId = '" + userStoryId + "' ";
string userStory_soThat = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select userStory_dateIntroduced from UserStories where userStoryId = '" + userStoryId + "' ";
string userStory_dateIntroduced = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select userStory_dateConsideredForImplementation from UserStories where userStoryId = '" + userStoryId + "' ";
string userStory_dateConsideredForImplementation = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select userStory_currentStatus from UserStories where userStoryId = '" + userStoryId + "' ";
string userStory_currentStatus = cmd.ExecuteScalar().ToString();
//Now get the list of developers:
cmd.CommandText = "select count(*) from UsersForUserStories where userStoryId = '" + userStoryId + "' ";
int totalUsersForUserStory = Convert.ToInt32(cmd.ExecuteScalar());
string usersForUserStories = "";
for (int j = 1; j <= totalUsersForUserStory; j++)
{
cmd.CommandText = "select userId from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY usersForUserStoriesId ASC), * FROM UsersForUserStories where userStoryId = '" + userStoryId + "' ) as t where rowNum = '" + j + "' ";
string temp_userId = cmd.ExecuteScalar().ToString();
//Translate the user ID to a user name:
cmd.CommandText = "select (user_firstname + ' ' + user_lastname) from Users where userId = '" + temp_userId + "' ";
string temp_name = cmd.ExecuteScalar().ToString();
if (j == 1)
{
usersForUserStories = temp_name;
}
else
{
usersForUserStories = usersForUserStories + ",</br>" + temp_name;
}
}
userStoriesTable +=
"<tr><td>" + userStory_uniqueId + "</td><td>" + userStory_asARole + "</td><td>" + userStory_iWantTo + "</td><td>" + userStory_soThat + "</td><td>" + Layouts.getTimeFormat(userStory_dateIntroduced) + "</td><td>" + Layouts.getTimeFormat(userStory_dateConsideredForImplementation) + "</td><td>" + usersForUserStories + "</td><td>" + userStory_currentStatus + "</td></tr>";
cmd.CommandText = "select count(*) from SprintTasks where userStoryId = '" + userStoryId + "' ";
int temp_totalSprintTasks = Convert.ToInt32(cmd.ExecuteScalar());
totalSprintTasks += temp_totalSprintTasks;
for (int j = 1; j <= temp_totalSprintTasks; j++)
{
//sprintTaskCounter++;
cmd.CommandText = "select sprintTaskId from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY CAST(sprintTask_uniqueId AS float) ASC), * FROM SprintTasks where userStoryId = '" + userStoryId + "' ) as t where rowNum = '" + j + "' ";
string sprintTaskId = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select sprintTask_uniqueId from SprintTasks where sprintTaskId = '" + sprintTaskId + "' ";
string sprintTask_uniqueId = cmd.ExecuteScalar().ToString();
//userStory_uniqueId
cmd.CommandText = "select sprintTask_taskDescription from SprintTasks where sprintTaskId = '" + sprintTaskId + "' ";
string sprintTask_taskDescription = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select sprintTask_dateIntroduced from SprintTasks where sprintTaskId = '" + sprintTaskId + "' ";
string sprintTask_dateIntroduced = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select sprintTask_dateConsideredForImplementation from SprintTasks where sprintTaskId = '" + sprintTaskId + "' ";
string sprintTask_dateConsideredForImplementation = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select count(sprintTask_dateCompleted) from SprintTasks where sprintTaskId = '" + sprintTaskId + "' ";
int isCompleted = Convert.ToInt32(cmd.ExecuteScalar());
string sprintTask_dateCompleted = "";
if (isCompleted > 0)
{
cmd.CommandText = "select sprintTask_dateCompleted from SprintTasks where sprintTaskId = '" + sprintTaskId + "' ";
sprintTask_dateCompleted = cmd.ExecuteScalar().ToString();
sprintTask_dateCompleted = Layouts.getTimeFormat(sprintTask_dateCompleted);
}
else
{
sprintTask_dateCompleted = "Not completed";
}
//Now get the list of developers:
cmd.CommandText = "select count(*) from UsersForSprintTasks where sprintTaskId = '" + sprintTaskId + "' ";
int totalUsersForSprintTask = Convert.ToInt32(cmd.ExecuteScalar());
string usersForSprintTasks = "";
for (int k = 1; k <= totalUsersForSprintTask; k++)
{
cmd.CommandText = "select userId from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY usersForSprintTasksId ASC), * FROM UsersForSprintTasks where sprintTaskId = '" + sprintTaskId + "' ) as t where rowNum = '" + k + "' ";
string temp_userId = cmd.ExecuteScalar().ToString();
//Translate the user ID to a user name:
cmd.CommandText = "select (user_firstname + ' ' + user_lastname) from Users where userId = '" + temp_userId + "' ";
string temp_name = cmd.ExecuteScalar().ToString();
if (j == 1)
{
usersForSprintTasks = temp_name;
}
else
{
usersForSprintTasks = usersForSprintTasks + ",</br>" + temp_name;
}
}
cmd.CommandText = "select sprintTask_currentStatus from SprintTasks where sprintTaskId = '" + sprintTaskId + "' ";
string sprintTask_currentStatus = cmd.ExecuteScalar().ToString();
sprintTasksTable +=
"<tr><td>" + sprintTask_uniqueId + "</td><td>" + userStory_uniqueId + "</td><td>" + sprintTask_taskDescription + "</td><td>" + Layouts.getTimeFormat(sprintTask_dateIntroduced) + "</td><td>" + Layouts.getTimeFormat(sprintTask_dateConsideredForImplementation) + "</td><td>" + sprintTask_dateCompleted + "</td><td>" + usersForSprintTasks + "</td><td>" + sprintTask_currentStatus + "</td></tr>";
string testCaseTable =
"<h3>Test case for (user story ID: " + userStory_uniqueId + ", sprint task ID: " + sprintTask_uniqueId + ") </h3>" +
"<table border='1' style='width:100%;' >" +
"<tr><th>Unique test case ID</th>" + "<th>Unique user story ID</th>" + "<th>Sprint task ID</th>" + "<th>Test case scenario</th>" + "<th>Input Parameters</th>" + "<th>Expected output</th>" + "<th>Current Status</th></tr>";
cmd.CommandText = "select count(*) from TestCases where sprintTaskId = '" + sprintTaskId + "' ";
int temp_totalTestCases = Convert.ToInt32(cmd.ExecuteScalar());
totalTestCases += temp_totalTestCases;
for (int m = 1; m <= temp_totalTestCases; m++)
{
cmd.CommandText = "select testCaseId from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY CAST(testCase_uniqueId AS float) ASC), * FROM TestCases where sprintTaskId = '" + sprintTaskId + "' ) as t where rowNum = '" + m + "' ";
string testCaseId = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select testCase_uniqueId from TestCases where testCaseId = '" + testCaseId + "' ";
string testCase_uniqueId = cmd.ExecuteScalar().ToString();
//userStory_uniqueId
//sprintTask_uniqueId
cmd.CommandText = "select testCase_testCaseScenario from TestCases where testCaseId = '" + testCaseId + "' ";
string testCase_testCaseScenario = cmd.ExecuteScalar().ToString();
//Get the input parameters:
cmd.CommandText = "select count(*) from Parameters where testCaseId = '" + testCaseId + "' ";
int totalParameters = Convert.ToInt32(cmd.ExecuteScalar());
string inputParameters = "";
for (int n = 1; n <= totalParameters; n++)
{
cmd.CommandText = "select parameter_name from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY parameterId ASC), * FROM Parameters where testCaseId = '" + testCaseId + "' ) as t where rowNum = '" + n + "' ";
string parameter = cmd.ExecuteScalar().ToString();
if (n == 1)
{
inputParameters = parameter;
}
else
{
inputParameters = inputParameters + ",</br>" + parameter;
}
}
cmd.CommandText = "select testCase_expectedOutput from TestCases where testCaseId = '" + testCaseId + "' ";
string testCase_expectedOutput = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select testCase_currentStatus from TestCases where testCaseId = '" + testCaseId + "' ";
string testCase_currentStatus = cmd.ExecuteScalar().ToString();
testCaseTable +=
"<tr><td>" + testCase_uniqueId + "</td><td>" + userStory_uniqueId + "</td><td>" + sprintTask_uniqueId + "</td><td>" + testCase_testCaseScenario + "</td><td>" + inputParameters + "</td><td>" + testCase_expectedOutput + "</td><td>" + testCase_currentStatus + "</td></tr>";
}
testCaseTable = (temp_totalTestCases > 0) ? testCaseTable + "</table></br>" : "";
testCasesTables += testCaseTable;
}
}
userStoriesTable = (totalUserStories > 0) ? userStoriesTable + "</table></br>" : "";
sprintTasksTable = (totalSprintTasks > 0) ? sprintTasksTable + "</table></br>" : "";
testCasesTables = (totalTestCases > 0) ? testCasesTables + "</br>" : "";
connect.Close();
string result =
projectHeader +
userStoriesTable +
sprintTasksTable +
testCasesTables;
lblContent.Text = result;
}
protected void showMessageInformation()
{
connect.Open();
SqlCommand cmd = connect.CreateCommand();
//Check if the ID exists in the database:
cmd.CommandText = "select count(*) from [Entries] where [entryId] = '" + messageId + "' ";
int countMessage = Convert.ToInt32(cmd.ExecuteScalar());
if (countMessage > 0)//if ID exists, countMessage = 1
{
//Get topic ID:
cmd.CommandText = "select topicId from [Entries] where [entryId] = '" + messageId + "' ";
string topicId = cmd.ExecuteScalar().ToString();
//Get topic title:
cmd.CommandText = "select topic_title from [Topics] where [topicId] = '" + topicId + "' ";
string topic_title = cmd.ExecuteScalar().ToString();
//Get entry userId:
cmd.CommandText = "select userId from [Entries] where [entryId] = '" + messageId + "' ";
string userId = cmd.ExecuteScalar().ToString();
//Get user full name:
cmd.CommandText = "select user_firstname from users where userId = '" + userId + "' ";
string creator = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select user_lastname from users where userId = '" + userId + "' ";
creator = creator + " " + cmd.ExecuteScalar().ToString();
//Get user's email:
cmd.CommandText = "select user_email from users where userId = '" + userId + "' ";
string email = cmd.ExecuteScalar().ToString();
//Get entry_time:
cmd.CommandText = "select entry_time from [Entries] where [entryId] = '" + messageId + "' ";
string entry_time = cmd.ExecuteScalar().ToString();
//Get entry_text:
cmd.CommandText = "select entry_text from [Entries] where [entryId] = '" + messageId + "' ";
string entry_text = cmd.ExecuteScalar().ToString();
//Get entry_isDeleted:
cmd.CommandText = "select entry_isDeleted from [Entries] where [entryId] = '" + messageId + "' ";
int int_entry_isDeleted = Convert.ToInt32(cmd.ExecuteScalar());
string entry_isDeleted = "";
if (int_entry_isDeleted == 0)
{
entry_isDeleted = "Topic has not been deleted.";
}
else
{
entry_isDeleted = "Topic has been deleted.";
}
//Get entry_isApproved:
cmd.CommandText = "select entry_isApproved from [Entries] where [entryId] = '" + messageId + "' ";
int int_entry_isApproved = Convert.ToInt32(cmd.ExecuteScalar());
string entry_isApproved;
if (int_entry_isApproved == 0)
{
entry_isApproved = "Message has not been approved.";
}
else
{
entry_isApproved = "Message has been approved.";
}
//Get entry_isDenied:
cmd.CommandText = "select entry_isDenied from [Entries] where [entryId] = '" + messageId + "' ";
int int_entry_isDenied = Convert.ToInt32(cmd.ExecuteScalar());
string entry_isDenied;
if (int_entry_isDenied == 0)
{
entry_isDenied = "Message has not been approved.";
}
else
{
entry_isDenied = "Message has been approved.";
}
//Get "Yes" or "No" for entry_hasImage:
cmd.CommandText = "select entry_hasImage from [Entries] where [entryId] = '" + messageId + "' ";
int entry_hasImage = Convert.ToInt32(cmd.ExecuteScalar());
string str_entry_hasImage = "";
if (entry_hasImage == 0)
{
str_entry_hasImage = "Message does not have an image.";
}
else
{
str_entry_hasImage = "Message has an image.";
}
//Create an informative message containing all information for the selected user:
string imagesHTML = "";
if (entry_hasImage == 1)
{
cmd.CommandText = "select count(*) from ImagesForEntries where entryId = '" + messageId + "' ";
int totalImages = Convert.ToInt32(cmd.ExecuteScalar());
for (int i = 1; i <= totalImages; i++)
{
cmd.CommandText = "select [imageId] from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY imageId ASC), * FROM [ImagesForEntries] where entryId = '" + messageId + "') as t where rowNum = '" + i + "'";
string imageId = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select image_name from Images where imageId = '" + imageId + "' ";
string image_name = cmd.ExecuteScalar().ToString();
imagesHTML = imagesHTML + "<img src='../../images/" + image_name + "'></img> <br />";
}
}
lblMessageInformation.Text = "<table style=\"width:100%;\">" +
"<tr><td>Creator: </td><td>" + creator + "</td></tr>" +
"<tr><td>Topic related:</td><td>" + topic_title + "</td></tr>" +
"<tr><td>Message time: </td><td>" + Layouts.getTimeFormat(entry_time) + "</td></tr>" +
"<tr><td>Deleted?: </td><td>" + entry_isDeleted + "</td></tr>" +
"<tr><td>Has image?: </td><td>" + str_entry_hasImage + "</td></tr>" +
"<tr><td>Approved?: </td><td>" + entry_isApproved + "</td></tr>" +
"<tr><td>Denied?: </td><td>" + entry_isDenied + "</td></tr>" +
"<tr><td>Message: </td><td> <div style=\"background: #DCCDCA; padding-left:5px; padding-right:5px; \"> " + entry_text +
imagesHTML + "</div></td></tr>" +
"</table>";
lblMessageInformation.Visible = true;
//Copy values to globals:
g_topic_isApproved = int_entry_isApproved; g_topic_isDenied = int_entry_isDenied;
g_creator = creator; g_topic_title = topic_title; g_email = email; g_entry_text = entry_text;
}
else
{
addSession();
Response.Redirect("ApproveMessages");
}
connect.Close();
}
public void DrawThreeLayerHorizontal(RawShape centreShape, List<RawShape> topLevelShapes, List<RawShape> bottomLevelShapes, bool keepMainShapeFull)
{
if (topLevelShapes == null)
topLevelShapes = new List<RawShape>();
if (bottomLevelShapes == null)
bottomLevelShapes = new List<RawShape>();
KeepMainShapeFull = keepMainShapeFull;
DiagramType = Layouts.ThreeLayerHorizontal;
DrawThreeLayer(centreShape, topLevelShapes, bottomLevelShapes, null);
}
/// <summary>
/// The method of searching for an element in the database
/// </summary>
/// <param name="item">Item</param>
/// <returns>Boolean result</returns>
static public bool ChangeItem(Layouts item)
{
return(ConnectionToDateBase.Unit.LayotsRepository.ChangeItem(ConnectionToDateBase.Convert.NewLayoutEnt(item)));
}
public KeyBoardVoiceGoogle(Layouts language, KeyBoardsVoiceMatch voiceMatch, bool useBlueTooth)
{
Language = language;
VoiceMatch = voiceMatch;
UseBluetooth = useBlueTooth;
}
private void AddDefaultObjects()
{
// collections
this.vports = new VPorts(this);
this.views = new Views(this);
this.appRegistries = new ApplicationRegistries(this);
this.layers = new Layers(this);
this.linetypes = new Linetypes(this);
this.textStyles = new TextStyles(this);
this.dimStyles = new DimensionStyles(this);
this.mlineStyles = new MLineStyles(this);
this.ucss = new UCSs(this);
this.blocks = new BlockRecords(this);
this.imageDefs = new ImageDefinitions(this);
this.underlayDgnDefs = new UnderlayDgnDefinitions(this);
this.underlayDwfDefs = new UnderlayDwfDefinitions(this);
this.underlayPdfDefs = new UnderlayPdfDefinitions(this);
this.groups = new Groups(this);
this.layouts = new Layouts(this);
//add default viewport (the active viewport is automatically added when the collection is created, is the only one supported)
//this.vports.Add(VPort.Active);
//add default layer
this.layers.Add(Layer.Default);
// add default line types
this.linetypes.Add(Linetype.ByLayer);
this.linetypes.Add(Linetype.ByBlock);
this.linetypes.Add(Linetype.Continuous);
// add default text style
this.textStyles.Add(TextStyle.Default);
// add default application registry
this.appRegistries.Add(ApplicationRegistry.Default);
// add default dimension style
this.dimStyles.Add(DimensionStyle.Default);
// add default MLine style
this.mlineStyles.Add(MLineStyle.Default);
// add ModelSpace layout
this.layouts.Add(Layout.ModelSpace);
// raster variables
this.RasterVariables = new RasterVariables();
}
public void DrawStar(RawShape centreShape, List<RawShape> outerShapes)
{
Slyce.Common.Utility.SuspendPainting(this);
KeepMainShapeFull = false;
ClearShapes();
MainShape = centreShape;
DiagramType = Layouts.Star;
ChildEntities = outerShapes;
Draw();
Slyce.Common.Utility.ResumePainting(this);
}
protected void createTable(int count)
{
DataTable dt = new DataTable();
dt.Columns.Add("ID", typeof(string));
dt.Columns.Add("Title", typeof(string));
dt.Columns.Add("Time Created", typeof(string));
dt.Columns.Add("Current Participants", typeof(string));
string id = "", title = "", type = "", time = "";
connect.Open();
SqlCommand cmd = connect.CreateCommand();
//Get the current user ID:
cmd.CommandText = "select userId from users where loginId = '" + loginId + "' ";
string userId = cmd.ExecuteScalar().ToString();
for (int i = 1; i <= count; i++)
{
//Get the topic ID:
cmd.CommandText = "select [topicId] from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY usersForTopicsId ASC), * FROM [UsersForTopics] where isApproved = 1 and userId = '" + userId + "' ) as t where rowNum = '" + i + "'";
id = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select topic_isTerminated from topics where topicId = '" + id + "' ";
int isTerminated = Convert.ToInt32(cmd.ExecuteScalar());
if (isTerminated == 0)// 0 = false. Meaning that the topic is not terminated; therefore, show it in the list of my topics:
{
//Get type:
cmd.CommandText = "select [topic_time] from topics where topicId = '" + id + "' ";
time = cmd.ExecuteScalar().ToString();
//Get title:
cmd.CommandText = "select [topic_title] from topics where topicId = '" + id + "' ";
title = cmd.ExecuteScalar().ToString();
//Get type:
cmd.CommandText = "select [topic_type] from topics where topicId = '" + id + "' ";
type = cmd.ExecuteScalar().ToString();
//Get creator's ID:
cmd.CommandText = "select [topic_createdBy] from topics where topicId = '" + id + "' ";
string creatorId = cmd.ExecuteScalar().ToString();
//dt.Rows.Add(id, title, Layouts.getTimeFormat(time), participantLink);
dt.Rows.Add(id, title, Layouts.getTimeFormat(time));
}
}
grdTopics.DataSource = dt;
grdTopics.DataBind();
//Hide the header called "ID":
grdTopics.HeaderRow.Cells[1].Visible = false;
//Hide IDs column and content which are located in column index 1:
for (int i = 0; i < grdTopics.Rows.Count; i++)
{
grdTopics.Rows[i].Cells[1].Visible = false;
}
for (int row = 0; row < grdTopics.Rows.Count; row++)
{
id = grdTopics.Rows[row].Cells[1].Text;
//Get total approved participants for a topic:
cmd.CommandText = "select count(*) from UsersForTopics where topicId = '" + id + "' and isApproved = '1' ";
int totalApprovedParticipants = Convert.ToInt32(cmd.ExecuteScalar());
for (int j = 1; j <= totalApprovedParticipants; j++)
{
HyperLink participantLink = new HyperLink();
cmd.CommandText = "select [userId] from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY UsersForTopicsId ASC), * FROM [UsersForTopics] where topicId = '" + id + "' and isApproved = '1') as t where rowNum = '" + j + "'";
string participantId = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select user_firstname from Users where userId = '" + participantId + "' ";
string participant_name = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select user_lastname from Users where userId = '" + participantId + "' ";
participant_name = participant_name + " " + cmd.ExecuteScalar().ToString();
participantLink.Text = participant_name + " ";
participantLink.NavigateUrl = "Profile.aspx?id=" + participantId;
grdTopics.Rows[row].Cells[4].Controls.Add(participantLink);
if (totalApprovedParticipants > 1)
{
HyperLink temp = new HyperLink();
temp.Text = "<br/>";
grdTopics.Rows[row].Cells[4].Controls.Add(temp);
}
}
if (totalApprovedParticipants == 0)
{
grdTopics.Rows[row].Cells[4].Text = "There are no participants";
}
}
connect.Close();
}
private Core.RespostaEnvioNFSe MontarResposta(Layouts.Betha.EnviarLoteRpsEnvio lote, ListaMensagemRetorno listaRetorno, ConsultarLoteRpsRespostaListaNfse respostaConsulta, ConsultarNfseRpsResposta respostaRps)
{
var resposta = new Core.RespostaEnvioNFSe();
int indice = 0;
foreach (var item in lote.LoteRps.ListaRps)
{
var resp = new Core.ItemResposta();
resp.LoteEnvio = lote.LoteRps.NumeroLote;
resp.NumeroRps = item.InfRps.IdentificacaoRps.Numero;
resp.Serie = item.InfRps.IdentificacaoRps.Serie;
resp.Identificacao = item.InfRps.Id;
if (listaRetorno != null && listaRetorno.MensagemRetorno != null)
{
resp.Sucesso = false;
if (indice > 0 && listaRetorno.MensagemRetorno.Length > 1)
{
resp.CodigoErro = listaRetorno.MensagemRetorno[indice].Codigo;
resp.MensagemErro = listaRetorno.MensagemRetorno[indice].Mensagem;
resp.Correcao = listaRetorno.MensagemRetorno[indice].Correcao;
}
else
{
resp.CodigoErro = listaRetorno.MensagemRetorno[0].Codigo;
resp.MensagemErro = listaRetorno.MensagemRetorno[0].Mensagem;
resp.Correcao = listaRetorno.MensagemRetorno[0].Correcao;
}
}
else if (respostaConsulta != null)
{
resp.Sucesso = true;
resp.IdentificacaoRetorno = respostaConsulta.ComplNfse[indice].Nfse.InfNfse.CodigoVerificacao;
resp.UrlConsulta = respostaConsulta.ComplNfse[indice].Nfse.InfNfse.OutrasInformacoes;
}
else if (respostaRps != null)
{
resp.Sucesso = true;
resp.Identificacao = respostaRps.ComplNfse.Nfse.InfNfse.CodigoVerificacao;
resp.UrlConsulta = respostaRps.ComplNfse.Nfse.InfNfse.OutrasInformacoes;
}
resposta.Add(resp);
indice++;
}
return resposta;
}
/// <summary>
/// The method of searching for an element in the database by number
/// </summary>
/// <param name="id">ID item</param>
/// <returns>Item</returns>
static public Layouts GetItem(int id)
{
Layouts layouts = ConnectionToDateBase.Convert.NewLayouts(ConnectionToDateBase.Unit.LayotsRepository.GetItem(id));
return(layouts);
}
/// <summary>
/// Initializes a new instance of the <see cref="LayoutQualifier"/> class.
/// </summary>
/// <param name="layouts">The layouts.</param>
public LayoutQualifier(params LayoutKeyValue[] layouts) : this()
{
Layouts.AddRange(layouts);
}
protected void getTestCaseInfo()
{
SqlCommand cmd = connect.CreateCommand();
cmd.CommandText = "select testCase_createdBy from TestCases where testCaseId = '" + g_testCaseId + "' ";
string createdByUserId = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select testCase_createdDate from TestCases where testCaseId = '" + g_testCaseId + "' ";
string createddate = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select testCase_uniqueId from TestCases where testCaseId = '" + g_testCaseId + "' ";
string testCaseUID = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select testCase_testCaseScenario from TestCases where testCaseId = '" + g_testCaseId + "' ";
string testCaseScenario = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select testCase_expectedOutput from TestCases where testCaseId = '" + g_testCaseId + "' ";
string expectedOutput = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select testCase_isDeleted from TestCases where testCaseId = '" + g_testCaseId + "' ";
int isDeleted = Convert.ToInt32(cmd.ExecuteScalar());
cmd.CommandText = "select testCase_hasImage from TestCases where testCaseId = '" + g_testCaseId + "' ";
int hasImage = Convert.ToInt32(cmd.ExecuteScalar());
cmd.CommandText = "select testCase_currentStatus from TestCases where testCaseId = '" + g_testCaseId + "' ";
string currentStatus = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select count(testCase_editedBy) from TestCases where testCaseId = '" + g_testCaseId + "' ";
int countEditedBy = Convert.ToInt32(cmd.ExecuteScalar());
cmd.CommandText = "select count(testCase_editedDate) from TestCases where testCaseId = '" + g_testCaseId + "' ";
int countEditedDate = Convert.ToInt32(cmd.ExecuteScalar());
cmd.CommandText = "select count(testCase_previousVersion) from TestCases where testCaseId = '" + g_testCaseId + "' ";
int countPreviousVersion = Convert.ToInt32(cmd.ExecuteScalar());
string testCase_editedBy = "", testCase_editedDate = "", testCase_previousVersion = "";
if (countEditedBy > 0)
{
cmd.CommandText = "select testCase_editedBy from TestCases where testCaseId = '" + g_testCaseId + "' ";
testCase_editedBy = cmd.ExecuteScalar().ToString();
}
if (countEditedDate > 0)
{
cmd.CommandText = "select testCase_editedDate from TestCases where testCaseId = '" + g_testCaseId + "' ";
testCase_editedDate = cmd.ExecuteScalar().ToString();
}
if (countPreviousVersion > 0)
{
cmd.CommandText = "select testCase_previousVersion from TestCases where testCaseId = '" + g_testCaseId + "' ";
testCase_previousVersion = cmd.ExecuteScalar().ToString();
}
//Loop through the developers for the selected Test Case:
cmd.CommandText = "select count(*) from Parameters where testcaseId = '" + g_testCaseId + "' ";
int parametersForTestCase = Convert.ToInt32(cmd.ExecuteScalar());
string inputParameters = "";
for (int j = 1; j <= parametersForTestCase; j++)
{
cmd.CommandText = "select parameter_name from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY parameterId ASC), * FROM Parameters where testCaseId = '" + g_testCaseId + "' ) as t where rowNum = '" + j + "'";
string parameter_name = cmd.ExecuteScalar().ToString();
if (j == 1)
{
inputParameters = parameter_name;
}
else
{
inputParameters = inputParameters + ",\n" + parameter_name;
}
}
//Convert the createdByUserId to a name:
cmd.CommandText = "select (user_firstname + ' ' + user_lastname) from Users where userId = '" + createdByUserId + "' ";
string createdByName = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select userId from Users where loginId = '" + loginId + "' ";
string userId = cmd.ExecuteScalar().ToString();
string imagesHTML = "";
if (hasImage == 1)
{
cmd.CommandText = "select count(*) from ImagesForTestCases where testCaseId = '" + g_testCaseId + "' ";
int totalImages = Convert.ToInt32(cmd.ExecuteScalar());
for (int i = 1; i <= totalImages; i++)
{
cmd.CommandText = "select [imageId] from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY imageId ASC), * FROM [ImagesForTestCases] where testCaseId = '" + g_testCaseId + "') as t where rowNum = '" + i + "'";
string imageId = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select image_name from Images where imageId = '" + imageId + "' ";
string image_name = cmd.ExecuteScalar().ToString();
imagesHTML = imagesHTML + "<a href='../../images/" + image_name + "' target=\"_blank\">" + image_name + "</a> <br />";
}
}
cmd.CommandText = "select userStory_uniqueId from UserStories where userStoryId = '" + g_userStoryId + "' ";
string userStoryUId = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select sprintTask_uniqueId from SprintTasks where sprintTaskId = '" + g_sprintTaskId + "' ";
string sprintTaskUId = cmd.ExecuteScalar().ToString();
//Construct an HTML output to post it:
lblTestCaseInfo.Text = Layouts.testCaseHeader(g_testCaseId, g_sprintTaskId, roleId, loginId, userId, createdByUserId,
createddate, createdByName, testCaseUID, testCaseScenario, expectedOutput, inputParameters,
isDeleted, imagesHTML, hasImage, currentStatus, userStoryUId, sprintTaskUId,
testCase_editedBy, testCase_editedDate, testCase_previousVersion);
}
public static string Serializer(Layouts temp)
{
using (StringWriter sw = new StringWriter())
{
new XmlSerializer(typeof(Layouts)).Serialize(sw, temp);
return sw.ToString();
}
}
/// <summary> /// Call Till creation for given denomination layout /// </summary> /// <param name="layout">Denomination layout</param> /// <param name="randomize">An optional argument signifying if the denomination order should be randomized</param> /// <returns>A till</returns> public ITill ExecuteCreation(Layouts layout, bool randomize = false) => factories[layout].Create(randomize);
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/// <summary>
/// Add a widget to the grid
/// </summary>
///
/// <param name="widget">Fully created widget that will be added to the grid</param>
/// <param name="row">The row in which the widget should be placed</param>
/// <param name="col">The column in which the widget should be placed</param>
/// <param name="borders">Distance from the grid square to the widget (left, top, right, bottom)</param>
/// <param name="layout">Where the widget is located in the square</param>
///
/// Usage example:
/// <code>
/// Picture pic = grid.Add(new Picture("1.png"));
/// pic.Size = new Vector2f(400, 300);
/// grid.AddWidget(pic, 0, 0);
/// </code>
///
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public void AddWidget(Widget widget, uint row, uint col, Borders borders, Layouts layout)
{
// Create the row if it didn't exist yet
while (m_GridWidgets.Count < row + 1) m_GridWidgets.Add (new List<Widget>());
while (m_ObjBorders.Count < row + 1) m_ObjBorders.Add (new List<Borders>());
while (m_ObjLayout.Count < row + 1) m_ObjLayout.Add (new List<Layouts>());
while (m_GridWidgets[(int)row].Count < col + 1) m_GridWidgets [(int)row].Add (null);
while (m_ObjBorders[(int)row].Count < col + 1) m_ObjBorders [(int)row].Add (new Borders(0, 0, 0, 0));
while (m_ObjLayout[(int)row].Count < col + 1) m_ObjLayout [(int)row].Add (Layouts.Center);
// If this is a new row then reserve some space for it
while (m_RowHeight.Count < row + 1)
m_RowHeight.Add(0);
// If this is the first row to have so many columns then reserve some space for it
if (m_ColumnWidth.Count < col + 1)
m_ColumnWidth.Add(0);
// Add the widget to the grid
m_GridWidgets[(int)row][(int)col] = widget;
m_ObjBorders[(int)row][(int)col] = borders;
m_ObjLayout[(int)row][(int)col] = layout;
// Update the widgets
UpdateWidgets();
}
string LayoutsCommand(string message, string[] json)
{
Layouts data = null;;
if (json != null)
{
data = JsonConvert.DeserializeObject <Layouts>(json[0]);
}
string outMessage = null;
switch (message)
{
case "AddItem":
LayoutsMethods.AddItem(data);
outMessage = "Добавленно";
break;
case "AddItems":
List <Layouts> list = new List <Layouts>();
int i = 0;
foreach (var x in json)
{
Layouts u = JsonConvert.DeserializeObject <Layouts>(json[i]);
list.Add(u);
}
LayoutsMethods.AddItems(list);
outMessage = "Добавленно";
break;
case "ChangeItem":
if (LayoutsMethods.ChangeItem(data) == true)
{
outMessage = "Найден";
}
else
{
outMessage = "Не найден";
}
break;
case "DeleteItem":
LayoutsMethods.DeleteItem(Convert.ToInt32(json[0]));
outMessage = "Удален";
break;
case "GetItem":
string s = JsonConvert.SerializeObject(LayoutsMethods.GetItem(Convert.ToInt32(json[0])));
outMessage = s;
break;
case "Outpoot":
string outs = null;
List <Layouts> unitWeights = LayoutsMethods.Outpoot().ToList();
foreach (var x in unitWeights)
{
outs = $"{outs}!{JsonConvert.SerializeObject(x)}";
}
outMessage = outs;
break;
default:
outMessage = "Layouts connect";
break;
}
return(outMessage);
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/// <summary>
/// Changes the layout of a given widget
/// </summary>
///
/// <param name="widget">The widget for which the layout should be changed</param>
/// <param name="layout">The new layout</param>
///
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public void changeWidgetLayout(Widget widget, Layouts layout)
{
// Find the widget in the grid
for (int row = 0; row < m_GridWidgets.Count; ++row)
{
for (int col = 0; col < m_GridWidgets[row].Count; ++col)
{
if (m_GridWidgets[row][col] == widget)
{
// Change the layout of the widget
m_ObjLayout[row][col] = layout;
// Recalculate the position of the widget
{
// Calculate the available space which is distributed when widgets are positionned.
Vector2f availableSpace = new Vector2f(0, 0);
Vector2f minSize = GetMinSize();
if (m_Size.X > minSize.X)
availableSpace.X = m_Size.X - minSize.X;
if (m_Size.Y > minSize.Y)
availableSpace.Y = m_Size.Y - minSize.Y;
Vector2f availSpaceOffset = new Vector2f(0.5f * availableSpace.X / m_ColumnWidth.Count,
0.5f * availableSpace.Y / m_RowHeight.Count);
float left = 0;
float top = 0;
for (int i = 0; i < row; ++i)
top += m_RowHeight[i] + 2 * availSpaceOffset.Y;
for (int i = 0; i < col; ++i)
left += m_ColumnWidth[i] + 2 * availSpaceOffset.X;
switch (m_ObjLayout[row][col])
{
case Layouts.UpperLeft:
left += m_ObjBorders [row] [col].Left + availSpaceOffset.X;
top += m_ObjBorders [row] [col].Top + availSpaceOffset.Y;
break;
case Layouts.Up:
left += m_ObjBorders[row][col].Left + (((m_ColumnWidth[col] - m_ObjBorders[row][col].Left - m_ObjBorders[row][col].Right) - m_GridWidgets[row][col].FullSize.X) / 2.0f) + availSpaceOffset.X;
top += m_ObjBorders[row][col].Top + availSpaceOffset.Y;
break;
case Layouts.UpperRight:
left += m_ColumnWidth[col] - m_ObjBorders[row][col].Right - m_GridWidgets[row][col].FullSize.X + availSpaceOffset.X;
top += m_ObjBorders[row][col].Top + availSpaceOffset.Y;
break;
case Layouts.Right:
left += m_ColumnWidth[col] - m_ObjBorders[row][col].Right - m_GridWidgets[row][col].FullSize.X + availSpaceOffset.X;
top += m_ObjBorders[row][col].Top + (((m_RowHeight[row] - m_ObjBorders[row][col].Top - m_ObjBorders[row][col].Bottom) - m_GridWidgets[row][col].FullSize.Y) / 2.0f) + availSpaceOffset.Y;
break;
case Layouts.BottomRight:
left += m_ColumnWidth[col] - m_ObjBorders[row][col].Right - m_GridWidgets[row][col].FullSize.X + availSpaceOffset.X;
top += m_RowHeight[row] - m_ObjBorders[row][col].Bottom - m_GridWidgets[row][col].FullSize.Y + availSpaceOffset.Y;
break;
case Layouts.Bottom:
left += m_ObjBorders[row][col].Left + (((m_ColumnWidth[col] - m_ObjBorders[row][col].Left - m_ObjBorders[row][col].Right) - m_GridWidgets[row][col].FullSize.X) / 2.0f) + availSpaceOffset.X;
top += m_RowHeight[row] - m_ObjBorders[row][col].Bottom - m_GridWidgets[row][col].FullSize.Y + availSpaceOffset.Y;
break;
case Layouts.BottomLeft:
left += m_ObjBorders[row][col].Left + availSpaceOffset.X;
top += m_RowHeight[row] - m_ObjBorders[row][col].Bottom - m_GridWidgets[row][col].FullSize.Y + availSpaceOffset.Y;
break;
case Layouts.Left:
left += m_ObjBorders[row][col].Left + availSpaceOffset.X;
top += m_ObjBorders[row][col].Top + (((m_RowHeight[row] - m_ObjBorders[row][col].Top - m_ObjBorders[row][col].Bottom) - m_GridWidgets[row][col].FullSize.Y) / 2.0f) + availSpaceOffset.Y;
break;
case Layouts.Center:
left += m_ObjBorders[row][col].Left + (((m_ColumnWidth[col] - m_ObjBorders[row][col].Left - m_ObjBorders[row][col].Right) - m_GridWidgets[row][col].FullSize.X) / 2.0f) + availSpaceOffset.X;
top += m_ObjBorders[row][col].Top + (((m_RowHeight[row] - m_ObjBorders[row][col].Top - m_ObjBorders[row][col].Bottom) - m_GridWidgets[row][col].FullSize.Y) / 2.0f) + availSpaceOffset.Y;
break;
}
m_GridWidgets[row][col].Position = new Vector2f(left, top);
}
}
}
}
}
/// <summary>
/// Initialize a new instance of the MetaGridPanel class.
/// </summary>
public MetaGridPanel()
{
_layout = new GridLayout();
Layouts.Add(_layout);
}
private CodeFrame(Op op) : this()
{
Ops.Add(op);
OpData.Add(0);
Layouts.Add(new MemoryLayout(0, 0, 0));
}
protected string storeTestCase(int hasImage)
{
string new_testCaseId = "";
DateTime createdDate = DateTime.Now;
string testCaseUId = txtUniqueTestCaseID.Text.Replace(" ", "");
testCaseUId = testCaseUId.Replace("'", "''");
string sprintTaskUId = txtUniqueSprintTaskID.Text.Replace(" ", "");
sprintTaskUId = sprintTaskUId.Replace("'", "''");
string userStoryUId = txtUniqueUserStoryID.Text.Replace(" ", "");
userStoryUId = userStoryUId.Replace("'", "''");
string testScenario = txtTestCaseScenario.Text.Replace("'", "''");
string expectedOutput = txtExpectedOutput.Text.Replace("'", "''");
string currentStatus = drpCurrentStatus.SelectedValue;
connect.Open();
SqlCommand cmd = connect.CreateCommand();
//Get the current user's ID:
cmd.CommandText = "select userId from Users where loginId = '" + loginId + "' ";
string createdBy = cmd.ExecuteScalar().ToString();
//Mark to original Test Case as deleted:
cmd.CommandText = "update TestCases set testCase_currentStatus = 'Revised', testCase_editedBy = '" + createdBy + "', " +
"testCase_editedDate = '" + createdDate + "', testCase_isDeleted = '1' " +
"where testCaseId = '" + g_testCaseId + "' ";
cmd.ExecuteScalar();
//Store the new user story in the database:
cmd.CommandText = "insert into TestCases (sprintTaskId, testCase_createdBy, testCase_createdDate, testCase_uniqueId, testCase_testCaseScenario, testCase_expectedOutput, " +
"testCase_hasImage, testCase_currentStatus, testCase_previousVersion) values " +
"('" + g_sprintTaskId + "', '" + createdBy + "', '" + createdDate + "', '" + testCaseUId + "', '" + testScenario + "', '" + expectedOutput + "', " +
" '" + hasImage + "', '" + currentStatus + "', '" + g_sprintTaskId + "') ";
cmd.ExecuteScalar();
//Get the ID of the newly stored test case from the database:
cmd.CommandText = "select testCaseId from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY testCaseId ASC), * FROM TestCases " +
"where sprintTaskId = '" + g_sprintTaskId + "' and testCase_createdBy = '" + createdBy + "' and testCase_createdDate = '" + Layouts.getOriginalTimeFormat(createdDate.ToString()) + "' "
+ " and testCase_uniqueId like '" + testCaseUId + "' "
+ " and testCase_hasImage = '" + hasImage + "' and testCase_currentStatus like '" + currentStatus + "' "
+ " and testCase_isDeleted = '0' "
+ " ) as t where rowNum = '1'";
new_testCaseId = cmd.ExecuteScalar().ToString();
//Store the parameters:
foreach (var p in drpInputParametersList.Items)
{
cmd.CommandText = "insert into Parameters (testCaseId, parameter_name) values ('" + new_testCaseId + "', '" + p.ToString().Replace("'", "''") + "')";
cmd.ExecuteScalar();
}
connect.Close();
return(new_testCaseId);
}
public void DrawVerticalSwimLanes(RawShape centreShape, List<RawShape> topLevelShapes, List<RawShape> bottomLevelShapes, List<RawShape> level4Shapes, string headingLeft, string headingCentre, string headingRight, string headingLevel4)
{
SwimLane1.Heading = headingLeft;
SwimLane2.Heading = headingCentre;
SwimLane3.Heading = headingRight;
SwimLane4.Heading = headingLevel4;
DiagramType = Layouts.SwimLanesVertical;
DrawThreeLayer(centreShape, topLevelShapes, bottomLevelShapes, level4Shapes);
}
protected void createEverythingTable()
{
DataTable dt = new DataTable();
dt.Columns.Add("Title", typeof(string));
dt.Columns.Add("Found in", typeof(string));
dt.Columns.Add("Time", typeof(string));
dt.Columns.Add("Type", typeof(string));
dt.Columns.Add("Creator", typeof(string));
string id = "", title = "", type = "", creator = "", time = "";
string searchString = txtSearch.Text.Replace("'", "''");
connect.Open();
SqlCommand cmd = connect.CreateCommand();
//Search by title
cmd.CommandText = "select count(*) from topics where topic_title like '%" + searchString + "%' and topic_isDeleted = 0 and topic_isDenied = 0 and topic_isApproved = 1 ";
int count = Convert.ToInt32(cmd.ExecuteScalar());
for (int i = 1; i <= count; i++)
{
//Get the topic ID:
cmd.CommandText = "select [topicId] from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY topicId ASC), * FROM [Topics] where topic_title like '%" + searchString + "%' and topic_isApproved = 1 and topic_isDenied = 0 and topic_isDeleted = 0) as t where rowNum = '" + i + "'";
id = cmd.ExecuteScalar().ToString();
//Get type:
cmd.CommandText = "select [topic_time] from Topics where topicId = '" + id + "' ";
time = cmd.ExecuteScalar().ToString();
//Get title:
cmd.CommandText = "select [topic_title] from Topics where topicId = '" + id + "' ";
title = cmd.ExecuteScalar().ToString();
//Get type:
cmd.CommandText = "select [topic_type] from Topics where topicId = '" + id + "' ";
type = cmd.ExecuteScalar().ToString();
//Get creator's ID:
cmd.CommandText = "select [topic_createdBy] from Topics where topicId = '" + id + "' ";
string creatorId = cmd.ExecuteScalar().ToString();
//Get creator's name:
cmd.CommandText = "select user_firstname from users where userId = '" + creatorId + "' ";
creator = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select user_lastname from users where userId = '" + creatorId + "' ";
creator = creator + " " + cmd.ExecuteScalar().ToString();
dt.Rows.Add(title, "Title", Layouts.getTimeFormat(time), type, creator);
}
//Search by creator
cmd.CommandText = "select count(*) from users where (user_firstname+ ' ' +user_lastname) like '%" + searchString + "%' ";
int totalUsers = Convert.ToInt32(cmd.ExecuteScalar());
for (int i = 1; i <= totalUsers; i++)
{
cmd.CommandText = "select [userId] from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY userId ASC), * FROM [Users] where (user_firstname+ ' ' +user_lastname) like '%" + searchString + "%' ) as t where rowNum = '" + i + "'";
string temp_userId = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select count(*) from topics where topic_createdBy = '" + temp_userId + "' and topic_isApproved = 1 and topic_isDenied = 0 and topic_isDeleted = 0";
int totalTopicsForTempUser = Convert.ToInt32(cmd.ExecuteScalar());
for (int j = 1; j <= totalTopicsForTempUser; j++)
{
//Get the topic ID:
cmd.CommandText = "select [topicId] from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY topicId ASC), * FROM [Topics] where topic_createdBy = '" + temp_userId + "' and topic_isApproved = 1 and topic_isDenied = 0 and topic_isDeleted = 0) as t where rowNum = '" + j + "'";
id = cmd.ExecuteScalar().ToString();
//Get type:
cmd.CommandText = "select [topic_time] from Topics where topicId = '" + id + "' ";
time = cmd.ExecuteScalar().ToString();
//Get title:
cmd.CommandText = "select [topic_title] from Topics where topicId = '" + id + "' ";
title = cmd.ExecuteScalar().ToString();
//Get type:
cmd.CommandText = "select [topic_type] from Topics where topicId = '" + id + "' ";
type = cmd.ExecuteScalar().ToString();
//Get creator's ID:
cmd.CommandText = "select [topic_createdBy] from Topics where topicId = '" + id + "' ";
string creatorId = cmd.ExecuteScalar().ToString();
//Get creator's name:
cmd.CommandText = "select user_firstname from users where userId = '" + creatorId + "' ";
creator = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select user_lastname from users where userId = '" + creatorId + "' ";
creator = creator + " " + cmd.ExecuteScalar().ToString();
dt.Rows.Add(title, "Creator name", Layouts.getTimeFormat(time), type, creator);
}
}
//Search by message text
cmd.CommandText = "select count(*) from entries where entry_text like '%" + searchString + "%' and entry_isDeleted = 0 and entry_isApproved = 1 and entry_isDenied = 0 ";
count = Convert.ToInt32(cmd.ExecuteScalar());
for (int i = 1; i <= count; i++)
{
//Get the topic ID:
cmd.CommandText = "select [topicId] from(SELECT rowNum = ROW_NUMBER() OVER(ORDER BY topicId ASC), * FROM [Entries] where entry_text like '%" + searchString + "%' and entry_isDeleted = 0 and entry_isApproved = 1 and entry_isDenied = 0) as t where rowNum = '" + i + "'";
string new_id = cmd.ExecuteScalar().ToString();
if (!new_id.Equals(id))
{
id = new_id;
//Check if the topic of the selected message is deleted or not:
cmd.CommandText = "select topic_isDeleted from Topics where topicId = '" + id + "' ";
int isDeleted = Convert.ToInt32(cmd.ExecuteScalar());
if (isDeleted == 0)//0: False, meaning that the topic is not deleted
{
//Get type:
cmd.CommandText = "select [topic_time] from Topics where topicId = '" + id + "' ";
time = cmd.ExecuteScalar().ToString();
//Get title:
cmd.CommandText = "select [topic_title] from Topics where topicId = '" + id + "' ";
title = cmd.ExecuteScalar().ToString();
//Get type:
cmd.CommandText = "select [topic_type] from Topics where topicId = '" + id + "' ";
type = cmd.ExecuteScalar().ToString();
//Get creator's ID:
cmd.CommandText = "select [topic_createdBy] from Topics where topicId = '" + id + "' ";
string creatorId = cmd.ExecuteScalar().ToString();
//Get creator's name:
cmd.CommandText = "select user_firstname from users where userId = '" + creatorId + "' ";
creator = cmd.ExecuteScalar().ToString();
cmd.CommandText = "select user_lastname from users where userId = '" + creatorId + "' ";
creator = creator + " " + cmd.ExecuteScalar().ToString();
dt.Rows.Add(title, "Message text", Layouts.getTimeFormat(time), type, creator);
}
}
}
connect.Close();
grdResults.DataSource = dt;
grdResults.DataBind();
grdResults.Visible = true;
rebindValues();
}
public static int Arrange(IEnumerable<BaseModel> models, Layouts style, int snapHeight = 150)
{
int max = 0;
int[][] setup = null;
int[] remainder = null;
switch (style)
{
case Layouts.WideStyle1With8:
setup = new[]
{
new[] { 300, 300 },
new[] { 150, 200 },
new[] { 150, 200 },
new[] { 300, 200 },
new[] { 300, 300 },
new[] { 175, 166 },
new[] { 175, 166 },
new[] { 175, 166 },
};
remainder = new[] { 150, 166 };
max = 600;
break;
case Layouts.WideStyle1With7:
setup = new[]
{
new[] { 250, 250 },
new[] { 250, 250 },
new[] { 250, 166 },
new[] { 250, 332 },
new[] { 250, 250 },
new[] { 125, 250 },
new[] { 125, 250 },
};
remainder = new[] { 150, 166 };
max = 600;
break;
case Layouts.WideStyle2With7:
setup = new[] {
new[] { 350, 225 },
new[] { 175, 275 },
new[] { 175, 275 },
new[] { 275, 300 },
new[] { 225, 200 },
new[] { 225, 200 },
new[] { 175, 300 },
};
remainder = new[] { 150, 166 };
max = 600;
break;
case Layouts.NarrowStyle1With7:
setup = new[] {
new[] { 150, 300 },
new[] { 300, 150 },
new[] { 300, 150 },
new[] { 300, 300 },
new[] { 150, 300 },
new[] { 150, 150 },
new[] { 300, 150 },
};
remainder = new[] { 150, 150 };
max = 450;
break;
case Layouts.NarrowStyle2With7:
setup = new[] {
new[] { 300, 300 },
new[] { 150, 150 },
new[] { 150, 150 },
new[] { 150, 300 },
new[] { 150, 150 },
new[] { 150, 150 },
new[] { 300, 150 },
};
remainder = new[] { 150, 150 };
max = 450;
break;
case Layouts.NarrowStyle1With8:
setup = new[] {
new[] { 300, 300 },
new[] { 150, 150 },
new[] { 150, 300 },
new[] { 300, 150 },
new[] { 150, 150 },
new[] { 300, 150 },
new[] { 300, 150 },
new[] { 150, 150 },
};
remainder = new[] { 150, 150 };
max = 450;
break;
case Layouts.Snap:
setup = new int[][] { };
remainder = new[] { 240, snapHeight };
break;
}
// initial
foreach (var item in models.Take(setup.Length).Select((x, i) => new { Index = i, Item = x }))
{
item.Item.ColSpan = setup[item.Index][0];
item.Item.RowSpan = setup[item.Index][1];
}
// remainder
foreach (var item in models.Skip(setup.Length))
{
item.ColSpan = remainder[0];
item.RowSpan = remainder[1];
}
// max for variable sezed wrapgrid
return max;
}
