protected void Page_Load(object sender, EventArgs e)
{
var createdColumn = new BoundField();
createdColumn.DataField = "Created";
createdColumn.HeaderText = "Datum";
createdColumn.DataFormatString = "{0:dd-MM-yyyy}";
var deliveryPriceColumn = new BoundField();
deliveryPriceColumn.HeaderText = "Verzendkosten";
deliveryPriceColumn.DataField = "DeliveryPrice";
deliveryPriceColumn.DataFormatString = "{0:C}";
var viewColumn = new HyperLinkField();
viewColumn.Text = "Bekijk";
viewColumn.Target = "_blank";
viewColumn.DataNavigateUrlFormatString = this.Request.Url.AbsolutePath + "?page=Order&order={0}";
viewColumn.DataNavigateUrlFields = new[] { "Id" };
var pdfColumn = new HyperLinkField();
pdfColumn.Text = "PDF";
pdfColumn.Target = "_blank";
pdfColumn.DataNavigateUrlFormatString = this.Request.Url.AbsolutePath + "?page=Order&method=Pdf&order={0}";
pdfColumn.DataNavigateUrlFields = new[] { "Id" };
this.GridViewOrders.Columns.Add(createdColumn);
this.GridViewOrders.Columns.Add(deliveryPriceColumn);
this.GridViewOrders.Columns.Add(viewColumn);
this.GridViewOrders.Columns.Add(pdfColumn);
this.GridViewOrders.AutoGenerateColumns = false;
this.GridViewOrders.DataSource = new BusinessLogicLayer.Order().GetAll();
this.GridViewOrders.DataBind();
}
protected void GenerateColumns()
{
// remove all previous rows because we set EnableViewState="True"
gvScholPrograms.Columns.Clear();
/* set ScholID as the primary keys of each row */
gvScholPrograms.DataKeyNames = new string[] { "ScholID" };
/* 1st column = Scholarship Name */
HyperLinkField hlf = new HyperLinkField();
hlf.HeaderText = TextCode(10421);
hlf.HeaderStyle.CssClass = "leftAlign";
hlf.SortExpression = "ScholName";
hlf.DataTextField = "ScholName";
hlf.DataNavigateUrlFields = new string[] { "ScholID" };
hlf.DataNavigateUrlFormatString = "ScholAppDetailsPrinterFriendly.aspx?LoginID=" + LoginID + "&ScholID={0}";
hlf.ItemStyle.CssClass = "leftAlign";
gvScholPrograms.Columns.Add(hlf);
/* 2nd column = Deadline */
BoundField bf2 = new BoundField();
bf2.HeaderText = TextCode(10422);
bf2.SortExpression = "DeadlineSorting";
bf2.DataField = "Deadline";
bf2.ItemStyle.CssClass = "leftAlign";
gvScholPrograms.Columns.Add(bf2);
/* 3rd column = Status */
BoundField bf3 = new BoundField();
bf3.HeaderText = TextCode(10423);
bf3.SortExpression = "Status";
bf3.DataField = "Status";
bf3.ItemStyle.CssClass = "leftAlign";
gvScholPrograms.Columns.Add(bf3);
}
protected override void CopyProperties(DataControlField newField)
{
base.CopyProperties(newField);
HyperLinkField field = (HyperLinkField)newField;
field.DataNavigateUrlFields = DataNavigateUrlFields;
field.DataNavigateUrlFormatString = DataNavigateUrlFormatString;
field.DataTextField = DataTextField;
field.DataTextFormatString = DataTextFormatString;
field.NavigateUrl = NavigateUrl;
field.Target = Target;
field.Text = Text;
}
/// <summary>
///
/// </summary>
private HyperLinkField CreateHyperLinkField()
{
HyperLinkField hlField = new HyperLinkField();
hlField.Text = "详细";
hlField.DataNavigateUrlFields = new string[] { "WaterUserID" };
// url format string
//
string urlFormatString = string.Format("{0}?WaterUserID={{0}}&Begin={1}&End={2}",
"pDataHistory.aspx",
Server.UrlEncode(this.UCWaterUserListDTTwo1.Begin.ToString()),
Server.UrlEncode(this.UCWaterUserListDTTwo1.End.ToString()));
hlField.DataNavigateUrlFormatString = urlFormatString;
return hlField;
}
protected void GenerateColumns()
{
// remove all previous rows because we set EnableViewState="True"
gvScholPrograms.Columns.Clear();
/* set ScholID as the primary keys of each row */
gvScholPrograms.DataKeyNames = new string[] { "ScholID" };
/* 1st column = Scholarship Name */
HyperLinkField hlf = new HyperLinkField();
hlf.HeaderText = TextCode(10421);
hlf.HeaderStyle.CssClass = "leftAlign";
hlf.SortExpression = "ScholName";
hlf.DataTextField = "ScholName";
hlf.DataNavigateUrlFields = new string[] {"ScholID"};
hlf.DataNavigateUrlFormatString = "ScholarshipAppDetails.aspx?LoginID=" + LoginID + "&ScholID={0}";
hlf.ItemStyle.CssClass = "leftAlign";
gvScholPrograms.Columns.Add(hlf);
/* 2nd column = Deadline */
BoundField bf2 = new BoundField();
bf2.HeaderText = TextCode(10422);
bf2.SortExpression = "DeadlineSorting";
bf2.DataField = "Deadline";
bf2.ItemStyle.CssClass = "leftAlign";
gvScholPrograms.Columns.Add(bf2);
/* 3rd column = Status */
BoundField bf3 = new BoundField();
bf3.HeaderText = TextCode(10423);
bf3.SortExpression = "Status";
bf3.DataField = "Status";
bf3.ItemStyle.CssClass = "leftAlign";
gvScholPrograms.Columns.Add(bf3);
/* 4 column = Options */
CommandField cf = new CommandField();
cf.HeaderText = TextCode(9234);
cf.ButtonType = ButtonType.Image;
cf.ShowDeleteButton = true;
cf.DeleteImageUrl = "/media/shared/ico_delete.gif";
cf.DeleteText = TextCode(3488);
cf.ShowEditButton = true;
cf.EditImageUrl = "/media/shared/ico_edit.gif";
cf.EditText = TextCode(3489);
gvScholPrograms.Columns.Add(cf);
}
/**
* Por si quiero iterar solo sobre el panel
* ContentPlaceHolder cp = (ContentPlaceHolder)this.Master.FindControl("modalCarga");
**/
protected void GenerarColumnas(GridView gv)
{
if (gv.Columns.Count == 0)
{
Type tipoCompleto = gv.DataSource.GetType().GetGenericArguments()[0];
BindingFlags flags = BindingFlags.Public | BindingFlags.Instance;
PropertyInfo[] properties = tipoCompleto.GetProperties(flags);
string[] palabras = tipoCompleto.ToString().Split('.');
string tipo = palabras.Last();
int totalColumnas = 0;
Unit u = new Unit("30px");
foreach (PropertyInfo property in properties)
{
var oTipo = property.PropertyType;
if (!(oTipo.IsGenericType && (oTipo.GetGenericTypeDefinition() == typeof(List<>))))
{
BoundField bf = new BoundField();
bf.HeaderText = property.Name;
bf.DataField = property.Name;
gv.Columns.Add(bf);
}
}
HyperLinkField enlaceEdicion = new HyperLinkField();
enlaceEdicion.Text = "<span class='glyphicon glyphicon-edit'></span>";
enlaceEdicion.DataNavigateUrlFields = new string[] { "Id" };
enlaceEdicion.DataNavigateUrlFormatString = "Edit/" + tipo + "?Id={0}";
enlaceEdicion.ItemStyle.Width = u;
gv.Columns.Add(enlaceEdicion);
HyperLinkField enlaceBorrado = new HyperLinkField();
enlaceBorrado.Text = "<span class='glyphicon glyphicon-remove'></span>";
enlaceBorrado.DataNavigateUrlFields = new string[] { "Id" };
enlaceBorrado.DataNavigateUrlFormatString = "Remove/" + tipo + "?Id={0}";
enlaceBorrado.ItemStyle.Width = u;
gv.Columns.Add(enlaceBorrado);
totalColumnas = gv.Columns.Count;
}
}
/// <summary>
/// 为PRPO的报表添加可查看PO详细信息的链接。
/// </summary>
void BindPRPOGrid()
{
if (SPGridView1.Columns.Count > 0)
{
return;
}
BoundField BFPRNO = new BoundField();
BFPRNO.DataField = "PR Number";
BFPRNO.HeaderText = "PR Number";
SPGridView1.Columns.Add(BFPRNO);
HyperLinkField HLFPONO = new HyperLinkField();
HLFPONO.HeaderText = "PO Number";
string[] pram = { "PO Number" };
HLFPONO.DataNavigateUrlFields = pram;
HLFPONO.DataNavigateUrlFormatString = "PORedirct.aspx?PONO={0}";//PORedirct
HLFPONO.DataTextField = "PO Number";
SPGridView1.Columns.Add(HLFPONO);
BoundField BFCost = new BoundField();
BFCost.DataField = "PO Cost";
BFCost.HeaderText = "PO Cost";
SPGridView1.Columns.Add(BFCost);
BoundField BFVendor = new BoundField();
BFVendor.DataField = "Vendor Name";
BFVendor.HeaderText = "Vendor Name";
SPGridView1.Columns.Add(BFVendor);
BoundField BFIsGR = new BoundField();
BFIsGR.DataField = "Is Complete GR/SR";
BFIsGR.HeaderText = "Is Complete GR/SR";
SPGridView1.Columns.Add(BFIsGR);
}
public override DataControlFieldsEditor.FieldItem CreateField()
{
HyperLinkField runtimeField = new HyperLinkField();
DataControlFieldsEditor.FieldItem item = new DataControlFieldsEditor.HyperLinkFieldItem(this._fieldsEditor, runtimeField) {
Text = this.hyperLinkText
};
item.LoadFieldInfo();
return item;
}
private void FillMSARecommendationWorkQueue(SPWeb oSPWeb, SPUser currentUser)
{
try
{
if (oSPWeb != null)
{
string getName = string.Empty;
DataTable dt = new DataTable();
dt.Columns.Add("ItemID", typeof(int));
dt.Columns.Add("RecommendationNo", typeof(string));
dt.Columns.Add("ResponsiblePerson", typeof(string));
dt.Columns.Add("TargetDate", typeof(string));
dt.Columns.Add("TaskName", typeof(string));
dt.Columns.Add("LinkFileName", typeof(string));
dt.Columns.Add("LinkDisplayText", typeof(string));
string listName = "MSARecommendation";
// Fetch the List
SPList splistMSARecommendation = oSPWeb.GetList(string.Format("{0}/Lists/{1}/AllItems.aspx", oSPWeb.Url, listName));
SPQuery query = new SPQuery();
SPListItemCollection spListItems;
// Include only the fields you will use.
StringBuilder vf = new StringBuilder();
vf.Append("<FieldRef Name='ID' />")
.Append("<FieldRef Name='MSARecommendationDescription'/>")
.Append("<FieldRef Name='TargetDate'/>")
.Append("<FieldRef Name='ResponsiblePerson'/>")
.Append("<FieldRef Name='ApprovedBy'/>")
.Append("<FieldRef Name='ResponsibleDepartment'/>")
.Append("<FieldRef Name='AssigneeEmail'/>")
.Append("<FieldRef Name='RecommendationNo'/>");
query.ViewFields = vf.ToString();
query.ViewFieldsOnly = true;
query.Query = "<Where><And><And><Neq><FieldRef Name='Status' /><Value Type='Text'>Completed</Value></Neq><Eq><FieldRef Name='AssigneeEmail' /><Value Type='Text'>" + currentUser.Email + "</Value></Eq></And><Eq><FieldRef Name='IsSavedAsDraft' /><Value Type='Boolean'>0</Value></Eq></And></Where>";
//query.Query = "<Where><And><Eq><FieldRef Name='AssigneeEmail' /><Value Type='Text'>" + currentUser.Email + "</Value></Eq><Eq><FieldRef Name='IsSavedAsDraft' /><Value Type='Boolean'>0</Value></Eq></And></Where>";
spListItems = splistMSARecommendation.GetItems(query);
DataRow dr;
if (spListItems != null && spListItems.Count > 0)
{
foreach (SPListItem item in spListItems)
{
dr = dt.NewRow();
dr["ItemID"] = item["ID"];
dr["RecommendationNo"] = item["RecommendationNo"] != null ? Convert.ToString(item["RecommendationNo"]) : "";
string rpUsername = item["ResponsiblePerson"] != null ? Convert.ToString(item["ResponsiblePerson"]) : "";
SPUser responsiblePerson = null;
if (!String.IsNullOrEmpty(rpUsername))
{
responsiblePerson = Utility.GetUser(oSPWeb, rpUsername);
if (responsiblePerson != null)
{
dr["ResponsiblePerson"] = responsiblePerson.Name;
}
}
DateTime date;
bool bValid = DateTime.TryParse(Convert.ToString(item["TargetDate"]), new CultureInfo("en-GB"), DateTimeStyles.AssumeLocal, out date);
if (bValid)
{
dr["TargetDate"] = date.ToShortDateString();
}
else
{
try
{
dr["TargetDate"] = Convert.ToDateTime(Convert.ToString(item["TargetDate"])).ToShortDateString();
}
catch (Exception ex)
{
SPDiagnosticsService.Local.WriteTrace(0, new SPDiagnosticsCategory("WQ-TRGD:" + Convert.ToString(item["TargetDate"]), TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected, ex.Message, ex.StackTrace);
}
}
dr["TaskName"] = "MSA Recommendation";
string recommendationLink = Utility.GetRedirectUrl("MSARecommendationFormLink");
dr["LinkFileName"] = string.Format("{0}?MSARID=" + item["ID"], recommendationLink);
if (String.IsNullOrEmpty(Convert.ToString(item["ApprovedBy"])))
{
if (getHOD(oSPWeb, Convert.ToString(item["ResponsibleDepartment"]), responsiblePerson.Email))
{
dr["LinkDisplayText"] = "View (for approval)";
}
else
{
dr["LinkDisplayText"] = "View (for submission)";
}
}
else
{
if (Convert.ToString(item["ApprovedBy"]).Equals(Convert.ToString(item["AssigneeEmail"]),StringComparison.OrdinalIgnoreCase))
{
dr["LinkDisplayText"] = "View (for approval)";
}
else
{
dr["LinkDisplayText"] = "View (for submission)";
}
}
dt.Rows.Add(dr);
}
}
BoundField bf = new BoundField();
bf.DataField = "ItemID";
bf.HeaderText = "ID #";
grdMSARecommendationTask.Columns.Add(bf);
//RecommendationNo Column
bf = new BoundField();
bf.DataField = "RecommendationNo";
bf.HeaderText = "Recommendation No";
grdMSARecommendationTask.Columns.Add(bf);
bf = new BoundField();
bf.DataField = "ResponsiblePerson";
bf.HeaderText = "Responsible Person";
grdMSARecommendationTask.Columns.Add(bf);
bf = new BoundField();
bf.DataField = "TargetDate";
bf.HeaderText = "Target Date";
grdMSARecommendationTask.Columns.Add(bf);
HyperLinkField hyperlinkField = new HyperLinkField();
hyperlinkField.HeaderText = "View Recommendations";
hyperlinkField.DataNavigateUrlFields = new[] { "LinkFileName" };
//hyperlinkField.Text = "View";
hyperlinkField.DataTextField = "LinkDisplayText";
grdMSARecommendationTask.Columns.Add(hyperlinkField);
grdMSARecommendationTask.DataSource = dt;
grdMSARecommendationTask.DataBind();
}
}
catch (Exception ex)
{
SPDiagnosticsService.Local.WriteTrace(0, new SPDiagnosticsCategory("SL.FG.FFL(WorkQueue->FillMSARecommendationWorkQueue)", TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected, ex.Message, ex.StackTrace);
message_div.InnerHtml = "Something went wrong!!! Please Contact the administrator.";
}
}
/// <summary>
/// Adds the column with a link to profile page.
/// </summary>
private void AddPersonProfileLinkColumn()
{
HyperLinkField hlPersonProfileLink = new HyperLinkField();
hlPersonProfileLink.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
hlPersonProfileLink.HeaderStyle.CssClass = "grid-columncommand";
hlPersonProfileLink.ItemStyle.CssClass = "grid-columncommand";
hlPersonProfileLink.DataNavigateUrlFields = new string[1] { "PersonId" };
hlPersonProfileLink.DataNavigateUrlFormatString = LinkedPageUrl( "PersonProfilePage", new Dictionary<string, string> { { "PersonId", "###" } } ).Replace( "###", "{0}" );
hlPersonProfileLink.DataTextFormatString = "<div class='btn btn-default'><i class='fa fa-user'></i></div>";
hlPersonProfileLink.DataTextField = "PersonId";
gGroupMembers.Columns.Add( hlPersonProfileLink );
}
public void HyperLinkField_AssignProperty ()
{
HyperLinkField field = new HyperLinkField ();
field.DataNavigateUrlFields = new string[] { "test1", "test2" };
Assert.AreEqual (2, ((Array) field.DataNavigateUrlFields).Length, "DataNavigateUrlFieldsCount");
Assert.AreEqual ("test1", field.DataNavigateUrlFields[0], "DataNavigateUrlFields#1");
Assert.AreEqual ("test2", field.DataNavigateUrlFields[1], "DataNavigateUrlFields#2");
field.DataNavigateUrlFormatString = "test";
Assert.AreEqual ("test", field.DataNavigateUrlFormatString, "DataNavigateUrlFormatString");
field.DataTextField = "test";
Assert.AreEqual ("test", field.DataTextField, "DataTextField");
field.DataTextFormatString = "test";
Assert.AreEqual ("test", field.DataTextFormatString, "DataTextFormatString");
field.NavigateUrl = "test";
Assert.AreEqual ("test", field.NavigateUrl, "NavigateUrl");
field.Target = "test";
Assert.AreEqual ("test", field.Target, "Target");
field.Text = "test";
Assert.AreEqual ("test", field.Text, "Text");
}
/// <summary>
/// 添加自定义列到Grid的Column中
/// </summary>
/// <param name="column"></param>
void AddToGridColumn(GridColumn column)
{
FieldType type = column.type;
switch (type)
{
case FieldType.LineNumberField:
LineNumberField lnf = new LineNumberField();
lnf.IsContinuousArrange = true;
lnf.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
lnf.HeaderStyle.Width = column.unit;
lnf.ItemStyle.Width = column.unit;
lnf.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
this.Columns.Add(lnf);
break;
case FieldType.BoundField:
BoundField bf = new BoundField();
bf.HeaderText = column.headerName;
bf.HeaderStyle.Width = column.unit;
bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
bf.DataField = column.fieldName;
bf.ItemStyle.Width = column.unit;
bf.ItemStyle.HorizontalAlign = column.hAlign;
bf.SortExpression = column.fieldName;
this.Columns.Add(bf);
break;
case FieldType.ButtonField:
ButtonField btn = new ButtonField();
btn.HeaderText = column.headerName;
btn.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
btn.HeaderStyle.Width = column.unit;
btn.HeaderStyle.Wrap = false;
btn.ButtonType = column.button;
btn.ItemStyle.Width = column.unit;
btn.ItemStyle.HorizontalAlign = column.hAlign;
if (btn.ButtonType == ButtonType.Image)
{
btn.ImageUrl = column.fieldName;
}
else
{
btn.Text = column.fieldName;
}
btn.CommandName = column.commandName;
this.Columns.Add(btn);
break;
case FieldType.RadioButtonField:
RadioButtonField rbf = new RadioButtonField();
rbf.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
rbf.HeaderStyle.Width = column.unit;
rbf.ItemStyle.Width = column.unit;
this.Columns.Add(rbf);
break;
case FieldType.CheckBoxExField:
CheckBoxExField cbef = new CheckBoxExField();
cbef.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
cbef.HeaderStyle.Width = column.unit;
cbef.ItemStyle.Width = column.unit;
cbef.CheckedValue = "1";
this.Columns.Add(cbef);
break;
case FieldType.CheckBoxField:
CheckBoxField cbf = new CheckBoxField();
cbf.HeaderText = column.headerName;
cbf.DataField = column.fieldName;
cbf.ItemStyle.HorizontalAlign = column.hAlign;
this.Columns.Add(cbf);
break;
case FieldType.HyperLinkField:
HyperLinkField hf = new HyperLinkField();
//hf.Text = column.headerName;
hf.HeaderText = column.headerName;
if (string.IsNullOrEmpty(column.text))
{
hf.DataTextField = column.fieldName;
}
else
{
hf.Text = column.text;
}
hf.ItemStyle.HorizontalAlign = column.hAlign;
hf.Target = column.target;
hf.DataNavigateUrlFields = column.dataNavigateUrlFields;
hf.DataNavigateUrlFormatString = column.dataNavigateUrlFormatString;
this.Columns.Add(hf);
break;
case FieldType.LinkButtonTemplate:
LinkButtonTemplate lbt = column._linkButtonTemplate;
TemplateField templateLinkButtonField = new TemplateField();
templateLinkButtonField.ItemTemplate = lbt;
templateLinkButtonField.HeaderText = column.headerName;
templateLinkButtonField.HeaderStyle.Width = templateLinkButtonField.ItemStyle.Width = column.unit;
templateLinkButtonField.HeaderStyle.HorizontalAlign = templateLinkButtonField.ItemStyle.HorizontalAlign = column.hAlign;
this.Columns.Add(templateLinkButtonField);
break;
case FieldType.DialogButtonTemplate:
DialogButtonTemplate dialogButtonTemplate = column._dialogButtonTemplate;
TemplateField templateField = new TemplateField();
templateField.ItemTemplate = dialogButtonTemplate;
templateField.HeaderText = column.headerName;
templateField.HeaderStyle.Width = templateField.ItemStyle.Width = column.unit;
templateField.HeaderStyle.HorizontalAlign = templateField.ItemStyle.HorizontalAlign = column.hAlign;
this.Columns.Add(templateField);
break;
case FieldType.TextBoxTemplate:
TextBoxTemplate tb = column._textBoxTemplate;
TemplateField ttb = new TemplateField();
ttb.ItemTemplate = tb;
ttb.HeaderText = column.headerName;
ttb.HeaderStyle.Width = ttb.ItemStyle.Width = column.unit;
ttb.HeaderStyle.HorizontalAlign = ttb.ItemStyle.HorizontalAlign = column.hAlign;
this.Columns.Add(ttb);
break;
case FieldType.ButtonTemplate:
ButtonTemplate bt = column._buttonTemplate;
TemplateField templateButtonField = new TemplateField();
templateButtonField.ItemTemplate = bt;
templateButtonField.HeaderText = column.headerName;
templateButtonField.HeaderStyle.Width = templateButtonField.ItemStyle.Width = column.unit;
templateButtonField.HeaderStyle.HorizontalAlign = templateButtonField.ItemStyle.HorizontalAlign = column.hAlign;
this.Columns.Add(templateButtonField);
break;
default:
if (column._dataControlField != null)
{
this.Columns.Add(column._dataControlField);
}
break;
}
}
protected void Query_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(Database.SelectedValue)) return;
if (string.IsNullOrEmpty(TableNames.SelectedValue)) return;
var categoryData = ViewState["Category"] as List<Category>;
var sub = categoryData.SelectMany(c => c.SubCategoryList).Where(sc => sc.Name == Database.SelectedValue).SingleOrDefault();
if (sub == null) return;
var data = service.GetTableData(sub.DatabasePrefix, new List<string> { TableNames.SelectedValue }, DateTime.Parse(StartTime.Text), DateTime.Parse(EndTime.Text), 0, 10, null).First();
var pkColumn = "";
var dataTable = new DataTable(data.TableName);
if (data.Data.Count > 0)
{
foreach (var column in data.Data.OrderByDescending(item => item.Values.Count).First())
{
if (column.Key.StartsWith("#"))
pkColumn = column.Key;
dataTable.Columns.Add(column.Key);
}
foreach (var row in data.Data)
{
var dataRow = dataTable.NewRow();
foreach (var column in row)
{
dataRow[column.Key] = column.Value;
}
dataTable.Rows.Add(dataRow);
}
}
GridView1.Columns.Clear();
GridView1.DataSource = dataTable;
HyperLinkField objHC = new HyperLinkField();
objHC.DataNavigateUrlFields = new string[] { pkColumn };
objHC.DataTextField = pkColumn;
objHC.DataNavigateUrlFormatString = "Detail.aspx?Id={0}" + "&DatabaseName=" + data.DatabaseName + "&TableName=" + data.TableName + "&pkColumnName=" + pkColumn.TrimStart('#') + "&databasePrefix=" + sub.DatabasePrefix;
GridView1.Columns.Add(objHC);
GridView1.DataBind();
}
private void Perfil( int perfil , string sql , string patron= null)
{
Conexion conn = new Conexion();
conn.IniciarConexion();
try
{
List<string> listacursos = new List<string>() ;
MySqlDataAdapter adaptador_ = new MySqlDataAdapter(sql, conn.GetConexion);
DataSet ds = new DataSet();
adaptador_.Fill(ds);
DataTable dt_aux = ds.Tables[0];
DataTable dt = new DataTable();
int col = Grilla_datos.Columns.Count;
if (dt_aux.Rows.Count <= 0)
{
cuadro_error.Visible = true;
cuadro_error.InnerHtml = "<p align='center'> NO SE ENCONTRARON RESULTADOS , FAVOR INTENTAR DENUEVO </P>";
}
else
cuadro_error.Visible = false;
Grilla_datos.Columns.Clear();
Grilla_datos.AutoGenerateColumns = false;
dt.Columns.Add("imagen");
dt.Columns.Add("nombre");
dt.Columns.Add("estado");
dt.Columns.Add("docente");
dt.Columns.Add("fecha");
dt.Columns.Add("abierto");
dt.Columns.Add("registrar");
dt.Columns.Add("comentarios");
try
{
if (perfil == 0)
{
string query = "select id_curso from estudiante_curso where id_user like '" + id_usuario + "'";
List<object> list = conn.Get_Consulta(query);
if (list.Count != 0)
{
for (int i = 0; i < list.Count; i++)
{
object[] objeto_lista = (object[])list[i];
listacursos.Add(objeto_lista[0].ToString());
}
}
}
else if (perfil == 1)
{
string query = "select id_curso from estudiante_curso where id_user like '" + id_usuario + "'";
List<object> list = conn.Get_Consulta(query);
if (list.Count != 0)
{
for (int i = 0; i < list.Count; i++)
{
object[] objeto_lista = (object[])list[i];
listacursos.Add(objeto_lista[0].ToString());
}
}
}
}
catch { }
foreach (DataRow rows in dt_aux.Rows)
{
object[] obj = rows.ItemArray;
obj[0] = Seguridad.HttpUrl + "/images/cursos/" + obj[0];
if (Convert.ToInt32(obj[2]) == 1)
obj[2] = "Activo";
else
obj[2] = "No activo";
if (Convert.ToInt32(obj[5]) == 0)
{
obj[5] = Seguridad.HttpUrl + "/images/icons/candado1.png";
obj[7] = "Curso exclusivo ";
}
else
{
obj[5] = Seguridad.HttpUrl + "/images/icons/candado0.png";
obj[7] = "Curso para todo publico ";
}
int bandera = 0;
if (listacursos.Count != 0)
{
foreach (string cursos_actuales in listacursos)
{
if (cursos_actuales != obj[6].ToString())
{
bandera = 0;
continue;
}
else
{
bandera = 1;
break;
}
}
}
if (bandera == 1)
{
obj[7] += " , [Ya estas registrado]";
obj[6] = null;
}
else
obj[6] = "" + Encriptador.Encriptar_Md5(obj[6].ToString());
dt.Rows.Add(obj);
}
ImageField img = new ImageField();
DataControlField Dcontrol;
img.ShowHeader = true;
img.HeaderText = "";
img.DataImageUrlField = "imagen";
img.ControlStyle.Width = 100;
img.ControlStyle.Height = 100;
Dcontrol = img;
Grilla_datos.Columns.Add(img);
BoundField Bcampo = new BoundField();
Bcampo.HeaderText = "NOMBRE CURSO ";
Bcampo.DataField = "nombre";
Dcontrol = Bcampo;
Grilla_datos.Columns.Add(Bcampo);
Bcampo = new BoundField();
Bcampo.HeaderText = "ESTADO ";
Bcampo.DataField = "estado";
Dcontrol = Bcampo;
Grilla_datos.Columns.Add(Bcampo);
Bcampo = new BoundField();
Bcampo.HeaderText = "DOCENTE DEL CURSO ";
Bcampo.DataField = "docente";
Dcontrol = Bcampo;
Grilla_datos.Columns.Add(Bcampo);
Bcampo = new BoundField();
Bcampo.HeaderText = "INICIO EL ";
Bcampo.DataField = "fecha";
Dcontrol = Bcampo;
Grilla_datos.Columns.Add(Bcampo);
img = new ImageField();
img.ShowHeader = true;
img.HeaderText = "ENTRADA ";
img.DataImageUrlField = "abierto";
img.ControlStyle.Width = 25;
img.ControlStyle.Height =25;
Dcontrol = img;
Grilla_datos.Columns.Add(img);
HyperLinkField link = new HyperLinkField();
link.HeaderText = "REGISTRAR CURSO";
link.Text = "Registrar";
link.DataNavigateUrlFields = new string[] { "registrar" };
link.DataNavigateUrlFormatString = "RegistrarCurso.aspx?id={0}";
link.NavigateUrl = "hola.aspx";
Dcontrol = link;
Grilla_datos.Columns.Add(link);
Bcampo = new BoundField();
Bcampo.HeaderText = "COMENTARIOS ";
Bcampo.DataField = "comentarios";
Dcontrol = Bcampo;
Grilla_datos.Columns.Add(Bcampo);
Grilla_datos.DataSource = dt;
Grilla_datos.DataBind();
conn.CerrarConexion();
return;
}
catch (Exception ex) {
try
{
Log.Set_Log_Error(ex.Message , "buscar cursos " , id_usuario);
conn.CerrarConexion();
}
catch {}
}
cuadro_error.Visible = true;
cuadro_error.InnerHtml = "<p align='center'> NO SE ENCONTRARON RESULTADOS , FAVOR INTENTAR DENUEVO </P>";
return;
}
/// <summary>
/// The page_ load.
/// </summary>
/// <param name="sender">
/// The sender.
/// </param>
/// <param name="e">
/// The e.
/// </param>
protected void Page_Load(object sender, EventArgs e)
{
if (this.Products.Count == 0)
{
this.Response.Redirect("/");
}
this.FirstNameDelivery.Text = this.User.ShippingAddress.Address.FirstName;
this.FirstNameInvoice.Text = this.User.InvoiceAddress.Address.FirstName;
this.LastNameDelivery.Text = this.User.ShippingAddress.Address.LastName;
this.LastNameInvoice.Text = this.User.InvoiceAddress.Address.LastName;
this.CompanyNameDelivery.Text = this.User.ShippingAddress.Address.CompanyName;
this.CompanyNameInvoice.Text = this.User.InvoiceAddress.Address.CompanyName;
this.PostalCodeDelivery.Text = this.User.ShippingAddress.Address.PostalCode;
this.PostalCodeInvoice.Text = this.User.InvoiceAddress.Address.PostalCode;
this.AddressNumberDelivery.Text = this.User.ShippingAddress.Address.AddressNumber;
this.AddressNumbeInvoice.Text = this.User.InvoiceAddress.Address.AddressNumber;
var nameColumn = new HyperLinkField();
nameColumn.DataTextField = "Name";
nameColumn.HeaderText = "Naam";
nameColumn.Target = "_blank";
nameColumn.DataNavigateUrlFormatString = this.Request.Url.AbsolutePath + "?page=Product&product={0}";
nameColumn.DataNavigateUrlFields = new[] { "Id" };
var amountColumn = new BoundField();
amountColumn.DataField = "Amount";
amountColumn.HeaderText = "Aantal";
var priceColumn = new BoundField();
priceColumn.DataField = "Price";
priceColumn.HeaderText = "Prijs";
priceColumn.DataFormatString = "{0:C}";
priceColumn.FooterText = "<strong>Totaal</strong>";
var totalColumn = new BoundField();
totalColumn.DataField = "Total";
totalColumn.HeaderText = "Totaal";
totalColumn.DataFormatString = "{0:C}";
totalColumn.FooterText = this.Products.Sum(x => x.Total).ToString("C");
this.GridViewProducts.ShowFooter = true;
this.GridViewProducts.AutoGenerateColumns = false;
this.GridViewProducts.Columns.Clear();
this.GridViewProducts.Columns.Add(nameColumn);
this.GridViewProducts.Columns.Add(amountColumn);
this.GridViewProducts.Columns.Add(priceColumn);
this.GridViewProducts.Columns.Add(totalColumn);
this.GridViewProducts.DataSource = this.Products;
this.GridViewProducts.DataBind();
}
void atualizarGrelha()
{
//limpar grelha
GridView1.Columns.Clear();
DataTable dados = bd.devolveConsulta("SELECT * FROM produto");
if (dados == null || dados.Rows.Count == 0) return;
//adicionar coluna remover
DataColumn cRemover = new DataColumn();
cRemover.ColumnName = "Remover";
cRemover.DataType = Type.GetType("System.String");
dados.Columns.Add(cRemover);
//adicionar coluna editar
DataColumn cEditar = new DataColumn();
cEditar.ColumnName = "Editar";
cEditar.DataType = Type.GetType("System.String");
dados.Columns.Add(cEditar);
//associar datatable
GridView1.DataSource = dados;
GridView1.AutoGenerateColumns = false;
//definir as colunas manualmente
//coluna remover
HyperLinkField lnkRemover = new HyperLinkField();
lnkRemover.HeaderText = "Remover";
lnkRemover.DataTextField = "Remover"; //nome da coluna no datatable
lnkRemover.Text = "Remover";
lnkRemover.DataNavigateUrlFormatString = "removerproduto.aspx?id={0}";
lnkRemover.DataNavigateUrlFields = new string[] {"id" };
GridView1.Columns.Add(lnkRemover);////////////////////////////////////
//coluna editar
HyperLinkField lnkEditar = new HyperLinkField();
lnkEditar.HeaderText = "Editar";
lnkEditar.DataTextField = "Editar";
lnkEditar.Text = "Editar";
lnkEditar.DataNavigateUrlFormatString = "editarproduto.aspx?id={0}";
lnkEditar.DataNavigateUrlFields = new string[] { "id" };
GridView1.Columns.Add(lnkEditar);
//coluna id
BoundField bfId = new BoundField();
bfId.DataField = "id";
bfId.HeaderText = "Id";
GridView1.Columns.Add(bfId);
//coluna descrição
BoundField bfDesc = new BoundField();
bfDesc.DataField = "descricao";
bfDesc.HeaderText = "Descrição";
GridView1.Columns.Add(bfDesc);
//coluna preço
BoundField bfPreco = new BoundField();
bfPreco.DataField = "preco";
bfPreco.HeaderText = "Preço";
GridView1.Columns.Add(bfPreco);
//coluna quantidade
BoundField bfQuant = new BoundField();
bfQuant.DataField = "quantidade";
bfQuant.HeaderText = "Quantidade";
GridView1.Columns.Add(bfQuant);
//Imagem
ImageField imagem = new ImageField();
imagem.DataImageUrlFormatString = "~/Imagens/{0}.jpg";
imagem.DataImageUrlField = "id";
imagem.HeaderText = "Imagem";
imagem.ControlStyle.Width = 100;
GridView1.Columns.Add(imagem);
//refresh/bind
GridView1.DataBind();
}
private void FillMSAScheduleWorkQueue(SPWeb oSPWeb, SPUser currentUser)
{
try
{
DataTable dt = new DataTable();
dt.Columns.Add("AreaAudited", typeof(string));
dt.Columns.Add("StartTime", typeof(string));
dt.Columns.Add("EndTime", typeof(string));
dt.Columns.Add("LinkFileName", typeof(string));
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite oSPSite = new SPSite(SPContext.Current.Web.Url))
{
using (SPWeb pSPWeb = oSPSite.OpenWeb())
{
SPList spList = pSPWeb.Lists["MSA Schedule"];
SPQuery spQuery = new SPQuery();
StringBuilder sb = new StringBuilder();
sb.Append("<Where>")
.Append("<And>")
.Append("<Eq>")
.Append("<FieldRef Name='FFLScheduleName' />")
.Append("<Value Type='User'>" + currentUser.Name + "</Value>")
.Append("</Eq>")
.Append("</Where>");
string strQuery = "<Where><And><And><Eq><FieldRef Name='FFLScheduleName' LookupId='TRUE' /><Value Type='Integer' >" + currentUser.ID + "</Value></Eq><Geq><FieldRef Name='EventDate' /><Value Type='DateTime' IncludeTimeValue='FALSE'><Today /></Value></Geq></And><Eq><FieldRef Name='MSAStatus' /><Value Type='Choice'>Not Started</Value></Eq></And></Where>";
//"<Where><Eq><FieldRef Name='FFLScheduleName' LookupId='TRUE' /><Value Type='Integer' >" + currentUser.ID + "</Value></Eq></Where>";
spQuery.Query = strQuery; //sb.ToString(); // <UserID />
SPListItemCollection spListItems = spList.GetItems(spQuery);
if (spListItems != null && spListItems.Count > 0)
{
DataRow dr;
string recommendationLink = Utility.GetRedirectUrl("MSAFormLink");
SPFieldUrlValue link;
foreach (SPListItem item in spListItems)
{
dr = dt.NewRow();
string name = Convert.ToString(item["FFLScheduleName"]);
if (Convert.ToString(item["FFLArea"]) != null)
{
string[] areas = Convert.ToString(item["FFLArea"]).Split('#');
if (areas.Length > 1)
{
dr["AreaAudited"] = areas[1];
}
}
//dr["AreaAudited"] = item["FFLArea"] != null ? Convert.ToString(item["FFLArea"]) : "";
if (!String.IsNullOrEmpty(Convert.ToString(item["EventDate"])))
{
DateTime StartTime;
bool bValid = DateTime.TryParse(Convert.ToString(item["EventDate"]), new CultureInfo("en-GB"), DateTimeStyles.AssumeLocal, out StartTime);
if (bValid)
{
dr["StartTime"] = StartTime.ToShortDateString();
}
else
{
dr["StartTime"] = Convert.ToDateTime(StartTime).ToShortDateString();
}
}
else
{
dr["StartTime"] = "";
}
if (!String.IsNullOrEmpty(Convert.ToString(item["EndDate"])))
{
DateTime EndTime;
bool bValid = DateTime.TryParse(Convert.ToString(item["EndDate"]), new CultureInfo("en-GB"), DateTimeStyles.AssumeLocal, out EndTime);
if (bValid)
{
dr["EndTime"] = EndTime.ToShortDateString();
}
else
{
dr["EndTime"] = Convert.ToDateTime(EndTime).ToShortDateString(); ;
}
}
else
{
dr["EndTime"] = "";
}
link = new SPFieldUrlValue(Convert.ToString(item["MSAFormLink"]));
dr["LinkFileName"] = link.Url; //.Format("{0}?SID=" + item["ID"], recommendationLink);
dt.Rows.Add(dr);
}
BoundField bf = new BoundField();
//RecommendationNo Column
bf = new BoundField();
bf.DataField = "AreaAudited";
bf.HeaderText = "Area To Be Audited";
grdMSAScheduled.Columns.Add(bf);
bf = new BoundField();
bf.DataField = "StartTime";
bf.HeaderText = "Start Date";
grdMSAScheduled.Columns.Add(bf);
bf = new BoundField();
bf.DataField = "EndTime";
bf.HeaderText = "End Date";
grdMSAScheduled.Columns.Add(bf);
//bf = new BoundField();
//bf.DataField = "MSADate";
//bf.HeaderText = "MSA Date";
//grdMSATask.Columns.Add(bf);
//bf = new BoundField();
//bf.DataField = "AuditedBy";
//bf.HeaderText = "Audited By";
//grdMSATask.Columns.Add(bf);
HyperLinkField hyperlinkField = new HyperLinkField();
hyperlinkField.HeaderText = "View MSA";
hyperlinkField.DataNavigateUrlFields = new[] { "LinkFileName" };
hyperlinkField.Text = "View";
grdMSAScheduled.Columns.Add(hyperlinkField);
grdMSAScheduled.DataSource = dt;
grdMSAScheduled.DataBind();
}
}
}
});
}
catch (Exception ex)
{
SPDiagnosticsService.Local.WriteTrace(0, new SPDiagnosticsCategory("SL.FG.FFL->FillMSASchedule)", TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected, ex.Message, ex.StackTrace);
message_div.InnerHtml = "Something went wrong!!! Please Contact the administrator.";
}
}
public void queryMakeAndDisplay(string guild, string material, string type, string order)
{
browseGrid.Columns.Clear();
string aQuery = "SELECT Products.productID, Products.ProductName, Products.ProductDescription, Products.ProductCost, Artisans.ShopName, ProductPhotos.PhotoLocation FROM Products JOIN ProductPhotos ON Products.ProductID = ProductPhotos.ProductID JOIN Artisans ON Products.ArtisanID = Artisans.ArtisanID";
string whereClause = " WHERE ";
if (guild != "0") //creates query and binds to grid.
{
whereClause += "Products.Guild = " + guild;
if (type != "0")
{
whereClause += " AND Products.ProductType = " + type;
if (material != "0")
{
whereClause += " AND Products.Materials = " + material;
}
}
else
{
if (material != "0")
{
whereClause += " AND Products.Materials = " + material;
}
}
aQuery += whereClause;
}
string orderBy = "";
switch (order)
{
case "0":
orderBy = " ORDER BY Products.DateAdded";
break;
case "1":
orderBy = " ORDER BY Products.DateAdded DESC";
break;
case "2":
orderBy = " ORDER BY Products.ProductCost";
break;
case "3":
orderBy = " ORDER BY Products.ProductCost DESC";
break;
case "4":
orderBy = " ORDER BY Products.ProductName";
break;
case "5":
orderBy = " ORDER BY Products.ProductName DESC";
break;
}
aQuery += orderBy;
try
{
SqlConnection aConnection = new SqlConnection();
SqlCommand aCommand = new SqlCommand();
string aConnectionString = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=|DataDirectory|\\Database1.mdf;Integrated Security=True";
DataSet aDataSet = new DataSet();
SqlDataAdapter aDataAdapter = new SqlDataAdapter();
aConnection.ConnectionString = aConnectionString;
aCommand = new SqlCommand(aQuery, aConnection);
aDataAdapter.SelectCommand = aCommand;
aDataAdapter.SelectCommand.Connection.Open();
aDataAdapter.Fill(aDataSet, "Results");
browseGrid.DataSource = aDataSet.Tables["Results"];
// Create an ImageField object to display a photo.
ImageField photoImageField = new ImageField();
photoImageField.DataImageUrlField = "PhotoLocation";//the name of the column in the database
photoImageField.AlternateText = "Product Photos";
photoImageField.NullDisplayText = "No image on file.";
photoImageField.ControlStyle.Height = 120;
photoImageField.HeaderText = "Product Photos";
photoImageField.ReadOnly = true;
// Create a BoundField object to display text.
BoundField productDescriptionField = new BoundField();
productDescriptionField.DataField = "ProductDescription";
productDescriptionField.NullDisplayText = "No description.";
productDescriptionField.HeaderText = "Description";
browseGrid.DataSource = aDataSet.Tables["Results"];
BoundField costField = new BoundField();
costField.DataField = "ProductCost";
costField.NullDisplayText = "Price Unknown";
costField.DataFormatString = "{0:C0}";
costField.HeaderText = "Price";
browseGrid.DataSource = aDataSet.Tables["Results"];
// Create an HyperlinkField object to redirect to a page.
HyperLinkField productHyperLinkField = new HyperLinkField();
productHyperLinkField.DataTextField = "ProductName";
productHyperLinkField.DataNavigateUrlFields = new string[] { "productID" };
productHyperLinkField.DataNavigateUrlFormatString = "ProductProfile.aspx?id={0}";//the name of the profile page to go to for example
productHyperLinkField.HeaderText = "Product Name";
browseGrid.DataSource = aDataSet.Tables["Results"];
HyperLinkField artisanHyperLinkField = new HyperLinkField();
artisanHyperLinkField.DataTextField = "ShopName";
artisanHyperLinkField.DataNavigateUrlFields = new string[] { "productID" };
artisanHyperLinkField.DataNavigateUrlFormatString = "Storefront.aspx?id={0}";
artisanHyperLinkField.NavigateUrl = "#";//the name of the profile page to go to for example
artisanHyperLinkField.HeaderText = "Artisan";
browseGrid.DataSource = aDataSet.Tables["Results"];
// Add the field columns to the Fields collection of the
// GridView control.
browseGrid.Columns.Add(photoImageField);
browseGrid.Columns.Add(costField);
browseGrid.Columns.Add(productDescriptionField);
browseGrid.Columns.Add(artisanHyperLinkField);
browseGrid.Columns.Add(productHyperLinkField);
browseGrid.DataBind();
aConnection.Close();
browseGrid.AllowPaging = true;
}
catch (SqlException) { }
}
public void HyperLinkField_CopyProperty ()
{
PokerHyperLinkField field = new PokerHyperLinkField ();
HyperLinkField copy = new HyperLinkField ();
field.DataNavigateUrlFields = new string[] { "test1", "test2" };
field.DataNavigateUrlFormatString = "test";
field.DataTextField = "test";
field.DataTextFormatString = "test";
field.NavigateUrl = "test";
field.Target = "test";
field.Text = "test";
field.DoCopyProperties (copy);
Assert.AreEqual (2, ((Array) copy.DataNavigateUrlFields).Length, "DataNavigateUrlFieldsCount");
Assert.AreEqual ("test1", copy.DataNavigateUrlFields[0], "DataNavigateUrlFields#1");
Assert.AreEqual ("test2", copy.DataNavigateUrlFields[1], "DataNavigateUrlFields#2");
Assert.AreEqual ("test", copy.DataNavigateUrlFormatString, "DataNavigateUrlFormatString ");
Assert.AreEqual ("test", copy.DataTextField, "DataTextField");
Assert.AreEqual ("test", copy.DataTextFormatString, "DataTextFormatString");
Assert.AreEqual ("test", copy.NavigateUrl, "NavigateUrl");
Assert.AreEqual ("test", copy.Target, "Target");
Assert.AreEqual ("test", copy.Text, "Text");
}
protected override DataControlField SaveValues(string headerText)
{
HyperLinkField field = new HyperLinkField {
HeaderText = headerText
};
if (this._staticTextRadio.Checked)
{
field.Text = this._textBox.Text;
}
else
{
field.DataTextFormatString = this._textFSBox.Text;
if (base._haveSchema)
{
field.DataTextField = this._dataTextFieldList.Text;
}
else
{
field.DataTextField = this._dataTextFieldBox.Text;
}
}
if (this._staticUrlRadio.Checked)
{
field.NavigateUrl = this._linkBox.Text;
return field;
}
field.DataNavigateUrlFormatString = this._dataNavFSBox.Text;
if (base._haveSchema)
{
field.DataNavigateUrlFields = new string[] { this._dataNavFieldList.Text };
return field;
}
field.DataNavigateUrlFields = new string[] { this._dataNavFieldBox.Text };
return field;
}
//creates grid, creates columns, binds columns.
private void query()
{
searchGrid.Columns.Clear();
string searchItem = searchTB.Text;
DataSet aDataSet = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
aConnection.ConnectionString = aConnectionString;
aCommand = new SqlCommand();
if (advancedSearch.Checked == false)
{ //Basic search.
aCommand = basicQuery(searchItem);
aCommand.CommandText += " ORDER BY Products.ProductName";
aCommand.Connection = aConnection;
}
else
{
string shopTerm = artisanSearchTB.Text;
aCommand = advancedQuery(searchItem, shopTerm, guildDrop.SelectedValue, typesDrop.SelectedValue, materialsDrop.SelectedValue, lowPriceRange.Text, highPriceRange.Text, locationDrop.SelectedValue, orderByDrop.SelectedValue);
aCommand.Connection = aConnection;
}
// Create an ImageField object to display a photo.
ImageField photoImageField = new ImageField();
photoImageField.DataImageUrlField = "PhotoLocation";//the name of the column in the database
photoImageField.AlternateText = "Product Photos";
photoImageField.NullDisplayText = "No image on file.";
photoImageField.ControlStyle.Height = 120;
photoImageField.HeaderText = "Product Photos";
photoImageField.ReadOnly = true;
// Create a BoundField object to display text.
BoundField productDescriptionField = new BoundField();
productDescriptionField.DataField = "ProductDescription";
productDescriptionField.NullDisplayText = "No description.";
productDescriptionField.HeaderText = "Description";
searchGrid.DataSource = aDataSet.Tables["Results"];
BoundField costField = new BoundField();
costField.DataField = "ProductCost";
costField.DataFormatString = "{0:C0}";
costField.NullDisplayText = "Price Unknown";
costField.HeaderText = "Price";
searchGrid.DataSource = aDataSet.Tables["Results"];
// Create an HyperlinkField object to redirect to a page.
HyperLinkField productHyperLinkField = new HyperLinkField();
productHyperLinkField.DataTextField = "ProductName";
productHyperLinkField.DataNavigateUrlFields = new string[] { "ProductID" };
productHyperLinkField.DataNavigateUrlFormatString = "ProductProfile.aspx?id={0}"; //the name of the profile page to go to for example
productHyperLinkField.HeaderText = "Product Name";
searchGrid.DataSource = aDataSet.Tables["Results"];
HyperLinkField artisanHyperLinkField = new HyperLinkField();
artisanHyperLinkField.DataTextField = "ShopName";
artisanHyperLinkField.DataNavigateUrlFields = new string[] { "ProductID" };//the name of the profile page to go to for example
artisanHyperLinkField.DataNavigateUrlFormatString = "Storefront.aspx?id={0}";
artisanHyperLinkField.HeaderText = "Artisan";
searchGrid.DataSource = aDataSet.Tables["Results"];
// Add the field columns to the Fields collection of the
// GridView control.
searchGrid.Columns.Add(photoImageField);
searchGrid.Columns.Add(costField);
searchGrid.Columns.Add(productDescriptionField);
searchGrid.Columns.Add(artisanHyperLinkField);
searchGrid.Columns.Add(productHyperLinkField);
try
{
da.SelectCommand = aCommand;
da.SelectCommand.Connection.Open(); //if the user enters " " or something like " John " they will recieve as a reply to their query every item.
da.Fill(aDataSet, "Results");
searchGrid.DataSource = aDataSet.Tables["Results"];
searchGrid.DataBind();
aConnection.Close();
}
catch (SqlException) { }
}
public void HyperLinkField_DefaultProperty ()
{
HyperLinkField field = new HyperLinkField ();
Assert.AreEqual (0, ((Array) field.DataNavigateUrlFields).Length, "DataNavigateUrlFields");
Assert.AreEqual ("", field.DataNavigateUrlFormatString, "DataNavigateUrlFormatString");
Assert.AreEqual ("", field.DataTextField, "DataTextField");
Assert.AreEqual ("", field.DataTextFormatString, "DataTextFormatString");
Assert.AreEqual ("", field.NavigateUrl, "NavigateUrl");
Assert.AreEqual ("", field.Target, "Target");
Assert.AreEqual ("", field.Text, "Text");
}
/// <summary>
/// Se agregan las columnas iniciales del calendario en este caso los
/// días de la semana
/// </summary>
protected void crearColumnasIniciales()
{
HyperLinkField columnaActividad = new HyperLinkField();
columnaActividad.DataTextField = "Actividad";
columnaActividad.HeaderText = cld_resources.ResourceManager.GetString("Actividad");
BoundField columnaLunes = new BoundField();
columnaLunes.DataField = "Lunes";
columnaLunes.HeaderText = cld_resources.ResourceManager.GetString("Lunes");
BoundField columnaMartes = new BoundField();
columnaMartes.DataField = "Lunes";
columnaMartes.HeaderText = cld_resources.ResourceManager.GetString("Martes");
BoundField columnaMiercoles = new BoundField();
columnaMiercoles.DataField = "Lunes";
columnaMiercoles.HeaderText = cld_resources.ResourceManager.GetString("Miercoles");
BoundField columnaJueves = new BoundField();
columnaJueves.DataField = "Lunes";
columnaJueves.HeaderText = cld_resources.ResourceManager.GetString("Jueves");
BoundField columnaViernes = new BoundField();
columnaViernes.DataField = "Lunes";
columnaViernes.HeaderText = cld_resources.ResourceManager.GetString("Viernes");
BoundField columnaSabado = new BoundField();
columnaSabado.DataField = "Lunes";
columnaSabado.HeaderText = cld_resources.ResourceManager.GetString("Sabado");
BoundField columnaDomingo = new BoundField();
columnaDomingo.DataField = "Lunes";
columnaDomingo.HeaderText = cld_resources.ResourceManager.GetString("Domingo");
this.grvCalendario.Columns.Add(columnaActividad);
this.grvCalendario.Columns.Add(columnaLunes);
this.grvCalendario.Columns.Add(columnaMartes);
this.grvCalendario.Columns.Add(columnaMiercoles);
this.grvCalendario.Columns.Add(columnaJueves);
this.grvCalendario.Columns.Add(columnaViernes);
this.grvCalendario.Columns.Add(columnaSabado);
this.grvCalendario.Columns.Add(columnaDomingo);
ArrayList lista = new ArrayList();
lista.Add(new clsAsignacion("valor",1));
lista.Add(new clsAsignacion("valor", 1));
lista.Add(new clsAsignacion("valor", 1));
lista.Add(new clsAsignacion("valor", 1));
lista.Add(new clsAsignacion("valor", 1));
lista.Add(new clsAsignacion("valor", 1));
this.grvCalendario.DataSource = lista;
this.grvCalendario.DataBind();
//Se agregan las columnas a la lista de columnas
this.columnas.Add(columnaActividad);
this.columnas.Add(columnaLunes);
this.columnas.Add(columnaMartes);
this.columnas.Add(columnaMiercoles);
this.columnas.Add(columnaJueves);
this.columnas.Add(columnaViernes);
this.columnas.Add(columnaSabado);
this.columnas.Add(columnaDomingo);
}
public void HyperLinkField_InitializeCell ()
{
HyperLinkField field = new HyperLinkField ();
DataControlFieldCell cell = new DataControlFieldCell (null);
field.Text = "Text";
field.NavigateUrl = "NavigateUrl";
field.Target = "Target";
field.InitializeCell (cell, DataControlCellType.DataCell, DataControlRowState.Normal, 0);
Assert.AreEqual(1,cell.Controls.Count , "CellControlsCountAfterCreation");
if (cell.Controls[0] is HyperLink) {
Assert.AreEqual ("Text", ((HyperLink) cell.Controls[0]).Text, "HyperLinkText");
Assert.AreEqual ("NavigateUrl", ((HyperLink) cell.Controls[0]).NavigateUrl, "HyperLinkNavigateUrl");
Assert.AreEqual ("Target", ((HyperLink) cell.Controls[0]).Target, "Target");
}
else
Assert.Fail ("HyperLink was not been created");
}
public static void AddGridListColumn(GridView gv, DataTable ColItem, string LangID)
{
string fieldname = string.Empty;
string str2 = string.Empty;
string str3 = string.Empty;
foreach (DataRow row in ColItem.Rows)
{
BoundField field3;
if (!Convert.ToBoolean(row["IsVisible"]))
{
continue;
}
fieldname = row["ColName"].ToString( );
str3 = row["ColDataType"].ToString( ).ToLower( );
str2 = row["ColCaption_Cn"].ToString( );
switch (str3)
{
case "datetime":
case "smalldatetime":
{
TemplateField field = new TemplateField
{
SortExpression = fieldname
};
field.ItemStyle.Wrap = false;
field.HeaderStyle.Wrap = false;
//field.ItemTemplate = new iDateColumnTemplate(fieldname);
field.HeaderText = str2;
gv.Columns.Add(field);
continue;
}
default:
{
if (row["Link_Str"].ToString( ).Trim( ) != string.Empty)
{
HyperLinkField field2 = new HyperLinkField
{
HeaderText = str2,
DataNavigateUrlFormatString = row["Link_Str"].ToString( ),
DataNavigateUrlFields = row["Link_Field"].ToString( ).Split(new char[] { ',' }),
SortExpression = fieldname,
DataTextField = fieldname
};
field2.HeaderStyle.Wrap = false;
field2.ItemStyle.Wrap = false;
gv.Columns.Add(field2);
continue;
}
field3 = new BoundField
{
HeaderText = str2,
DataField = fieldname,
SortExpression = fieldname
};
field3.HeaderStyle.Wrap = false;
field3.ItemStyle.Wrap = false;
int num = Utilities.ToInt(row["ColWidth"]);
field3.ItemStyle.Width = new Unit((num > 40) ? num : 40);
string str4 = str3;
if (str4 != null)
{
if (!(str4 == "money"))
{
if (str4 == "numeric")
{
break;
}
if (str4 == "int")
{
goto Label_02E6;
}
}
else
{
field3.DataFormatString = "{0:c" + DIGITS_Sum.ToString( ) + "}";
field3.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
}
}
goto Label_02F3;
}
}
field3.DataFormatString = "{0:f" + DIGITS_Qty.ToString( ) + "}";
field3.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
goto Label_02F3;
Label_02E6:
field3.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
Label_02F3:
gv.Columns.Add(field3);
}
}
public static void RenderingHyperLinkField (Page p)
{
LiteralControl lcb = new LiteralControl (HtmlDiff.BEGIN_TAG);
LiteralControl lce = new LiteralControl (HtmlDiff.END_TAG);
GridView grid = new GridView ();
grid.AutoGenerateColumns = false;
grid.ShowFooter = true;
p.Form.Controls.Add (lcb);
p.Form.Controls.Add (grid);
p.Form.Controls.Add (lce);
HyperLinkField hyperlinkfield = new HyperLinkField ();
hyperlinkfield.DataTextField = STRINGFIELD;
string[] str = new string[] { STRINGFIELD };
hyperlinkfield.DataNavigateUrlFields = str;
hyperlinkfield.HeaderText = "HeaderText";
hyperlinkfield.FooterText = "FooterText";
grid.DataSource = GridViewTest.CreateDataSource ();
grid.Columns.Add (hyperlinkfield);
grid.DataBind ();
}
public static void InsertGridListColumn(GridView gv, int SeqNo, DataTable ColItem, string LangID, bool IsFixWidth)
{
gv.Attributes.Add("style ", "table-layout:fixed ");
int num = 100;
string fieldname = string.Empty;
string str2 = string.Empty;
string str3 = string.Empty;
foreach (DataRow row in ColItem.Rows)
{
TemplateField field;
BoundField field3;
if (Convert.ToBoolean(row["IsVisible"]))
{
fieldname = row["ColName"].ToString( );
num = Utilities.ToInt(row["ColWidth"]);
str3 = row["ColDataType"].ToString( ).ToLower( );
str2 = row["ColCaption_Cn"].ToString( );
switch (str3)
{
case "datetime":
case "smalldatetime":
{
field = new TemplateField
{
SortExpression = fieldname,
//ItemTemplate = new iDateColumnTemplate(fieldname),
HeaderText = str2
};
field.HeaderStyle.Width = new Unit(num);
field.ItemStyle.Width = new Unit(num);
gv.Columns.Insert(SeqNo, field);
continue;
}
}
if (row["Link_Str"].ToString( ).Trim( ) != string.Empty)
{
HyperLinkField field2 = new HyperLinkField
{
HeaderText = str2,
DataNavigateUrlFormatString = row["Link_Str"].ToString( ),
DataNavigateUrlFields = row["Link_Field"].ToString( ).Split(new char[] { ',' }),
SortExpression = fieldname,
DataTextField = fieldname
};
field2.HeaderStyle.Width = new Unit(num);
field2.ItemStyle.Width = new Unit(num);
gv.Columns.Insert(SeqNo, field2);
}
else
{
string str4 = str3;
if (str4 == null)
{
goto Label_03EA;
}
if (!(str4 == "money"))
{
if (str4 == "numeric")
{
goto Label_02FB;
}
if (str4 == "int")
{
goto Label_038B;
}
goto Label_03EA;
}
field3 = new BoundField
{
HeaderText = str2,
DataField = fieldname,
SortExpression = fieldname
};
field3.ItemStyle.Wrap = false;
field3.DataFormatString = "{0:c" + DIGITS_Sum.ToString( ) + "}";
field3.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
field3.HeaderStyle.Width = new Unit(num);
field3.ItemStyle.Width = new Unit(num);
gv.Columns.Insert(SeqNo, field3);
}
}
continue;
Label_02FB:
field3 = new BoundField( );
field3.HeaderText = str2;
field3.DataField = fieldname;
field3.SortExpression = fieldname;
field3.ItemStyle.Wrap = false;
field3.DataFormatString = "{0:f" + DIGITS_Qty.ToString( ) + "}";
field3.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
field3.HeaderStyle.Width = new Unit(num);
field3.ItemStyle.Width = new Unit(num);
gv.Columns.Insert(SeqNo, field3);
continue;
Label_038B:
field3 = new BoundField( );
field3.HeaderText = str2;
field3.DataField = fieldname;
field3.SortExpression = fieldname;
field3.ItemStyle.Wrap = false;
field3.HeaderStyle.Width = new Unit(num);
field3.ItemStyle.Width = new Unit(num);
field3.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
continue;
Label_03EA:
field = new TemplateField( );
field.SortExpression = fieldname;
field.HeaderStyle.Width = new Unit(num);
field.ItemStyle.Width = new Unit(num);
//field.ItemTemplate = new iTextColumnTemplate(fieldname, num);
field.HeaderText = str2;
gv.Columns.Insert(SeqNo, field);
}
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
var sf = new SelectionField();
sf.ItemStyle.CssClass = "GridViewIcon";
InternalGridView.Columns.Add(sf);
var nf = new System.Web.UI.WebControls.BoundField();
nf.DataField = "Number";
nf.ItemStyle.CssClass = "GridViewIcon";
InternalGridView.Columns.Add(nf);
var imgf = new ImageField();
imgf.DataImageUrlField = "EntityType";
imgf.DataImageUrlFormatString = "~/Icons/Small/{0}.gif";
imgf.ItemStyle.CssClass = "GridViewIcon";
InternalGridView.Columns.Add(imgf);
var namefield = new HyperLinkField();
namefield.HeaderText = "Name";
namefield.DataTextField = "Name";
namefield.ItemStyle.CssClass = "GridViewSpan";
namefield.DataNavigateUrlFields = new[] { "EntityType", "Guid" };
namefield.DataNavigateUrlFormatString = "~/" + entityGroup.ToString() + "/{0}Details.aspx?guid={1}";
InternalGridView.Columns.Add(namefield);
foreach (DataControlField col in columns)
{
InternalGridView.Columns.Add(col);
}
}
public HyperLinkFieldItem(DataControlFieldsEditor fieldsEditor, HyperLinkField runtimeField) : base(fieldsEditor, runtimeField, 8)
{
}
/// <summary>
/// The load grid view.
/// </summary>
protected void LoadGridView()
{
var nameColumn = new HyperLinkField();
nameColumn.DataTextField = "Name";
nameColumn.HeaderText = "Naam";
nameColumn.Target = "_blank";
nameColumn.DataNavigateUrlFormatString = this.Request.Url.AbsolutePath + "?page=Product&product={0}";
nameColumn.DataNavigateUrlFields = new[] { "Id" };
var amountColumn = new BoundField();
amountColumn.DataField = "Amount";
amountColumn.HeaderText = "Aantal";
var decreaseColumn = new ButtonField();
decreaseColumn.Text = "-";
decreaseColumn.CommandName = "Decrease";
var increaseColumn = new ButtonField();
increaseColumn.Text = "+";
increaseColumn.CommandName = "Increase";
var priceColumn = new BoundField();
priceColumn.DataField = "Price";
priceColumn.HeaderText = "Prijs";
priceColumn.DataFormatString = "{0:C}";
priceColumn.FooterText = "<strong>Totaal</strong>";
var totalColumn = new BoundField();
totalColumn.DataField = "Total";
totalColumn.HeaderText = "Totaal";
totalColumn.DataFormatString = "{0:C}";
totalColumn.FooterText = this.Products.Sum(x => x.Total).ToString("C");
this.GridViewCart.Columns.Clear();
this.GridViewCart.Columns.Add(nameColumn);
this.GridViewCart.Columns.Add(amountColumn);
this.GridViewCart.Columns.Add(decreaseColumn);
this.GridViewCart.Columns.Add(increaseColumn);
this.GridViewCart.Columns.Add(priceColumn);
this.GridViewCart.Columns.Add(totalColumn);
this.GridViewCart.DataSource = this.Products;
this.GridViewCart.DataBind();
}
private void FillMSAWorkQueue(SPWeb oSPWeb_, SPUser currentUser)
{
try
{
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite oSPsite = new SPSite(SPContext.Current.Web.Url))
{
using (SPWeb oSPWeb_EP = oSPsite.OpenWeb())
{
string getName = string.Empty;
DataTable dt = new DataTable();
dt.Columns.Add("AreaAudited", typeof(string));
dt.Columns.Add("StartTime", typeof(string));
dt.Columns.Add("MSADate", typeof(string));
dt.Columns.Add("EndTime", typeof(string));
dt.Columns.Add("AuditedBy", typeof(string));
dt.Columns.Add("LinkFileName", typeof(string));
string listName = "MSA";
// Fetch the List
SPList splistMSARecommendation = oSPWeb_EP.GetList(string.Format("{0}/Lists/{1}/AllItems.aspx", oSPWeb_EP.Url, listName));
SPQuery query = new SPQuery();
SPListItemCollection spListItems;
// Include only the fields you will use.
string vf = "<FieldRef Name='ID' /><FieldRef Name='Author' /><FieldRef Name='MSADate' /><FieldRef Name='AuditedBy' /><FieldRef Name='AreaAudited' /><FieldRef Name='AccompaniedBy' /><FieldRef Name='StartTime' /><FieldRef Name='EndTime' />";
query.ViewFields = vf;
query.ViewFieldsOnly = true;
StringBuilder sb = new StringBuilder();
sb.Append("<Where>")
.Append("<And>")
.Append("<Eq>")
.Append("<FieldRef Name='IsSavedAsDraft' />")
.Append("<Value Type='Boolean'>1</Value>")
.Append("</Eq>")
.Append("<Eq>")
.Append("<FieldRef Name='Author' />")
.Append("<Value Type='User'>" + currentUser.Name + "</Value>")
.Append("</Eq>")
.Append("</And>")
.Append("</Where>");
query.Query = sb.ToString();
spListItems = splistMSARecommendation.GetItems(query);
DataRow dr;
if (spListItems != null && spListItems.Count > 0)
{
foreach (SPListItem item in spListItems)
{
dr = dt.NewRow();
SPUser author = null;
if (item["Author"] != null)
{
string authorStr = Convert.ToString(item["Author"]);
var temp = authorStr.Split('#');
if (temp.Length > 1)
{
temp = temp[0].Split(';');
if (temp.Length > 1)
{
author = Utility.GetUser(oSPWeb_EP, null, null, Int32.Parse(temp[0]));
}
}
}
dr["AreaAudited"] = item["AreaAudited"] != null ? Convert.ToString(item["AreaAudited"]) : "";
dr["StartTime"] = item["StartTime"] != null ? Convert.ToString(item["StartTime"]) : "";
dr["EndTime"] = item["EndTime"] != null ? Convert.ToString(item["EndTime"]) : "";
string auditedBy = item["AuditedBy"] != null ? Convert.ToString(item["AuditedBy"]) : "";
if (!String.IsNullOrEmpty(auditedBy))
{
SPUser auditedByUser = Utility.GetUser(oSPWeb_EP, auditedBy);
if (auditedByUser != null)
{
dr["AuditedBy"] = auditedByUser.Name;
}
}
DateTime date;
bool bValid = DateTime.TryParse(Convert.ToString(item["MSADate"]), new CultureInfo("en-GB"), DateTimeStyles.AssumeLocal, out date);
if (bValid)
{
dr["MSADate"] = date.ToShortDateString();
}
else
{
try
{
dr["MSADate"] = Convert.ToDateTime(Convert.ToString(item["MSADate"])).ToShortDateString();
}
catch (Exception ex)
{
SPDiagnosticsService.Local.WriteTrace(0, new SPDiagnosticsCategory("WQ-MSAD:" + Convert.ToString(item["MSADate"]), TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected, ex.Message, ex.StackTrace);
}
}
string recommendationLink = Utility.GetRedirectUrl("MSAFormLink");
dr["LinkFileName"] = string.Format("{0}?MSAID=" + item["ID"], recommendationLink);
if (author != null && Utility.CompareUsername(author.LoginName, currentUser.LoginName))
{
dt.Rows.Add(dr);
}
}
}
BoundField bf = new BoundField();
//RecommendationNo Column
bf = new BoundField();
bf.DataField = "AreaAudited";
bf.HeaderText = "Area Audited";
grdMSATask.Columns.Add(bf);
bf = new BoundField();
bf.DataField = "StartTime";
bf.HeaderText = "Start Time";
grdMSATask.Columns.Add(bf);
bf = new BoundField();
bf.DataField = "EndTime";
bf.HeaderText = "End Time";
grdMSATask.Columns.Add(bf);
bf = new BoundField();
bf.DataField = "MSADate";
bf.HeaderText = "MSA Date";
grdMSATask.Columns.Add(bf);
bf = new BoundField();
bf.DataField = "AuditedBy";
bf.HeaderText = "Audited By";
grdMSATask.Columns.Add(bf);
HyperLinkField hyperlinkField = new HyperLinkField();
hyperlinkField.HeaderText = "View MSA";
hyperlinkField.DataNavigateUrlFields = new[] { "LinkFileName" };
hyperlinkField.Text = "View";
grdMSATask.Columns.Add(hyperlinkField);
grdMSATask.DataSource = dt;
grdMSATask.DataBind();
}
}
});
}
catch (Exception ex)
{
SPDiagnosticsService.Local.WriteTrace(0, new SPDiagnosticsCategory("SL.FG.FFL(WorkQueue->FillMSAWorkQueue)", TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected, ex.Message, ex.StackTrace);
message_div.InnerHtml = "Something went wrong!!! Please Contact the administrator.";
}
}
