protected void gvSheets_RowDataBound(object sender, GridViewRowEventArgs e)
{
GridViewRow row = e.Row;
int rowidx = e.Row.RowIndex;
if (row.RowType == DataControlRowType.DataRow)
{
for (int i = 0; i < 6; i++)
{
DropDownList ddl = (DropDownList)row.FindControlRecursive("ddl" + i.ToString());
if (i == 1)
{
DataTable methods = Master.SQL.DataTable_from_SQLstring("select method from gev.method");
ddl.DataSource = methods;
ddl.DataTextField = "method";
ddl.DataValueField = "method";
}
else
{
string cols_csv = colNames[rowidx];
List <string> cols = cols_csv.Split('|').ToList();
ddl.DataSource = cols;
}
ddl.DataBind();
}
}
}
public void SaveMarks(object sender, EventArgs e)
{
GridView list = (GridView)Page.FindControlRecursive("fileList");
for (int i = 0; i < list.Rows.Count; i++)
{
GridViewRow row = list.Rows[i];
TextBox mark = (TextBox)row.FindControlRecursive("mark");
HiddenField userid = (HiddenField)row.FindControlRecursive("userid");
HiddenField resourceid = (HiddenField)row.FindControlRecursive("resourceid");
AddJoinUserMark join = new AddJoinUserMark();
bool addSuccess = join.UpdateMark(int.Parse(resourceid.Value), userid.Value, float.Parse(mark.Text));
if (addSuccess)
{
Response.Redirect(Request.RawUrl);
}
}
}
/// <summary>
/// Handles the RowUpdating event of the m_AvailableGridView control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="GridViewUpdateEventArgs" /> instance containing the event data.</param>
protected void m_AvailableGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
SPGridView _sender = sender as SPGridView;
if (_sender == null)
{
return;
}
//Update the values.
GridViewRow row = _sender.Rows[e.RowIndex];
Label _idLabel = (Label)row.FindControlRecursive(m_IDEditLabel);
double _qtty = default(double);
Selection.SelectionTableRow _slctdItem = m_ControlState.AvailableItems.SelectionTable.FindByID(_idLabel.Text);
TextBox _quantityTB = (TextBox)row.FindControlRecursive(m_QuantityNewValue);
if (!double.TryParse(_quantityTB.Text, out _qtty) || (_slctdItem.Quantity < _qtty))
{
_quantityTB.Text = _slctdItem.Quantity.ToString("F2");
_quantityTB.BorderColor = System.Drawing.Color.Red;
_quantityTB.BackColor = System.Drawing.Color.Yellow;
e.Cancel = true;
return;
}
Selection.SelectionTableRow _assignedRow = m_ControlState.AssignedItems.SelectionTable.FindByID(_idLabel.Text);
if (_assignedRow == null)
{
m_ControlState.AssignedItems.SelectionTable.ImportRow(_slctdItem);
_assignedRow = m_ControlState.AssignedItems.SelectionTable.FindByID(_idLabel.Text);
_assignedRow.Quantity = _qtty;
}
else
{
_assignedRow.Quantity += _qtty;
}
_assignedRow.AcceptChanges();
_assignedRow.SetAdded();
_slctdItem.Quantity -= _qtty;
_sender.EditIndex = -1;
e.Cancel = true;
}
private static void GetRow(SPGridView sender, GridViewSelectEventArgs e, Selection.SelectionTableDataTable destination, Selection.SelectionTableDataTable source)
{
if (sender == null)
{
return;
}
GridViewRow row = sender.Rows[e.NewSelectedIndex];
string _id = ((Label)row.FindControlRecursive(m_IDItemLabel)).Text;
destination.GetRow(source, _id);
e.NewSelectedIndex = -1;
e.Cancel = true;
}
protected void SaveSheet(int idx)
{
SQL_utils sql = new SQL_utils("backend");
GridViewRow row = gvSheets.Rows[idx - 1];
bool validSelections = true;
string[] ddl_values = new string[6];
if (row.RowType == DataControlRowType.DataRow)
{
for (int i = 0; i < 6; i++)
{
DropDownList ddl = (DropDownList)row.FindControlRecursive("ddl" + i.ToString());
ddl_values[i] = ddl.SelectedValue;
if (ddl.SelectedValue == "..select..")
{
validSelections = false;
}
}
if (!validSelections)
{
lblSubmitInfo.Text = "Select a value for each parameter. (Use **NA** if the parameter is not present in the data).";
lblSubmitInfo.ForeColor = System.Drawing.Color.Red;
}
else
{ //Proceed - no invalid selections
lblSubmitInfo.Text = "";
List <SqlParameter> p = new List <SqlParameter>();
DataTable dt = dset.Tables[idx - 1];
int filepk = 0;
filepk = sql.IntScalar_from_SQLstring("select coalesce(max(filepk) + 1,1) from gev.files");
DataColumn methodCol = new System.Data.DataColumn("method", typeof(System.String));
methodCol.DefaultValue = ddl_values[1];
dt.Columns.Add(methodCol);
p.Add(sql.CreateParam("filepk", filepk.ToString(), "int"));
p.Add(sql.CreateParam("filename", FileName, "text"));
p.Add(sql.CreateParam("sheetname", dt.TableName, "text"));
p.Add(sql.CreateParam("numrows", dt.Rows.Count.ToString(), "int"));
p.Add(sql.CreateParam("numcols", dt.Columns.Count.ToString(), "int"));
p.Add(sql.CreateParam("col_id", ddl_values[0], "text"));
p.Add(sql.CreateParam("col_method", "method", "text"));
p.Add(sql.CreateParam("col_gene", ddl_values[2], "text"));
p.Add(sql.CreateParam("col_region", ddl_values[3], "text"));
p.Add(sql.CreateParam("col_eventtype", ddl_values[4], "text"));
p.Add(sql.CreateParam("col_inheritance", ddl_values[5], "text"));
//OUTPUT Parameter not working
//p.Add(Master.SQL.CreateParam("output", "output", "int", "output"));
string p_vals =
"filename " + FileName + "<br/>" +
"sheetname " + dt.TableName + "<br/>" +
"numrows " + dt.Rows.Count.ToString() + "<br/>" +
"numcols " + dt.Columns.Count.ToString() + "<br/>" +
"col_id " + ddl_values[0] + "<br/>" +
"col_method " + ddl_values[1] + "<br/>" +
"col_gene " + ddl_values[2] + "<br/>" +
"col_region " + ddl_values[3] + "<br/>" +
"col_eventtype " + ddl_values[4] + "<br/>" +
"col_inheritance " + ddl_values[5] + "<br/>";
string sfilepk = "";
try
{
sfilepk = sql.StringScalar_from_ProcName("gev.spFiles_INSERT", p);
lblSubmitInfo.Text = "New filepk = " + filepk.ToString() + ". ";
//Hide this row
gvSheets.Rows[idx - 1].Visible = false;
int n_visible = 0;
for (int r = 0; r < gvSheets.Rows.Count; r++)
{
if (gvSheets.Rows[r].Visible == true)
{
n_visible++;
}
}
if (n_visible == 0)
{
panelSheets.Visible = false;
}
if (filepk > 0)
{
SaveDataTableToSQL(dt, filepk);
}
}
catch (Exception ex)
{
lblSubmitInfo.Text += sfilepk + "<br/>" + ex.Message;
}
}
}
}