public GridDropDownColumn AddDropDownColumn(string dataField, string headerText, bool enableEmptyItem)
{
GridDropDownColumn c = new GridDropDownColumn();
_grid.MasterTableView.Columns.Add(c);
c.DropDownControlType = GridDropDownColumnControlType.DropDownList;
c.EnableEmptyListItem = enableEmptyItem;
c.EmptyListItemText = BindingListItem.EmptyText;
c.EmptyListItemValue = BindingListItem.EmptyValue;
c.ListValueField = BindingListItem.ValueProperty;
c.ListTextField = BindingListItem.TextProperty;
c.HeaderText = headerText;
c.DataField = dataField;
return(c);
}
private void CreateGridColumns()
{
if (TableInfo == null)
{
return;
}
TableInfo ti = TableInfo;
int i = 0;
uxGrid.MasterTableView.Columns.Clear();
foreach (ColumnInfo c in ti.Columns)
{
if (c.IsPrimaryKey)
{
uxGrid.MasterTableView.DataKeyNames = new string[] { c.ColumnName };
if (c.IsIdentity)
{
continue;
}
}
GridEditableColumn col;
var fk = c.ForeignKeyRelation;
if (fk == null)
{
if (c.DataType == DbType.Boolean)
{
col = new GridCheckBoxColumn();
uxGrid.MasterTableView.Columns.Insert(i, col);
((GridCheckBoxColumn)col).DataField = c.ColumnName;
}
else
{
col = new GridBoundColumn();
uxGrid.MasterTableView.Columns.Insert(i, col);
((GridBoundColumn)col).DataField = c.ColumnName;
}
col.DataType = DbTypeUtility.GetType(c.DataType);
}
else
{
GridDropDownColumn dc = new GridDropDownColumn();
col = dc;
if (c.ColumnName.ToLower() != "unionid")
{
uxGrid.MasterTableView.Columns.Insert(i, col);
dc.DataField = c.ColumnName;
dc.DataType = DbTypeUtility.GetType(c.DataType);
dc.DataSourceID = "gidDS_" + c.ColumnName;
dc.ListTextField = "_col_";
dc.ListValueField = fk.PKField;
}
}
col.HeaderText = c.Title;
col.SortExpression = c.ColumnName;
col.ShowFilterIcon = false;
col.CurrentFilterFunction = GridKnownFunction.Contains;
col.AutoPostBackOnFilter = true;
//col.UniqueName = c.ColumnName;
i++;
}
}
protected void UsersEvents()
{
SqlDataSource gridsource = new SqlDataSource();
string connStr = ConfigurationManager.ConnectionStrings["HelpDeskConnString"].ToString();
gridsource.ConnectionString = connStr;
gridsource.SelectCommand = "SELECT * FROM [tblUser]";
gridsource.UpdateCommand = "Update [tblUser] Set [FirstName] = @FirstName , [Lastname]= @LastName , [EmailAddress] = @EmailAddress , [RoleId] = @RoleId WHERE [UserId] = @UserId";
gridsource.DeleteCommand = "DELETE FROM [tblUser] WHERE [UserId] = @UserId";
//delete parameters
Parameter Deletepm = new Parameter();
Deletepm.Name = "UserId";
Deletepm.DbType = DbType.Int32;
gridsource.DeleteParameters.Add(Deletepm);
// update parameters
Parameter Updatepm = new Parameter();
Updatepm.Name = "UserId";
Updatepm.DbType = DbType.Int32;
Updatepm.Name = "FirstName";
Updatepm.DbType = DbType.String;
Updatepm.Name = "Lastname";
Updatepm.DbType = DbType.String;
Updatepm.Name = "EmailAddress";
Updatepm.DbType = DbType.String;
//Updatepm.Name = "Password";
//Updatepm.DbType = DbType.String;
//Updatepm.Name = "ProjectId";
//Updatepm.DbType = DbType.Int32;
Updatepm.Name = "RoleId";
Updatepm.DbType = DbType.Int32;
gridsource.UpdateParameters.Add(Updatepm);
rg_Users.DataSource = gridsource;
bool isRoleAdded = false;
// bool isProjectAdded = false;
foreach (GridColumn col in rg_Users.MasterTableView.Columns)
{
//if(col.UniqueName == "ProjectId")
// isProjectAdded = true;
if (col.UniqueName == "RoleId")
isRoleAdded = true;
}
//Projects
//sourceproj.ConnectionString = connStr;
//sourceproj.SelectCommand = "SELECT * FROM [tblGroupProjectName]";
//GridDropDownColumn ddlProject = new GridDropDownColumn();
//if (!isProjectAdded)
// rg_Users.MasterTableView.Columns.Add(ddlProject);
//ddlProject.UniqueName = "ProjectId";
//ddlProject.HeaderText = "Project Name";
//ddlProject.DataSourceID = "sourceproj";
//ddlProject.DataField = "ProjectId";
//ddlProject.ListTextField = "ProjectName";
//ddlProject.ListValueField = "ProjectId";
// roles
GridDropDownColumn ddlRole = new GridDropDownColumn();
sourceRole.ConnectionString = connStr;
sourceRole.SelectCommand = "SELECT * FROM [tblUserRole]";
if (!isRoleAdded)
rg_Users.MasterTableView.Columns.Add(ddlRole);
ddlRole.UniqueName = "RoleId";
ddlRole.HeaderText = "Role";
ddlRole.DataSourceID = "sourceRole";
ddlRole.DataField = "RoleId";
ddlRole.ListTextField = "UserRole";
ddlRole.ListValueField = "RoleId";
}
