protected void storeGridView_DataBinding(object sender, EventArgs e)
{
if (!WebTools.UserInRole("ADMIN"))
{
storeGridView.AllowAutomaticDeletes = false;
GridButtonColumn gridbutton = (GridButtonColumn)storeGridView.MasterTableView.Columns[1];
}
else
{
string[] datafields = new string[1];
datafields[0] = "STORE_NAME";
GridButtonColumn gridbutton = (GridButtonColumn)storeGridView.MasterTableView.Columns[1];
gridbutton.ConfirmDialogType = GridConfirmDialogType.RadWindow;
gridbutton.ConfirmTextFormatString = "Are you sure you want to delete {0} ?";
gridbutton.ConfirmTextFields = datafields;
storeGridView.AllowAutomaticDeletes = true;
}
if (!WebTools.UserInRole("ADMIN"))
{
storeGridView.AllowAutomaticUpdates = false;
}
else
{
storeGridView.AllowAutomaticUpdates = true;
}
}
protected void itemsGrid_DataBinding(object sender, EventArgs e)
{
if (!WebTools.UserInRole("VENDOR_DELETE"))
{
itemsGrid.AllowAutomaticDeletes = false;
GridButtonColumn gridbutton = (GridButtonColumn)itemsGrid.MasterTableView.Columns[1];
}
else
{
string[] datafields = new string[1];
datafields[0] = "VENDOR_CODE";
GridButtonColumn gridbutton = (GridButtonColumn)itemsGrid.MasterTableView.Columns[1];
gridbutton.ConfirmDialogType = GridConfirmDialogType.RadWindow;
gridbutton.ConfirmTextFormatString = "Are you sure you want to delete {0} ?";
gridbutton.ConfirmTextFields = datafields;
itemsGrid.AllowAutomaticDeletes = true;
}
if (!WebTools.UserInRole("VENDOR_EDIT"))
{
itemsGrid.AllowAutomaticUpdates = false;
}
else
{
itemsGrid.AllowAutomaticUpdates = true;
}
}
protected void rgActionItem_ItemCreated(object sender, GridItemEventArgs e)
{
if (e.Item is GridEditableItem && e.Item.IsInEditMode)
{
}
else
{
GridDataItem item = e.Item as GridDataItem;
if (item != null)
{
GridButtonColumn gBtnCol = item.OwnerTableView.GetColumn("ArchiveColumn") as GridButtonColumn;
ImageButton ImgBtn = item["ArchiveColumn"].Controls[0] as ImageButton;
if (chkbArchive.Checked)
{
ImgBtn.ImageUrl = "images/show.png";
ImgBtn.CommandName = "unArchive";
gBtnCol.ConfirmText = "Are you sure you want to UnArchive?";
gBtnCol.ConfirmTitle = "UnArchive";
ImgBtn.ToolTip = "UnArchive";
}
else
{
ImgBtn.ImageUrl = "images/hide.png";
ImgBtn.CommandName = "Archive";
gBtnCol.ConfirmText = "Are you sure you want to Archive?";
gBtnCol.ConfirmTitle = "Archive";
ImgBtn.ToolTip = "Archive";
}
}
}
}
protected void gridPreservItems_DataBinding(object sender, EventArgs e)
{
if (!WebTools.UserInRole("PRESERVATION_DELETE"))
{
ItemsGrid.AllowAutomaticDeletes = false;
GridButtonColumn gridbutton = (GridButtonColumn)ItemsGrid.MasterTableView.Columns[1];
}
else
{
string[] datafields = new string[1];
datafields[0] = "MAT_CODE1_NO";
GridButtonColumn gridbutton = (GridButtonColumn)ItemsGrid.MasterTableView.Columns[1];
gridbutton.ConfirmDialogType = GridConfirmDialogType.RadWindow;
gridbutton.ConfirmTextFormatString = "Are you sure you want to delete {0} ?";
gridbutton.ConfirmTextFields = datafields;
ItemsGrid.AllowAutomaticDeletes = true;
}
if (!WebTools.UserInRole("PRESERVATION_DELETE"))
{
ItemsGrid.AllowAutomaticUpdates = false;
}
else
{
ItemsGrid.AllowAutomaticUpdates = true;
}
}
public GridButtonColumn AddButtonColumn(string buttonText, string commandName)
{
GridButtonColumn bc = new GridButtonColumn();
_grid.MasterTableView.Columns.Add(bc);
bc.ButtonType = GridButtonColumnType.LinkButton;
bc.ConfirmDialogType = GridConfirmDialogType.Classic;
bc.Text = buttonText;
bc.CommandName = commandName;
bc.HeaderStyle.Width = ButtonColumnWidth;
return(bc);
}
public GridButtonColumn AddDeleteButtonColumn()
{
GridButtonColumn bc = new GridButtonColumn();
_grid.MasterTableView.Columns.Add(bc);
bc.ButtonType = GridButtonColumnType.ImageButton;
bc.Text = "Delete";
bc.CommandName = "Delete";
bc.HeaderStyle.Width = ButtonColumnWidth;
bc.ConfirmDialogType = GridConfirmDialogType.RadWindow;
bc.ConfirmTitle = "Delete Confirm";
return(bc);
}
public override void AttachProperties(GridColumn gridColumn)
{
base.AttachProperties(gridColumn);
GridButtonColumn column = (GridButtonColumn)gridColumn;
column.ButtonType = GridButtonColumnType.ImageButton;
column.Text = "Delete";
column.CommandName = RadGrid.DeleteCommandName;
column.HeaderStyle.Width = ButtonColumnWidth;
column.ConfirmDialogType = GridConfirmDialogType.RadWindow;
column.ConfirmTitle = "Delete Confirm";
column.ConfirmText = ConfirmText;
column.ConfirmTextFormatString = ConfirmTextFormatString;
column.ConfirmTextFields = ConfirmTextFields;
}
protected void ParticipantListGrid_PreRender(object sender, EventArgs e)
{
foreach (GridColumn col in ParticipantListGrid.MasterTableView.RenderColumns)
{
if (col.UniqueName == "Delete")
{
GridButtonColumn boundColumn = (GridButtonColumn)col;
if (UserHelper.CurrentUser.UserTypeId == (int)EnumUserType.NGOHead || UserHelper.CurrentUser.UserTypeId == (int)EnumUserType.ProjectManager || UserHelper.CurrentUser.UserTypeId == (int)EnumUserType.Schoolmaster)
{
boundColumn.Visible = true;
}
else
{
boundColumn.Visible = false;
}
}
}
}
public static void BuildGridDeleteColumn(BasePage page, RadGrid Grid, Grid GridObject, DeleteGridColumn Column, string ResourceKeyPrefix)
{
GridButtonColumn col = new GridButtonColumn();
col.CommandName = "Delete";
string HeaderText = Common.CoalesceStr(col.HeaderText, Column.HeaderText);
string ConfirmText = Common.CoalesceStr(col.ConfirmText, Column.ConfirmText);
string Text = Common.CoalesceStr(col.Text, Column.Text);
col.HeaderText = GetGlobalResourceString(page, Column, ResourceKeyPrefix, "HeaderText", HeaderText);
col.SortExpression = Common.CoalesceStr(col.SortExpression, Column.SortExpression);
col.ConfirmText = GetGlobalResourceString(page, Column, ResourceKeyPrefix, "ConfirmText", ConfirmText);
col.Text = GetGlobalResourceString(page, Column, ResourceKeyPrefix, "Text", Text);
switch (Column.ButtonType)
{
case System.Web.UI.WebControls.ButtonType.Link:
col.ButtonType = GridButtonColumnType.LinkButton;
break;
case System.Web.UI.WebControls.ButtonType.Button:
col.ButtonType = GridButtonColumnType.PushButton;
break;
case System.Web.UI.WebControls.ButtonType.Image:
col.ButtonType = GridButtonColumnType.ImageButton;
col.ImageUrl = Common.CoalesceStr(col.ImageUrl, Column.ImageUrl);
break;
default:
col.ButtonType = GridButtonColumnType.LinkButton;
break;
}
FormatStyle(col, Column);
Grid.MasterTableView.Columns.Add(col);
}
protected void IssueGridView_DataBinding(object sender, EventArgs e)
{
try
{
if (!WebTools.UserInRole("MM_DELETE"))
{
IssueGridView.AllowAutomaticDeletes = false;
GridButtonColumn gridbutton = (GridButtonColumn)IssueGridView.MasterTableView.Columns[1];
}
else
{
string[] datafields = new string[1];
datafields[0] = "TRANSF_NO";
GridButtonColumn gridbutton = (GridButtonColumn)IssueGridView.MasterTableView.Columns[1];
gridbutton.ConfirmDialogType = GridConfirmDialogType.RadWindow;
gridbutton.ConfirmTextFormatString = "Are you sure you want to delete {0} ?";
gridbutton.ConfirmTextFields = datafields;
IssueGridView.AllowAutomaticDeletes = true;
}
}
catch (Exception ex)
{
RadWindowManager1.RadAlert("Items Available in MATERIAL TRANSFER!", 400, 150, "Warning", "");
}
if (!WebTools.UserInRole("MM_EDIT"))
{
IssueGridView.AllowAutomaticUpdates = false;
}
else
{
IssueGridView.AllowAutomaticUpdates = true;
}
}
public override GridColumn CreateColumn()
{
GridButtonColumn column = new GridButtonColumn();
return(column);
}
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
GridEditCommandColumn GEC = new GridEditCommandColumn();
this.RadGrid1.MasterTableView.Columns.Add(GEC);
GEC.UniqueName = "EditCommandColumn";
GEC.ButtonType = GridButtonColumnType.ImageButton;
GEC.ItemStyle.Width = 20;
GEC.OrderIndex = 0;
GridButtonColumn GBC = new GridButtonColumn();
this.RadGrid1.MasterTableView.Columns.Add(GBC);
GBC.CommandName = "Delete";
GBC.Text = "Delete";
GBC.ItemStyle.Width = 20;
GBC.ButtonType = GridButtonColumnType.ImageButton;
BLL.CustomFilteringColumn gridColumn2 = new BLL.CustomFilteringColumn();
this.RadGrid1.MasterTableView.Columns.Add(gridColumn2);
gridColumn2.DataField = "FirstName";
gridColumn2.HeaderText = "First Name";
gridColumn2.ItemStyle.CssClass = "UseHand";
BLL.CustomFilteringColumn gridColumn3 = new BLL.CustomFilteringColumn();
this.RadGrid1.MasterTableView.Columns.Add(gridColumn3);
gridColumn3.DataField = "LastName";
gridColumn3.HeaderText = "Last Name";
BLL.CustomFilteringColumn gridColumn4 = new BLL.CustomFilteringColumn();
this.RadGrid1.MasterTableView.Columns.Add(gridColumn4);
gridColumn4.DataField = "Email";
gridColumn4.HeaderText = "Email";
gridColumn4.ItemStyle.Width = 400;
GridDateTimeColumn gridColumn5 = new GridDateTimeColumn();
this.RadGrid1.MasterTableView.Columns.Add(gridColumn5);
gridColumn5.DataField = "Birthday";
gridColumn5.HeaderText = "Birthday";
gridColumn5.ItemStyle.Width = 200;
gridColumn5.AllowFiltering = false;
GridCheckBoxColumn gridColumn6 = new GridCheckBoxColumn();
this.RadGrid1.MasterTableView.Columns.Add(gridColumn6);
gridColumn6.DataField = "IsLockedOut";
gridColumn6.HeaderText = "Locked Out";
gridColumn6.AllowFiltering = false;
//BLL.CustomFilteringColumn gridColumn7 = new BLL.CustomFilteringColumn();
//this.RadGrid1.MasterTableView.Columns.Add(gridColumn7);
//gridColumn7.DataField = "Gender";
//gridColumn7.HeaderText = "Gender";
//gridColumn7.AllowFiltering = false;
//RadComboBox gridColumn7 = new RadComboBox();
//this.RadGrid1.MasterTableView.Columns.Add(gridColumn7);
//gridColumn7.Items[0].Text = "Male";
//gridColumn7.Items[0].Value = "Male";
//gridColumn7.Items[1].Text = "Female";
//gridColumn7.Items[1].Value = "Female";
}
}
private void CreateColumns(Report report)
{
DataTable table = new DataTable();
using (SqlCommand command = new SqlCommand())
{
command.CommandText = report.GetSqlOld(true, filterControl.ReportConditions);
command.CommandType = CommandType.Text;
Report.CreateParameters(UserSession.LoginUser, command, UserSession.LoginUser.UserID);
using (SqlConnection connection = new SqlConnection(GetReportConnectionString()))
{
connection.Open();
command.Connection = connection;
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
{
adapter.FillSchema(table, SchemaType.Source);
adapter.Fill(table);
}
connection.Close();
}
}
ReportFields fields = new ReportFields(UserSession.LoginUser);
fields.LoadByReportID(_reportID);
foreach (ReportField field in fields)
{
if (field.IsCustomField == false && (field.LinkedFieldID == 30 || field.LinkedFieldID == 146))
{
GridButtonColumn column = new GridButtonColumn();
gridReport.MasterTableView.Columns.Add(column);
column.ButtonType = GridButtonColumnType.ImageButton;
column.ImageUrl = "../images/icons/open.png";
column.UniqueName = "ButtonOpen";
column.CommandName = "OpenItem";
column.HeaderStyle.Width = new Unit(32, UnitType.Pixel);
column.Resizable = false;
break;
}
}
if (fields.IsEmpty)
{
if (table.Columns.Contains("Ticket_Number"))
{
GridButtonColumn column = new GridButtonColumn();
gridReport.MasterTableView.Columns.Add(column);
column.ButtonType = GridButtonColumnType.ImageButton;
column.ImageUrl = "../images/icons/open.png";
column.UniqueName = "ButtonOpen";
column.CommandName = "OpenItem";
column.HeaderStyle.Width = new Unit(32, UnitType.Pixel);
column.Resizable = false;
}
}
foreach (DataColumn dataColumn in table.Columns)
{
GridBoundColumn gridColumn;
if (dataColumn.DataType == typeof(System.DateTime))
{
gridColumn = new GridDateTimeColumn();
gridColumn.DataFormatString = "{0:MM/dd/yyyy hh:mm tt}";
}
else if (dataColumn.DataType == typeof(System.Decimal) ||
dataColumn.DataType == typeof(System.Double)
)
{
gridColumn = new GridNumericColumn();
gridColumn.DataFormatString = "{0:0.00}";
}
else if (dataColumn.DataType == typeof(System.Int16) ||
dataColumn.DataType == typeof(System.Int32) ||
dataColumn.DataType == typeof(System.Int64))
{
gridColumn = new GridNumericColumn();
gridColumn.DataFormatString = "{0:0}";
}
else
{
gridColumn = new GridBoundColumn();
}
gridReport.MasterTableView.Columns.Add(gridColumn);
gridColumn.DataType = dataColumn.DataType;
gridColumn.DataField = dataColumn.ColumnName.Replace(' ', '_');
gridColumn.UniqueName = gridColumn.DataField;
gridColumn.HeaderText = dataColumn.ColumnName.Replace('_', ' ');
gridColumn.HeaderStyle.Width = new Unit(200, UnitType.Pixel);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.Droplist_Tables.Items.Add("-Select One-");
var storeGenerator = new EntityStoreSchemaGenerator(
"System.Data.SqlClient",
ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString,
"namespace");
storeGenerator.GenerateStoreMetadata();
var tables = storeGenerator.StoreItemCollection
.GetItems<EntityContainer>()
.Single()
.BaseEntitySets
.OfType<EntitySet>()
.Where(s => !s.MetadataProperties.Contains("Type")
|| s.MetadataProperties["Type"].ToString() == "Tables");
foreach (var table in tables)
{
this.Droplist_Tables.Items.Add(table.Name);
}
//Add delete button to gridview
//GridButtonColumn deleteButton = new GridButtonColumn();
//this.tableGrid.MasterTableView.Columns.Add(deleteButton);
//deleteButton.UniqueName = "deleteButton";
//deleteButton.HeaderText = "Delete";
//deleteButton.Text = "Delete";
//deleteButton.ConfirmText = "Are you sure you want to delete this record?";
//deleteButton.ButtonType = GridButtonColumnType.LinkButton;
//deleteButton.CommandName = "Delete";
//Add edit button to gridview
GridButtonColumn detailsButton = new GridButtonColumn();
this.tableGrid.MasterTableView.Columns.Add(detailsButton);
detailsButton.UniqueName = "detailsButton";
detailsButton.HeaderText = "Details";
detailsButton.Text = "Details";
detailsButton.ButtonType = GridButtonColumnType.LinkButton;
detailsButton.CommandName = "Details";
}
}
protected void ProjectSubDetailListGrid_PreRender(object sender, EventArgs e)
{
foreach (GridColumn col in ProjectSubDetailListGrid.MasterTableView.RenderColumns)
{
if (col.UniqueName == "Edit")
{
GridTemplateColumn boundColumn = (GridTemplateColumn)col;
if (UserHelper.CurrentUser.UserTypeId == (int)EnumUserType.NGOHead)
{
boundColumn.Visible = true;
}
else if (UserHelper.CurrentUser.UserTypeId == (int)EnumUserType.ProjectManager && UserHelper.CurrentUser.Id == Convert.ToInt64(ProjectManagerId.Value))
{
boundColumn.Visible = true;
}
else
{
boundColumn.Visible = false;
}
}
if (col.UniqueName == "ActivityOperations")
{
GridButtonColumn boundColumn = (GridButtonColumn)col;
if (UserHelper.CurrentUser.UserTypeId == (int)EnumUserType.Volunteer)
{
boundColumn.Visible = true;
}
else
{
boundColumn.Visible = false;
}
}
if (col.UniqueName == "ActivityConfirmationOperations" || col.UniqueName == "Participants")
{
GridButtonColumn boundColumn = (GridButtonColumn)col;
if (UserHelper.CurrentUser.UserTypeId == (int)EnumUserType.ProjectManager && UserHelper.CurrentUser.Id == Convert.ToInt64(ProjectManagerId.Value))
{
boundColumn.Visible = true;
}
else
{
boundColumn.Visible = false;
}
}
if (col.UniqueName == "SurveyProjectDetailResult")
{
GridButtonColumn boundColumn = (GridButtonColumn)col;
if (UserHelper.CurrentUser.UserTypeId == (int)EnumUserType.NGOHead)
{
boundColumn.Visible = true;
}
else
{
boundColumn.Visible = false;
}
}
}
}
public static void BindTelerikGrid(
ref RadGrid Grid
, DataTable Dt_Source
, List<ClsBindGridColumn_Web_Telerik> List_Gc
, string Key = ""
, bool AllowSort = true
, bool HasDelete = false
, eSelectorType SelectorType = eSelectorType.None
)
{
Grid.DataSource = Dt_Source;
if (Grid.Columns.Count > 0)
{ Grid.Columns.Clear(); }
Grid.AutoGenerateColumns = false;
if (SelectorType != eSelectorType.None)
{
Grid.ClientSettings.Selecting.AllowRowSelect = true;
Grid.ClientSettings.Selecting.UseClientSelectColumnOnly = true;
}
Grid.AllowMultiRowSelection = SelectorType == eSelectorType.Multiple;
//Grid.ClientSettings.Resizing.AllowColumnResize = true;
//Grid.ClientSettings.Resizing.AllowResizeToFit = true;
TableItemStyle Tis = null;
foreach (ClsBindGridColumn_Web_Telerik Inner_Gc in List_Gc)
{
if (!Inner_Gc.mIsVisible)
{
continue;
}
switch (Inner_Gc.mFieldType)
{
case Layer01_Constants.eSystem_Lookup_FieldType.FieldType_Text:
{
GridBoundColumn Gc = new GridBoundColumn();
Grid.Columns.Add(Gc);
Gc.HeaderStyle.Width = Inner_Gc.mUnit_Width;
Gc.HeaderText = Inner_Gc.mFieldDesc;
Gc.DataField = Inner_Gc.mFieldName;
Gc.ReadOnly = !Inner_Gc.mEnabled;
Gc.DataFormatString = Inner_Gc.mDataFormat;
if (AllowSort)
{ Gc.HeaderButtonType = GridHeaderButtonType.LinkButton; }
Gc.SortExpression = Inner_Gc.mFieldName;
Tis = Gc.ItemStyle;
break;
}
case Layer01_Constants.eSystem_Lookup_FieldType.FieldType_Checkbox:
{
GridCheckBoxColumn Gc = new GridCheckBoxColumn();
Grid.Columns.Add(Gc);
Gc.HeaderStyle.Width = Inner_Gc.mUnit_Width;
Gc.DataField = Inner_Gc.mFieldName;
Gc.HeaderText = Inner_Gc.mFieldDesc;
Gc.ReadOnly = !Inner_Gc.mEnabled;
if (AllowSort)
{ Gc.HeaderButtonType = GridHeaderButtonType.LinkButton; }
Gc.SortExpression = Inner_Gc.mFieldName;
Tis = Gc.ItemStyle;
break;
}
case Layer01_Constants.eSystem_Lookup_FieldType.FieldType_DateTime:
{
GridDateTimeColumn Gc = new Telerik.Web.UI.GridDateTimeColumn();
Grid.Columns.Add(Gc);
Gc.HeaderStyle.Width = Inner_Gc.mUnit_Width;
Gc.DataField = Inner_Gc.mFieldName;
Gc.HeaderText = Inner_Gc.mFieldDesc;
Gc.ReadOnly = !Inner_Gc.mEnabled;
Gc.DataFormatString = Inner_Gc.mDataFormat;
if (AllowSort)
{ Gc.HeaderButtonType = GridHeaderButtonType.LinkButton; }
Gc.SortExpression = Inner_Gc.mFieldName;
Tis = Gc.ItemStyle;
break;
}
case Layer01_Constants.eSystem_Lookup_FieldType.FieldType_Button:
{
GridButtonColumn Gc = new GridButtonColumn();
Grid.Columns.Add(Gc);
Gc.HeaderStyle.Width = Inner_Gc.mUnit_Width;
Gc.HeaderText = Inner_Gc.mFieldDesc;
Gc.CommandName = Inner_Gc.mCommandName;
if (Inner_Gc.mFieldName == "")
{ Gc.Text = Inner_Gc.mFieldText; }
else
{ Gc.DataTextField = Inner_Gc.mFieldName; }
switch (Inner_Gc.mButtonType)
{
case ButtonColumnType.PushButton:
Gc.ButtonType = Telerik.Web.UI.GridButtonColumnType.PushButton;
break;
case ButtonColumnType.LinkButton:
Gc.ButtonType = Telerik.Web.UI.GridButtonColumnType.LinkButton;
break;
}
Tis = Gc.ItemStyle;
break;
}
case Layer01_Constants.eSystem_Lookup_FieldType.FieldType_HyperLink:
{
GridHyperLinkColumn Gc = new GridHyperLinkColumn();
Grid.Columns.Add(Gc);
Gc.HeaderStyle.Width = Inner_Gc.mUnit_Width;
Gc.HeaderText = Inner_Gc.mFieldDesc;
Gc.Text = Inner_Gc.mFieldText;
Gc.DataNavigateUrlFormatString = Inner_Gc.mFieldNavigateUrl_Text;
Gc.DataNavigateUrlFields = new string[] { Inner_Gc.mFieldNavigateUrl_Field };
Tis = Gc.ItemStyle;
break;
}
default:
{
GridBoundColumn Gc = new GridBoundColumn();
Grid.Columns.Add(Gc);
Gc.HeaderStyle.Width = Inner_Gc.mUnit_Width;
Gc.HeaderText = Inner_Gc.mFieldDesc;
Gc.DataField = Inner_Gc.mFieldName;
Gc.ReadOnly = true;
Gc.DataFormatString = Inner_Gc.mDataFormat;
if (AllowSort)
{ Gc.HeaderButtonType = GridHeaderButtonType.LinkButton; }
Tis = Gc.ItemStyle;
break;
}
}
//Tis.Width = Inner_Gc.mUnit_Width;
}
if (HasDelete) { }
switch (SelectorType)
{
case eSelectorType.Single:
case eSelectorType.Multiple:
{
GridClientSelectColumn Gc = new GridClientSelectColumn();
Grid.Columns.Insert(0, Gc);
Gc.UniqueName = "Select";
Gc.HeaderText = "";
Gc.HeaderStyle.Width = new Unit("40px");
break;
}
}
if (Key != "")
{ Grid.MasterTableView.DataKeyNames = new string[] { Key }; }
Grid.DataBind();
}
