protected void itemsGrid_PreRender(object sender, System.EventArgs e)
{
GridHeaderItem header = itemsGrid.MasterTableView.GetItems(GridItemType.Header)[0] as GridHeaderItem;
foreach (GridColumn col in itemsGrid.MasterTableView.RenderColumns
.OfType <IGridDataColumn>().Where(x => x.AllowFiltering))
{
if (!string.IsNullOrEmpty(col.EvaluateFilterExpression()))
{
TableCell cell = header[col.UniqueName];
cell.BackColor = System.Drawing.Color.SpringGreen;
cell.Style["background-image"] = "none";
cell.Controls.Add(new Image()
{
ID = "FilterIndicator" + col.UniqueName,
//ImageUrl = "~/arrow.png"
});
}
}
string USER_ID = WebTools.GetExpr("CREATE_BY", "PIP_MAT_REQUISITION", " WHERE MR_ID ='" + Request.QueryString["MR_ID"] + "'");
string CREATE_BY = WebTools.GetExpr("USER_NAME", "USERS", " WHERE USER_ID ='" + USER_ID + "'");
string USER_NAME = Session["USER_NAME"].ToString();
if (CREATE_BY.ToUpper() == USER_NAME.ToUpper() || WebTools.UserInRole("ADMIN"))
{
itemsGrid.ClientSettings.ClientEvents.OnRowDblClick = "RowDblClick";
}
else
{
itemsGrid.ClientSettings.ClientEvents.OnRowDblClick = "RowDblClickCancel";
}
}
//Setup in-grid links
protected void rgAllSites_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
GridDataItem item = (GridDataItem)e.Item;
int site_id = Convert.ToInt32(item.GetDataKeyValue("site_id"));
HyperLink hlSiteNo = (HyperLink)item.FindControl("hlSiteNo");
Button btnNWISWebSend = (Button)item.FindControl("btnNWISWebSend");
hlSiteNo.Attributes["target"] = "_blank";
hlSiteNo.Attributes["href"] = String.Format("{0}StationInfo.aspx?site_id={1}", Config.SIMSURL, site_id);
}
//Set custom column header tooltips
if (e.Item is GridHeaderItem)
{
GridHeaderItem header = (GridHeaderItem)e.Item;
header["sitefile_md"].ToolTip = "The date when data in the NWISWeb SITEFILE was last modified.";
header["revised_dt"].ToolTip = "The date when an element in the manuscript was last modified.";
header["approved_dt"].ToolTip = "The date when the manuscript was last approved.";
header["needs_approval"].ToolTip = "A Manuscript requires approval when a manuscript element has been changed since the last approval date.";
header["SendToNWISWeb"].ToolTip = "The Go! button allows a manual push of an approved manuscript to NWISWeb. A user may want this if the manuscript is not showing on NWISWeb or if autogenerated fields from NWIS have been changed and need to be updated.";
}
}
protected void rdgResidentDet_PreRender(object sender, EventArgs e)
{
try
{
GridHeaderItem headerItem = rdgResidentDet.MasterTableView.GetItems(GridItemType.Header)[0] as GridHeaderItem;
SqlProcsNew sqlobj = new SqlProcsNew();
DataSet dsHT = null;
dsHT = sqlobj.ExecuteSP("SP_FetchDashboardDet",
new SqlParameter()
{
ParameterName = "@IMODE", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 2
});
//headerItem["RTVillaNo"].Text = "Door No. (" + dsHT.Tables[0].Rows[0]["CDV"].ToString() + ")";
//headerItem["RTName"].Text = "Name (" + dsHT.Tables[1].Rows[0]["RCNT"].ToString() + ")";
//headerItem["CHK"].Text = "HK (" + dsHT.Tables[2].Rows[0]["CHK"].ToString() + ")";
//headerItem["CSR"].Text = "Services (" + dsHT.Tables[3].Rows[0]["CSR"].ToString() + ")";
//headerItem["Dining"].Text = "Regular Diners (" + dsHT.Tables[4].Rows[0]["CRD"].ToString() + ")";
headerItem["Dining"].Text = "Regular Diners";
//headerItem["DOB"].Text = "DOB (" + dsHT.Tables[5].Rows[0]["CDOB"].ToString() + ")";
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message.ToString());
}
}
protected void btnSMVRate_Click(object sender, EventArgs e)
{
try
{
GridHeaderItem header = (GridHeaderItem)this.RadGridCostSheet.MasterTableView.GetItems(GridItemType.Header)[0];
TextBox txtApplySMVRate = (TextBox)header.FindControl("txtApplySMVRate");
decimal smvRate = !string.IsNullOrEmpty(txtApplySMVRate.Text) ? Convert.ToDecimal(txtApplySMVRate.Text) : 0;
foreach (GridDataItem dgitem in this.RadGridCostSheet.Items)
{
Label lblCostSheet = (Label)dgitem.FindControl("lblCostSheet");
int costSheet = int.Parse(lblCostSheet.Text.ToString());
TextBox txtSMVRate = (TextBox)dgitem.FindControl("txtSMVRate");
txtSMVRate.Text = smvRate.ToString();
CostSheetBO objCostSheet = new CostSheetBO(this.ObjContext);
objCostSheet.ID = costSheet;
objCostSheet.GetObject();
objCostSheet.SMVRate = smvRate;
this.ObjContext.SaveChanges();
}
}
catch (Exception ex)
{
// Log the error
IndicoLogging.log.Error("Error occured while saving smvRate to the Cost Sheet from ViewCostSheets.aspx", ex);
}
Response.Redirect("ViewCostSheets.aspx");
}
protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)
{
if (e.Item is GridHeaderItem)
{
SqlProcsNew sqlobj = new SqlProcsNew();
DataSet dsHT = null;
dsHT = sqlobj.ExecuteSP("SP_FetchDashboardDet",
new SqlParameter()
{
ParameterName = "@IMODE", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 2
});
GridHeaderItem item = (GridHeaderItem)e.Item;
Label lblName = (Label)item.FindControl("lblName");
lblName.Text = "Name (" + dsHT.Tables[1].Rows[0]["RCNT"].ToString() + ")";
Label lblDoorNo = (Label)item.FindControl("lblDoorNo");
//lblDoorNo.Text = "Door No. (" + dsHT.Tables[0].Rows[0]["CDV"].ToString() + ")";
lblDoorNo.Text = "Door No.";
Label lblHK = (Label)item.FindControl("lblHK");
//lblHK.Text = "HK (" + dsHT.Tables[2].Rows[0]["CHK"].ToString() + ")";
lblHK.Text = "HK ";
Label lblServices = (Label)item.FindControl("lblServices");
lblServices.Text = "Services (" + dsHT.Tables[3].Rows[0]["CSR"].ToString() + ")";
Label lblEvents = (Label)item.FindControl("lblEvents");
//lblEvents.Text = "Events (" + dsHT.Tables[6].Rows[0]["EventCount"].ToString() + ")";
lblEvents.Text = "Events";
}
}
protected void RadGrid1_DataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
double total = 0;
string settlementno = string.Empty;
if (ViewState["filter"] != null)
{
settlementno = ViewState["filter"].ToString();
}
if (settlementno != "")
{
if (e.Item is GridFooterItem)
{
GridFooterItem footer = (GridFooterItem)e.Item;
if (gvEquityTransactions.Items.Count > 0)
{
total = Convert.ToDouble(Session["Total"]);
}
footer["TradeTotal"].Text = total.ToString("f2");
}
}
if (e.Item is GridHeaderItem)
{
GridHeaderItem header = (GridHeaderItem)e.Item;
if (ddl_type.SelectedValue == "$")
{
header["Rate"].Text = "Rate($)";
header["Brokerage"].Text = "Brokerage($)";
header["Net Rate With Brokerage"].Text = "Rate Inclusive Brokerage ($)";
header["Net Trade Consideration With Brokerage"].Text = "Gross Consideration with Brokerage ($)";
header["SebiTurnOverFee"].Text = "Sebi TurnOver Fee($)";
header["OtherCharges"].Text = "OtherCharges($)";
header["TradeTotal"].Text = "Gross Consideration ($)";
header["Net Rate With All Charges"].Text = "Net Rate Inclusive All Charges ($)";
header["Gross Trade Consideration"].Text = "Net Consideration Of All Charges ($)";
//----
header["TransactionCharges"].Text = "Transaction Charges ($)";
header["StampCharges"].Text = "Stamp Charges ($)";
header["STT"].Text = "STT ($)";
header["ServiceTax"].Text = "Service Tax ($)";
header["Demat Charge"].Text = "Demat Charge ($)";
header["Difference In Amount"].Text = "Difference In Amount ($)";
}
}
if (ddl_type.SelectedValue.ToString() == "INR")
{
gvEquityTransactions.MasterTableView.GetColumn("ForExRate").Display = false;
gvEquityTransactions.MasterTableView.GetColumn("ForExDate").Display = false;
gvEquityTransactions.MasterTableView.GetColumn("FXCurencyRate").Display = false;
gvEquityTransactions.MasterTableView.GetColumn("MktClosingForexRate").Display = false;
}
else
{
gvEquityTransactions.MasterTableView.GetColumn("ForExRate").Display = true;
gvEquityTransactions.MasterTableView.GetColumn("ForExDate").Display = true;
gvEquityTransactions.MasterTableView.GetColumn("FXCurencyRate").Display = true;
gvEquityTransactions.MasterTableView.GetColumn("MktClosingForexRate").Display = true;
}
}
private void SetTooltipGridHeader(GridHeaderItem gridHeader)
{
TableRow table = gridHeader as TableRow;
foreach (TableCell cell in table.Cells)
{
foreach (Control itemCtrl in cell.Controls)
{
if (itemCtrl is LinkButton)//Agrega tooltip al encabezado de la columna
{
LinkButton btn = itemCtrl as LinkButton;
btn.Attributes.Add("data-toggle", "tooltip");
}
else if (itemCtrl is CheckBox)//Agrega tooltip al checkbox seleccionar todo
{
CheckBox cbx = itemCtrl as CheckBox;
cbx.InputAttributes.Add("data-toggle", "tooltip");
}
else if (itemCtrl is Button)//Agrega tooltip al boton orden asc/desc
{
Button btn = itemCtrl as Button;
btn.Attributes.Add("data-toggle", "tooltip");
}
}
}
}
protected void btn_Cancel_Click(object sender, EventArgs e)
{
try
{
CheckBox chkBox = new CheckBox();
RadComboBox rcmbEmployee = new RadComboBox();
RadComboBox rcmbSubHead = new RadComboBox();
for (int index = 0; index <= Rg_DepartmentHeadsMapping.Items.Count - 1; index++)
{
chkBox = Rg_DepartmentHeadsMapping.Items[index].FindControl("chk_Select") as CheckBox;
rcmbEmployee = Rg_DepartmentHeadsMapping.Items[index].FindControl("rcmbEmployee") as RadComboBox;
rcmbSubHead = Rg_DepartmentHeadsMapping.Items[index].FindControl("rcmbSubHead") as RadComboBox;
rcmbEmployee.ClearSelection();
rcmbSubHead.ClearSelection();
if (chkBox.Checked)
{
chkBox.Checked = false;
}
}
//written by rajasekhar to clear grid header checkbox 22/nov/2013
GridHeaderItem headerItem = Rg_DepartmentHeadsMapping.MasterTableView.GetItems(GridItemType.Header)[0] as GridHeaderItem;
(headerItem.FindControl("chk_selectall") as CheckBox).Checked = false;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "DepartmentHeads", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
/// <summary>
/// Cari kartları ekranda listeleyen fonksiyon
/// </summary>
/// <param name="cariliste"> List<ExpandoObject> </param>
private void carileriListele(dynamic cariliste)
{
// listelemeden önce var olan gbx satırları silinir.
gbx_CariListe.Rows.Clear();
// Cariler listelenir
foreach (dynamic cari in cariliste)
{
// bir satır, kolon sayısı kadar string içermektedir.
string[] row = new string[gbx_CariListe.ColumnCount];
// Her bir kolon için bir satırdaki değeri, cari üzerinden çekilir
for (int i = 0; i < gridHeader.Count; i++)
{
// Grid içerisindeki kolonları oluştururken json içerisindeki key alan ile aynı
// olacak şekilde name alanını belirlemiştik.
GridHeaderItem item = gridHeader[i];
row[i] = (string)((IDictionary <string, Object>)cari)[item.name];
}
// satır eklemesi yapılır
try
{
gbx_CariListe.Rows.Add(row);
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
}
}
protected void gvExceptionReport_ItemDataBound(object sender, GridItemEventArgs e)
{
customerBo = new CustomerBo();
if (e.Item is GridEditFormInsertItem && e.Item.OwnerTableView.IsItemInserted)
{
GridEditFormInsertItem item = (GridEditFormInsertItem)e.Item;
TextBox txtFolioDataForEditForm = (TextBox)item.FindControl("txtFolioDataForEditForm");
TextBox txtFolioNumberForEditForm = (TextBox)item.FindControl("txtFolioNumberForEditForm");
txtFolioDataForEditForm.Text = txtFolioDataForEditForm.Text;
txtFolioNumberForEditForm.Text = txtFolioNumberForEditForm.Text;
}
string panNum = string.Empty;
string ISAChck = string.Empty;
if (e.Item is GridDataItem)
{
GridDataItem dataItem = e.Item as GridDataItem;
LinkButton buttonEdit = dataItem["editColumn"].Controls[0] as LinkButton;
string ProfileDate = dataItem["ProfileFolio"].Text;
panNum = dataItem["Exception"].Text;
ISAChck = dataItem["CustomerName"].Text;
if (ISAChck == "ISAF")
{
buttonEdit.Visible = false;
}
ProfileDate = ProfileDate.ToUpper();
if (ProfileDate == "PROFILE")
{
buttonEdit.Visible = false;
}
int customerId = int.Parse(dataItem["CustomerId"].Text);
}
if (e.Item is GridHeaderItem)
{
GridHeaderItem headeritem = e.Item as GridHeaderItem;
string value = ddlExpList.SelectedItem.Text;
headeritem["Exception"].Text = value;
string NewValue = ddlExpType.SelectedItem.Value;
if (NewValue == "ISAF")
{
headeritem["ProfileFolio"].Text = "Folio Mode Of Holding";
headeritem["Exception"].Text = "ISA Mode Of Holding";
headeritem["Exceptionlist"].Text = "ISA No.";
}
}
if (e.Item is GridEditFormItem && e.Item.IsInEditMode && e.Item.ItemIndex != -1)
{
//int customerId = int.Parse(gvExceptionReport.MasterTableView.DataKeyValues[e.Item.ItemIndex]["customerId"].ToString());
//GridEditFormItem editedItem = (GridEditFormItem)e.Item;
//TextBox txtFolioDataForEditForm = (TextBox)editedItem.FindControl("txtFolioDataForEditForm");
//TextBox txtFolioNumberForEditForm = (TextBox)editedItem.FindControl("txtFolioNumberForEditForm");
//txtFolioDataForEditForm.Text = txtFolioDataForEditForm.Text;
//txtFolioNumberForEditForm.Text = txtFolioNumberForEditForm.Text;
}
}
protected void RadGridCertificate_ItemCreated(object sender, GridItemEventArgs e)
{
if (e.Item is GridHeaderItem)
{
GridHeaderItem headerItem = (GridHeaderItem)e.Item;
CheckBox checkBox = (CheckBox)headerItem["ClientSelectionColumn"].Controls[0];
checkBox.AutoPostBack = true;
checkBox.CheckedChanged += new EventHandler(checkBox_CheckedChanged);
}
}
protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)
{
GridHeaderItem headerItem = e.Item as GridHeaderItem;
if (headerItem != null)
{
headerItem["EditColumn"].Text = string.Empty;
headerItem["DeleteColumn"].Text = string.Empty;
}
}
void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)
{
if (e.Item.ItemType == GridItemType.Header)
{
GridHeaderItem headerItem = (GridHeaderItem)e.Item;
CheckBox chkSelectAll = (CheckBox)headerItem["template"].Controls[1];
HiddenField.Value = chkSelectAll.ClientID;
string script = "CheckUnCheckAll('" + chkSelectAll.ClientID + "')";
chkSelectAll.Attributes.Add("onclick", script);
}
}
private static GridItemBase GetDefaultColumn(string s)
{
if (s == "name")
{
GridHeaderItem nameHeaderItem = NewHeaderItem(Messages.OVERVIEW_NAME, SortOrder.Ascending, 250, 250);
nameHeaderItem.IsDefaultSortColumn = true;
nameHeaderItem.Immovable = true;
return(nameHeaderItem);
}
if (s == "cpu")
{
return(NewHeaderItem(Messages.OVERVIEW_CPU_USAGE, SortOrder.Descending, 115, 115));
}
if (s == "memory")
{
return(NewHeaderItem(Messages.OVERVIEW_MEMORY_USAGE, SortOrder.Descending, 125, 125));
}
if (s == "disks")
{
int colWidth;
Int32.TryParse(resources.GetString("DISKS_OVERVIEW_COL_WIDTH"), out colWidth);
return(NewGridHeaderItem(Messages.OVERVIEW_DISKS, SortOrder.Descending, colWidth, colWidth));
}
if (s == "network")
{
int colWidth;
Int32.TryParse(resources.GetString("NETWORK_OVERVIEW_COL_WIDTH"), out colWidth);
return(NewGridHeaderItem(Messages.OVERVIEW_NETWORK, SortOrder.Descending, colWidth, colWidth));
}
if (s == "ha")
{
return(NewHeaderItem(Messages.HA, SortOrder.Ascending, 120, 120));
}
if (s == "ip")
{
return(NewHeaderItem(Messages.ADDRESS, SortOrder.Ascending, 120, 120));
}
if (s == "uptime")
{
return(NewHeaderItem(Messages.UPTIME, SortOrder.Descending, 170, 170));
}
// dont be a muppet, only ask for a default column
return(NewHeaderItem(s, SortOrder.Ascending, 100, 100));
}
private void gridChek(bool estatus, string ChekName)
{
try
{
GridHeaderItem headerItem = (GridHeaderItem)RadGridPermisos.MasterTableView.GetItems(GridItemType.Header)[0];
CheckBox chkbx = (CheckBox)headerItem.FindControl(ChekName);
chkbx.Checked = estatus;
}
catch (Exception ex)
{
throw ex;
}
}
private bool IsMovableColumn(string column)
{
if (GridHeaderRow == null || !GridHeaderRow.Items.ContainsKey(column))
{
return(true);
}
GridHeaderItem item = GridHeaderRow.Items[column] as GridHeaderItem;
if (item == null)
{
return(true);
}
return(!item.Immovable);
}
protected void ToggleRowSelection(object sender, EventArgs e)
{
((sender as CheckBox).NamingContainer as GridItem).Selected = (sender as CheckBox).Checked;
bool checkHeader = true;
foreach (GridDataItem dataItem in grdList.MasterTableView.Items)
{
if (!(dataItem.FindControl("CheckBox1") as CheckBox).Checked)
{
checkHeader = false;
break;
}
}
GridHeaderItem headerItem = grdList.MasterTableView.GetItems(GridItemType.Header)[0] as GridHeaderItem;
(headerItem.FindControl("headerChkbox") as CheckBox).Checked = checkHeader;
}
protected void rgSolicitudDet_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
GridDataItem item = (GridDataItem)e.Item;
if (HFTipoOp.Value == "0")
{
item["Cancelado"].Visible = false;
}
else
{
RadioButton rbA;
RadioButton rbR;
RadioButton rbC;
rbA = ((RadioButton)item.FindControl("chkAutorizar"));
rbR = ((RadioButton)item.FindControl("chkRechazar"));
rbC = ((RadioButton)item.FindControl("chkCancelado"));
rbA.Enabled = false;
rbR.Enabled = false;
rbC.Enabled = false;
}
}
if (e.Item is GridHeaderItem)
{
GridHeaderItem item = (GridHeaderItem)e.Item;
if (HFTipoOp.Value == "0")
{
item["Cancelado"].Visible = false;
}
else
{
RadioButton rbA;
RadioButton rbR;
RadioButton rbC;
rbA = ((RadioButton)item.FindControl("chkAutorizarAll"));
rbR = ((RadioButton)item.FindControl("chkRechazarAll"));
rbC = ((RadioButton)item.FindControl("chkCanceladoAll"));
rbA.Enabled = false;
rbR.Enabled = false;
rbC.Enabled = false;
}
}
}
private void GenerateTable(RadGrid grid, xls.Table singleTable)
{
if (ExportingType.SelectedValue == "1")
{
singleTable = new xls.Table(grid.ID);
row = 1;
col = 1;
}
else
{
if (!isFirstItem)
{
row++;
}
else
{
isFirstItem = false;
}
}
GridHeaderItem headerItem = grid.MasterTableView.GetItems(GridItemType.Header)[0] as GridHeaderItem;
for (int i = 2; i < headerItem.Cells.Count; i++)
{
singleTable.Cells[i - 1, row].Value = headerItem.Cells[i].Text;
}
row++;
foreach (GridDataItem item in grid.MasterTableView.Items)
{
foreach (GridColumn column in grid.Columns)
{
singleTable.Cells[col, row].Value = item[column.UniqueName].Text;
col++;
}
col = 1;
row++;
}
if (ExportingType.SelectedValue == "1")
{
structure.Tables.Add(singleTable);
}
}
public override void InitializeCell(TableCell cell, int columnIndex, GridItem inItem)
{
base.InitializeCell(cell, columnIndex, inItem);
if (inItem is GridHeaderItem && !String.IsNullOrEmpty(HeaderText))
{
GridHeaderItem headerItem = inItem as GridHeaderItem;
string columnName = DataField;
if (!Owner.AllowSorting)
{
cell.Text = Localization.GetString(string.Format("{0}.Header", HeaderText), LocalResourceFile);
}
else
{
LinkButton button = (LinkButton)headerItem[columnName].Controls[0];
button.Text = Localization.GetString(string.Format("{0}.Header", HeaderText), LocalResourceFile);
}
}
}
protected void chkSelectAll_CheckedChanged(object sender, EventArgs e)
{
GridHeaderItem HeaderItem = (GridHeaderItem)AttbtsgrdView.MasterTableView.GetItems(GridItemType.Header)[0];
CheckBox chkSelectAll = (CheckBox)HeaderItem.FindControl("chkSelectAll");
if (chkSelectAll.Checked)
{
LoadGridCheckfalse();
//chkSelectAll.Checked = true;
}
else
{
LoadGrid();
LoadGrid2();
LoadGrid3();
LoadGrid4();
LoadGrid5();
//chkSelectAll.Checked = false;
}
}
protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)
{
if (e.Item is GridHeaderItem && RadGrid1.IsExporting)
{
GridHeaderItem item = e.Item as GridHeaderItem;
foreach (GridColumn col in RadGrid1.MasterTableView.AutoGeneratedColumns)
{
if (col.HeaderStyle.Width.Type == UnitType.Percentage)
{
double size = RadGrid1.Width.Value;
Unit unit = new Unit(size * col.HeaderStyle.Width.Value / 100, RadGrid1.Width.Type);
col.HeaderStyle.Width = unit;
}
}
}
if (RadGrid1.IsExporting)
{
FormatGridItem(e.Item);
}
}
protected void rgVinculados_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
GridDataItem item = (GridDataItem)e.Item;
if (HFId_Cd.Value != "-1")
{
item["Cancelar"].Visible = false;
}
}
if (e.Item is GridHeaderItem)
{
GridHeaderItem item = (GridHeaderItem)e.Item;
if (HFId_Cd.Value != "-1")
{
item["Cancelar"].Visible = false;
}
}
}
protected void LoadDocUpload()
{
if (Session["ResidentRSN"].ToString() != "")
{
try
{
int RTRSN = Convert.ToInt32(Session["ResidentRSN"].ToString());
SqlCommand cmd = new SqlCommand("PROC_CC_ResDocUpload", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@IMODE", SqlDbType.Int).Value = 6;
cmd.Parameters.Add("@RTRSN", SqlDbType.Int).Value = RTRSN;
DataSet dsGrid = new DataSet();
//rdgHwatch.DataBind();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dsGrid);
if (dsGrid != null && dsGrid.Tables.Count > 0 && dsGrid.Tables[0].Rows.Count > 0)
{
rdDoc.DataSource = dsGrid.Tables[0];
rdDoc.DataBind();
GridHeaderItem HeaderItem = (GridHeaderItem)AttbtsgrdView.MasterTableView.GetItems(GridItemType.Header)[0];
CheckBox chkSelectAll = (CheckBox)HeaderItem.FindControl("chkSelectAll");
chkSelectAll.Checked = false;
rdgHwatch.AllowPaging = true;
}
else
{
rdDoc.DataSource = new String[] { };
rdDoc.DataBind();
}
}
catch (Exception ex)
{
WebMsgBox.Show(ex.ToString());
}
}
else
{
}
}
protected void rgOrdenCompra_ItemDataBound(object sender, GridItemEventArgs e)
{
try
{
if (e.Item is GridHeaderItem)
{
GridHeaderItem header = (GridHeaderItem)e.Item;
header["ventaMes0"].Text = string.Concat("Venta ", this.VentaMes0Desc);
header["ventaMes1"].Text = string.Concat("Venta ", this.VentaMes1Desc);
header["ventaMes2"].Text = string.Concat("Venta ", this.VentaMes2Desc);
header["ventaMes3"].Text = string.Concat("Venta ", this.VentaMes3Desc);
GridItem cmdItem = rgOrdenCompra.MasterTableView.GetItems(GridItemType.CommandItem)[0];
cmdItem.FindControl("AddNewRecordButton").Parent.Visible = false;
}
}
catch (Exception ex)
{
DisplayMensajeAlerta(string.Concat(ex.Message, "rgOrdenCompra_ItemDataBound"));
}
}
protected void LoadGridCheckfalse()
{
if (Session["ResidentRSN"].ToString() != "")
{
try
{
int RSN = Convert.ToInt32(Session["ResidentRSN"].ToString());
SqlCommand cmd = new SqlCommand("SP_AttributeGridLoad1", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@IMODE", SqlDbType.Int).Value = 1;
cmd.Parameters.Add("@RTRSN", SqlDbType.Int).Value = RSN;
DataSet dsGrid = new DataSet();
AttbtsgrdView.DataBind();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dsGrid);
if (dsGrid != null && dsGrid.Tables.Count > 0 && dsGrid.Tables[0].Rows.Count > 0)
{
AttbtsgrdView.DataSource = dsGrid.Tables[0];
AttbtsgrdView.DataBind();
GridHeaderItem HeaderItem = (GridHeaderItem)AttbtsgrdView.MasterTableView.GetItems(GridItemType.Header)[0];
CheckBox chkSelectAll = (CheckBox)HeaderItem.FindControl("chkSelectAll");
chkSelectAll.Checked = true;
AttbtsgrdView.AllowPaging = true;
}
else
{
AttbtsgrdView.DataSource = new String[] { };
AttbtsgrdView.DataBind();
}
}
catch
{
}
}
else
{
}
}
protected void btnApply_Click(object sender, EventArgs e)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
Button btn = (Button)(sender);
int level = int.Parse(btn.CommandName);
GridHeaderItem header = (GridHeaderItem)this.RadGridCostSheets.MasterTableView.GetItems(GridItemType.Header)[0];
TextBox txtPrice = (TextBox)header.FindControl("txtPrice" + level);
PriceLevelNewBO objLevel = new PriceLevelNewBO(this.ObjContext);
objLevel.ID = level;
objLevel.GetObject();
objLevel.LastModifier = this.LoggedUser.ID;
objLevel.LastModifiedDate = DateTime.Now;
objLevel.Markup = decimal.Parse(txtPrice.Text);
this.ObjContext.SaveChanges();
ts.Complete();
}
if (IsFOB)
{
Server.Transfer("EditIndicoFOBPriceLevel.aspx");
}
else
{
Server.Transfer("EditIndicoCIFPriceLevel.aspx");
}
}
catch (Exception ex)
{
// Log the error
IndicoLogging.log.Error("Error occured while saving value to PriceLevelNewBO from IndicoPriceLevels.ascx", ex);
}
}
//Setup in-grid links
protected void rgApprove_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
GridDataItem item = (GridDataItem)e.Item;
int site_id = Convert.ToInt32(item.GetDataKeyValue("site_id"));
HyperLink hlSiteNo = (HyperLink)item.FindControl("hlSiteNo");
hlSiteNo.Attributes["target"] = "_blank";
hlSiteNo.Attributes["href"] = String.Format("{0}StationInfo.aspx?site_id={1}", Config.SIMSURL, site_id);
}
//Set custom column header tooltips
if (e.Item is GridHeaderItem)
{
GridHeaderItem header = (GridHeaderItem)e.Item;
header["sitefile_md"].ToolTip = "The date when data in the NWISWeb SITEFILE was last modified.";
header["revised_dt"].ToolTip = "The date when an element in the manuscript was last modified.";
header["approved_dt"].ToolTip = "The date when the manuscript was last approved.";
}
}
private void TraverseGridStructure()
{
GridHeaderItem headers = RadGrid1.MasterTableView.GetItems(GridItemType.Header)[0] as GridHeaderItem;
int startIndex = RadGrid1.MasterTableView.GroupByExpressions.Count + 2;
for (int i = startIndex; i < headers.Cells.Count; i++)
{
table.Cells[i - 1, row].Value = headers.Cells[i].Text;
}
row++;
GridItem[] headerCollection = RadGrid1.MasterTableView.GetItems(GridItemType.GroupHeader);
foreach (GridDataItem item in RadGrid1.MasterTableView.Items)
{
string[] groupIndexArray = item.GroupIndex.Split('_');
TraverseHeaderItems(headerCollection, groupIndexArray);
for (int i = groupIndexArray.Length + 1; i < item.Controls.Count; i++)
{
table.Cells[i - 1, row].Value = (item.Controls[i] as GridTableCell).Text;
}
row++;
}
}
protected void rg1_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
Sesion sesion = (Sesion)Session["Sesion" + Session.SessionID];
Convenio conv = (Convenio)Session["Convenio" + Session.SessionID];
GridDataItem item = (GridDataItem)e.Item;
if (conv.Pue_Admin1 != sesion.Id_U && conv.Pue_Admin2 != sesion.Id_U)
{
item["Atender"].Visible = false;
}
else
{
item["Editar"].Visible = false;
item["Enviar"].Visible = false;
item["Eliminar"].Visible = false;
}
}
if (e.Item is GridHeaderItem)
{
Sesion sesion = (Sesion)Session["Sesion" + Session.SessionID];
Convenio conv = (Convenio)Session["Convenio" + Session.SessionID];
GridHeaderItem item = (GridHeaderItem)e.Item;
if (conv.Pue_Admin1 != sesion.Id_U && conv.Pue_Admin2 != sesion.Id_U)
{
item["Atender"].Visible = false;
}
else
{
item["Editar"].Visible = false;
item["Enviar"].Visible = false;
item["Eliminar"].Visible = false;
}
}
}