protected void cargarParametrosdeXml()
{
RadGrid RadGrid_parametros = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("RadGrid_parametros") as RadGrid;
string path = Server.MapPath("~/parametros.xml");
if (System.IO.File.Exists(path))
{
Reportes_parametros oReportes_parametros = new Reportes_parametros();
oReportes_parametros.Id_reporte = Convert.ToInt32(this.Session["Reporte"]);
oReportes_parametros.Id_user = this.Session["sUser"].ToString();
oReportes_parametros.Id_compañia = Convert.ToInt32(this.Session["companyid"]);
oReportes_parametros.Id_servicio = Convert.ToInt32(this.Session["Service"]);
oReportes_parametros.Id_canal = this.Session["Canal"].ToString().Trim();
oReportes_parametros.Id_tipoReporte = this.Request.Path;
Reportes_parametrosToXml oReportes_parametrosToXml = new Reportes_parametrosToXml();
try
{
RadGrid_parametros.DataSource = oReportes_parametrosToXml.Get_Parametros(oReportes_parametros, path);
RadGrid_parametros.DataBind();
}
catch
{
}
}
}
public static void HandleEditableGridItemDataBound(BasePage page, RadGrid Grid, CodeTorch.Core.Grid GridConfig, bool UseDefaultCommand, string DefaultCommandName, object sender, GridItemEventArgs e)
{
HandleBinaryImageColumnsOnDataBound(Grid, GridConfig, e);
HandleEditableGridDetailPopulation(page, GridConfig, UseDefaultCommand, DefaultCommandName, e);
}
public static void SetStyle(RadGrid grid, int?pageSize)
{
grid.MasterTableView.GridLines = System.Web.UI.WebControls.GridLines.Both;
grid.Skin = "Windows7";
grid.CellSpacing = 0;
grid.AutoGenerateColumns = false;
grid.ClientSettings.EnableRowHoverStyle = true;
grid.ClientSettings.Selecting.AllowRowSelect = true;
grid.MasterTableView.EditMode = GridEditMode.InPlace;
grid.AllowSorting = true;
if (pageSize.HasValue)
{
grid.AllowPaging = true;
grid.PageSize = pageSize.Value;
}
else
{
grid.AllowPaging = false;
}
grid.PagerStyle.Mode = GridPagerMode.NumericPages;
grid.MasterTableView.EnableNoRecordsTemplate = true;
grid.GroupingSettings.CaseSensitive = false;
//grid.AlternatingItemStyle.BackColor = Color.WhiteSmoke;
//grid.ItemStyle.BackColor = Color.WhiteSmoke;
//grid.AlternatingItemStyle.ForeColor = _grid.ItemStyle.ForeColor;
}
public static void MostrarResultadoOperacionBd(ref RadGrid grilla, string texto, bool resultado)
{
var color = COLOR_RESULTADO_MAL;
if ((resultado))
color = COLOR_RESULTADO_BIEN;
grilla.Controls.Add(new LiteralControl(string.Format("<span style='color:{0}; font-weight:bold; width:100%; text-align:center;'>{1}</span>", color, texto)));
}
// to populate the contacts selection while paging
public void populateContactSelection(string checkboxid, string lblContactId, RadGrid Rgrid, string hdrchkbox)
{
try
{
if (ViewState["SelectedContacts"] != null)
{
ArrayList selectedContacts = (ArrayList)ViewState["SelectedContacts"];
if (selectedContacts.Count > 0)
{
foreach (GridDataItem row in Rgrid.MasterTableView.Items)
{
CheckBox objCheckBox = (CheckBox)row.FindControl(checkboxid);
Label ContactID = (Label)row.FindControl(lblContactId);
if (selectedContacts.Contains(ContactID.Text))
{
objCheckBox.Checked = true;
count++;
}
else
{
objCheckBox.Checked = false;
}
}
}
}
// UpdatePanel1.Update();
}
catch (Exception ex)
{
//lblAddRecipientsMsg.Text = "Error: " + ex.Message;
}
}
public static DataTable ConvertDataGridToDataTable(RadGrid MyGrid)
{
DataTable dtable = new DataTable();
int columncount = 0;
foreach (GridColumn column in MyGrid.MasterTableView.Columns)
{
if (!string.IsNullOrEmpty(column.UniqueName) && !string.IsNullOrEmpty(column.HeaderText))
{
columncount++;
dtable.Columns.Add(column.UniqueName, typeof(string));
}
}
DataRow dr;
foreach (GridDataItem item in MyGrid.MasterTableView.Items)
{
dr = dtable.NewRow();
for (int i = 0; i < columncount; i++)
{
dr[i] = item[MyGrid.MasterTableView.Columns[i].UniqueName].Text;
}
dtable.Rows.Add(dr);
}
return(dtable);
}
public bool Check_Combo(RadGrid rdGrid, string lbl_validate, RadComboBox rcmb_Validate)
{
bool status = true;
try
{
if (rdGrid.Items.Count > 0)
{
for (int i = 0; i < rdGrid.Items.Count; i++)
{
Label lbl_Control = new Label();
lbl_Control = rdGrid.Items[i].FindControl("" + lbl_validate + "") as Label;
if (Convert.ToInt32(lbl_Control.Text) == Convert.ToInt32(rcmb_Validate.SelectedValue))
{
status = false;
}
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Qualification", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
return(status);
}
public static void HideAddCommandItem(RadGrid Grid)
{
GridItem[] items = Grid.MasterTableView.GetItems(GridItemType.CommandItem);
if ((items != null) && (items.Length > 0))
{
foreach (GridCommandItem cmdItem in items)
{
if (cmdItem != null)
{
Control AddText = (cmdItem.FindControl("InitInsertButton"));
if (AddText != null)
{
AddText.Visible = false;
}
Control AddButton = (cmdItem.FindControl("AddNewRecordButton"));
if (AddButton != null)
{
AddButton.Visible = false;
}
}
}
}
}
public static void BuildGridColumn(BasePage page, RadGrid Grid, Grid GridObject, CodeTorch.Core.GridColumn Column, string ResourceKeyPrefix)
{
switch (Column.ColumnType)
{
case GridColumnType.BoundGridColumn:
BuildGridBoundColumn(page, Grid, GridObject, (BoundGridColumn)Column, ResourceKeyPrefix);
break;
case GridColumnType.HyperLinkGridColumn:
BuildGridHyperLinkColumn(page, Grid, GridObject, (HyperLinkGridColumn)Column, ResourceKeyPrefix);
break;
case GridColumnType.DeleteGridColumn:
BuildGridDeleteColumn(page, Grid, GridObject, (DeleteGridColumn)Column, ResourceKeyPrefix);
break;
case GridColumnType.EditGridColumn:
BuildGridEditColumn(page, Grid, GridObject, (EditGridColumn)Column, ResourceKeyPrefix);
break;
case GridColumnType.PickerLinkButtonGridColumn:
PickerLinkButtonColumn(page, Grid, GridObject, (PickerLinkButtonGridColumn)Column, ResourceKeyPrefix);
break;
case GridColumnType.PickerHyperLinkGridColumn:
BuildGridPickerHyperLinkGridColumn(page, Grid, GridObject, (PickerHyperLinkGridColumn)Column, ResourceKeyPrefix);
break;
case GridColumnType.BinaryImageGridColumn:
BuildBinaryImageGridColumn(page, Grid, GridObject, (BinaryImageGridColumn)Column, ResourceKeyPrefix);
break;
}
}
public void PopulateGrid_temporaryCodesInUse(RadGrid grid)
{
List <TemporaryUser> list = FilterGridList();//GetTemporayCodesInUse();
grid.DataSource = list;
grid.DataBind();
}
public static void SetUpGrid(RadGrid grid)
{
// content
grid.ShowHeader = true;
grid.MasterTableView.NoMasterRecordsText = "Tidak ada data";
grid.MasterTableView.NoDetailRecordsText = "Tidak ada data";
//sorting
grid.AllowSorting = true;
grid.HeaderStyle.Font.Bold = true;
grid.MasterTableView.AllowMultiColumnSorting = true;
// filtering
grid.EnableLinqExpressions = false;
grid.FilterType = GridFilterType.Classic;
grid.AllowFilteringByColumn = true;
grid.MasterTableView.AllowFilteringByColumn = true;
grid.MasterTableView.EnableHeaderContextFilterMenu = false;
// paging
grid.AllowPaging = true;
grid.PagerStyle.PageSizeLabelText = "Banyak baris";
grid.PagerStyle.PrevPageToolTip = "Halaman sebelum";
grid.PagerStyle.NextPageToolTip = "Halaman berikut";
grid.PagerStyle.FirstPageToolTip = "Halaman pertama";
grid.PagerStyle.LastPageToolTip = "Halaman terakhir";
grid.PagerStyle.PagerTextFormat = "Menampilkan {3} dari {1} halaman";
}
// form controls setting for insert/udpate
// grid exporting functions
protected void gvHistory_ItemCommand(object sender, GridCommandEventArgs e)
{
RadGrid grid = (sender as RadGrid);
if (e.CommandName == RadGrid.InitInsertCommandName)
{
grid.MasterTableView.ClearEditItems();
}
if (e.CommandName == RadGrid.EditCommandName)
{
e.Item.OwnerTableView.IsItemInserted = false;
}
if (e.CommandName == RadGrid.RebindGridCommandName)
{
grid.MasterTableView.ClearEditItems();
e.Item.OwnerTableView.IsItemInserted = false;
if (htSearchParams != null)
{
htSearchParams.Clear();
}
}
if (e.CommandName == RadGrid.ExportToExcelCommandName)
{
exporting = true;
grid.GridLines = GridLines.Both;
grid.BorderStyle = BorderStyle.Solid;
grid.BorderWidth = Unit.Pixel(1);
grid.MasterTableView.GetColumn("EditHistory").Visible = false;
grid.MasterTableView.GetColumn("DeleteHistory").Visible = false;
grid.MasterTableView.ExportToExcel();
}
if (e.CommandName == RadGrid.ExportToCsvCommandName)
{
exporting = true;
grid.GridLines = GridLines.Both;
grid.BorderStyle = BorderStyle.Solid;
grid.BorderWidth = Unit.Pixel(1);
grid.MasterTableView.GetColumn("EditHistory").Visible = false;
grid.MasterTableView.GetColumn("DeleteHistory").Visible = false;
grid.ExportSettings.ExportOnlyData = false;
grid.MasterTableView.ExportToCSV();
}
if (e.CommandName == RadGrid.ExportToPdfCommandName)
{
exporting = true;
grid.GridLines = GridLines.Both;
grid.BorderStyle = BorderStyle.Solid;
grid.BorderWidth = Unit.Pixel(1);
grid.MasterTableView.GetColumn("EditHistory").Visible = false;
grid.MasterTableView.GetColumn("DeleteHistory").Visible = false;
grid.MasterTableView.ExportToPdf();
}
}
protected void btExportExcel_Click(object sender, EventArgs e)
{
//Export the GridView to Excel
Common.ICommonDBHandler cdb = new Common.CommonDBHandler();
//GridView whichgrid = new GridView();
RadGrid whichgrid = new RadGrid();
whichgrid.AllowPaging = false;
string sort = ViewState["SearchResultSortExpression"].ToString() + ' ' + ViewState["SearchResultSortDirection"].ToString();
gvSearchResults.Columns[13].Visible = true;
whichgrid = gvSearchResults;
Common.ExportToExcel.PrepareGridViewForExport(whichgrid);
whichgrid.Columns[0].Visible = false;
whichgrid.Columns[13].Visible = true;
whichgrid.Columns[14].Visible = false;
whichgrid.Columns[20].Visible = false;
whichgrid.Columns[21].Visible = false;
whichgrid.Columns[22].Visible = false;
whichgrid.Columns[23].Visible = false;
whichgrid.Columns[24].Visible = false;
whichgrid.MasterTableView.ExportToExcel();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(hfTrxId.Value))
{
Hashtable ht_submit = new Hashtable();
ht_submit.Add("@trxid", Convert.ToInt32(hfTrxId.Value));
clsDAL.ExecuteNonQuery("sp_Payroll_Delete_LoanTransaction", ht_submit);
rCmbRecords.Text = string.Empty;
rCmbRecords.ClearSelection();
RadGrid grid = (rCmbRecords.Items[0].FindControl("rGrdRecords4DDL") as RadGrid);
if (grid != null)
{
grid.Rebind();
}
ShowClientMessage(string.Format("Record Deleted Successfully"), MessageType.Success);
hfTrxId.Value = string.Empty;
clearForm();
}
else
{
ShowClientMessage(string.Format("Please select a record"), MessageType.Error);
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowTab", "ShowTab('#tab1');", true);
}
protected void rGrdRecordsArchived4DDL_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
Hashtable ht = new Hashtable();
RadGrid grid = sender as RadGrid;
grid.DataSource = clsDAL.GetDataSet_Payroll("sp_User_Get_All_Archived_LeaveResumption", ht).Tables[0];
}
protected void ActionTypeSelect_Checked(object sender, EventArgs e)
{
CheckBox cb = (CheckBox)sender;
if (cb.Checked)
{
RadGrid rg = (RadGrid)cb.Parent.Parent.Parent.Parent.Parent; // inner grid
{
foreach (GridItem item in rg.Items)
{
CheckBox cx = (CheckBox)item.FindControl("cbSelectType");
if (cx == cb)
{
cx.Checked = true;
HiddenField hfx = (HiddenField)item.FindControl("hfActionType");
HiddenField hf = (HiddenField)rg.Parent.Parent.FindControl("hfActionType");
hf.Value = hfx.Value;
TextBox tb = (TextBox)item.FindControl("tbActionCriteria");
Label lbl = (Label)rg.Parent.Parent.FindControl("lblActionCriteria");
lbl.Text = tb.Text;
}
else
{
cx.Checked = false;
}
}
}
//cb.Checked = true;
}
}
public static void HandleInsertCommand(BasePage page, RadGrid Grid, CodeTorch.Core.Grid GridConfig, string InsertCommandName, object source, GridCommandEventArgs e)
{
DataCommandService dataCommandDB = DataCommandService.GetInstance();
PageDB pageDB = new PageDB();
log4net.ILog log = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
if (page.IsValid)
{
try
{
List <ScreenDataCommandParameter> parameters = null;
log.Info("\r\n\r\nIn Insert Mode");
if (String.IsNullOrEmpty(InsertCommandName))
{
throw new ApplicationException("InsertCommand is invalid");
}
log.DebugFormat("InsertCommand:{0}", InsertCommandName);
parameters = pageDB.GetPopulatedCommandParameters(InsertCommandName, page);
dataCommandDB.ExecuteDataCommand(InsertCommandName, parameters);
}
catch (Exception ex)
{
e.Canceled = true;
page.DisplayErrorAlert(ex);
}
}
}
protected void rGrdHourType4DDL_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
htSearchParams = new Hashtable();
RadGrid grid = sender as RadGrid;
grid.DataSource = clsDAL.GetDataSet_Payroll("sp_payroll_GetHourTypeRecords", htSearchParams).Tables[0];
}
protected void Page_Init()
{
RadGrid grid = this.Controls[0].FindControl("RadGrid1") as RadGrid;
grid.NeedDataSource += new GridNeedDataSourceEventHandler(grid_NeedDataSource);
grid.DataBind();
string viewState = Request.Form["__VIEWSTATE"];
if (!string.IsNullOrEmpty(viewState))
{
LosFormatter formatter = new LosFormatter();
object savedStateObject = formatter.Deserialize(viewState);
MethodInfo method = grid.GetType().GetMethod("LoadViewState", BindingFlags.NonPublic | BindingFlags.Instance);
// TODO: Find a less brittle/more elegant way to isolate the appropiate viewstate object for this control
// In the case of Telerik's RadGrid, the key wasy find the tree that had an array of 13 objects
method.Invoke(grid, new object[] { (((((((((savedStateObject as Pair).First as Pair).Second as Pair).Second as System.Collections.ArrayList)[1] as Pair).Second as System.Collections.ArrayList)[1] as Pair).Second as System.Collections.ArrayList)[1] as Pair).First });
}
string eventArgument = Request.Form["__EVENTARGUMENT"];
if (!string.IsNullOrEmpty(eventArgument))
{
grid.RaisePostBackEvent(eventArgument);
}
}
private void SetLeaveCode(string strID)
{
RadGrid grid = rCmbLeaveCode.Items[0].FindControl("rGrdLeaveCodes4DDL") as RadGrid;
if (grid != null)
{
foreach (GridItem item in grid.MasterTableView.Items)
{
if (item is GridDataItem)
{
GridDataItem dataItem = (GridDataItem)item;
if (dataItem.OwnerTableView.DataKeyValues[dataItem.ItemIndex]["recidd"].ToString() == strID)
{
dataItem.Selected = true;
rCmbLeaveCode.Items[0].Value = strID;
rCmbLeaveCode.Items[0].Text = dataItem.OwnerTableView.DataKeyValues[dataItem.ItemIndex]["levcod"].ToString();
rCmbLeaveCode.Text = dataItem.OwnerTableView.DataKeyValues[dataItem.ItemIndex]["levcod"].ToString();
break;
}
}
}
}
rCmbLeaveCode.Enabled = true;
}
protected void rGrdMeasurmentType4DDL_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
htSearchParams = new Hashtable();
RadGrid grid = sender as RadGrid;
grid.DataSource = clsCommon.DDLValueSet_GetByDDLID_FromCentralDb(Constraints.DropDownLists.MeasurmentType, -1, 1).Tables[0];
}
/* ------ SETTINGS METHODS -------*/
// Changes a radgrid to a predefined settings
public static void SetStandardGrid(RadGrid aGrid)
{
// Set filtering functions
aGrid.AllowPaging = true;
aGrid.PageSize = 25;
//aGrid.PagerStyle.PageSizeControlType = // TODO : Set this
aGrid.AllowSorting = true;
aGrid.AllowFilteringByColumn = false;
aGrid.MasterTableView.ToolTip = "Double click to open (or select and press enter)";
// Set grid visualization
aGrid.SelectedItemStyle.ForeColor = System.Drawing.ColorTranslator.FromHtml("Black");
aGrid.ShowGroupPanel = false;
// Set Client Settings
aGrid.ClientSettings.AllowDragToGroup = false;
aGrid.ClientSettings.AllowColumnsReorder = false;
aGrid.ClientSettings.EnableRowHoverStyle = true;
aGrid.ClientSettings.EnableAlternatingItems = false;
aGrid.ClientSettings.AllowKeyboardNavigation = true;
aGrid.ClientSettings.Selecting.AllowRowSelect = true;
aGrid.ClientSettings.Scrolling.AllowScroll = true;
aGrid.ClientSettings.Scrolling.UseStaticHeaders = true;
aGrid.ClientSettings.Scrolling.EnableVirtualScrollPaging = false;
aGrid.ClientSettings.Resizing.AllowColumnResize = true;
}
protected void btnDetails_OnClick(object sender, EventArgs e)
{
int count = gvOrderBook.MasterTableView.Items.Count;
DataTable dtIssueDetail;
Button btnDetails = (Button)sender;
GridDataItem gdi;
DataTable filldt = new DataTable();
gdi = (GridDataItem)btnDetails.NamingContainer;
int orderId = int.Parse(gvOrderBook.MasterTableView.DataKeyValues[gdi.ItemIndex]["CO_OrderId"].ToString());
RadGrid gvChildDetails = (RadGrid)gdi.FindControl("gvChildDetails");
//Panel PnlChild = (Panel)gdi.FindControl("pnlchild");
if (gvChildDetails.Visible == false)
{
gvChildDetails.Visible = true;
//btnDetails.Text = "-";
}
else if (gvChildDetails.Visible == true)
{
gvChildDetails.Visible = false;
//buttonlink.Text = "+";
}
DataTable dtNCDOrderBook = (DataTable)Cache["OrderTransactionBook" + userVo.UserId.ToString()];
DataRow[] rows = dtNCDOrderBook.Select("CO_OrderId = " + orderId + " ");
if (rows.Length > 0)
{
filldt = rows.CopyToDataTable();
}
gvChildDetails.DataSource = filldt;
gvChildDetails.DataBind();
}
protected void GetStudentEnrollments(RadGrid rdExams, string strCouseId, string providerId)
{
BEAdmin objBEAdmin = new BEAdmin();
objBEAdmin.IntCourseID = Convert.ToInt32(strCouseId);
objBEAdmin.IntProviderID = Convert.ToInt32(providerId);
new BAdmin().BGetCourseStudents(objBEAdmin);
rdExams.DataSource = objBEAdmin.DtResult;
rdExams.Rebind();
//if (Status == "Inactive")
// rdExams.Columns[3].Visible = false;
// rdExams.Rebind();
foreach (GridColumn column in rdExams.MasterTableView.OwnerGrid.Columns)
{
column.CurrentFilterFunction = GridKnownFunction.NoFilter;
column.CurrentFilterValue = string.Empty;
}
rdExams.MasterTableView.FilterExpression = string.Empty;
objBEAdmin = null;
if (!IsPostBack)
{
this.Page.Title = EnumPageTitles.APPNAME + EnumPageTitles.HOME;
((LinkButton)this.Page.Master.FindControl("lnkHome")).CssClass = "main_menu_active";
}
}
public static void BuildGridHyperLinkColumn(BasePage page, RadGrid Grid, Grid GridObject, HyperLinkGridColumn Column, string ResourceKeyPrefix)
{
GridHyperLinkColumn col = new GridHyperLinkColumn();
string HeaderText = Common.CoalesceStr(col.HeaderText, Column.HeaderText);
string DataTextFormatString = Common.CoalesceStr(col.DataTextFormatString, Column.DataTextFormatString);
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.DataNavigateUrlFields = Common.CoalesceDelimArr(col.DataNavigateUrlFields, Column.DataNavigateUrlFields, ',');
string urlFormatString = Common.CreateUrlWithQueryStringContext(Column.DataNavigateUrlFormatString, Column.Context);
col.DataNavigateUrlFormatString = Common.CoalesceStr(col.DataNavigateUrlFormatString, urlFormatString);
col.DataTextField = Common.CoalesceStr(col.DataTextField, Column.DataTextField);
col.DataTextFormatString = GetGlobalResourceString(page, Column, ResourceKeyPrefix, "DataTextFormatString", DataTextFormatString);
col.Text = GetGlobalResourceString(page, Column, ResourceKeyPrefix, "Text", Text);
if (!String.IsNullOrEmpty(Column.Target))
{
col.Target = Column.Target;
}
FormatStyle(col, Column);
Grid.MasterTableView.Columns.Add(col);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["Id"] != null)
{
int InvoiceId = 0;
var cDormitoryStudent = new CDormitoryRegistrations();
InvoiceId = cDormitoryStudent.GetInvoiceIdbyDormitoryStudentId(Convert.ToInt32(Request["Id"]));
// Payment
_linqDataSourcePaymentHistory = PaymentHistoryGrid1.GetLinqDataSourcePaymentHistory();
_radGridPaymentHistory = PaymentHistoryGrid1.GetRadGridPaymentHistory();
_linqDataSourcePaymentHistory.WhereParameters.Clear();
_linqDataSourcePaymentHistory.WhereParameters.Add("InvoiceId", DbType.Int32, InvoiceId.ToString());
//_linqDataSourcePaymentHistory.WhereParameters.Add("InvoiceId", DbType.Int32, "26367");
_linqDataSourcePaymentHistory.Where = "InvoiceId == @InvoiceId";
//Invoice Item
_sqlDataSourceInvoiceItems = InvoiceItemGrid1.GetSqlDataSourceInvoiceItems();
_radGridInvoiceItems = InvoiceItemGrid1.GetRadGridInvoiceItems();
// connect event of invoice Items.
InvoiceItemGrid1.SetEditMode(false);
_sqlDataSourceInvoiceItems.WhereParameters.Clear();
_sqlDataSourceInvoiceItems.WhereParameters.Add("InvoiceId", DbType.Int32, InvoiceId.ToString());
//_sqlDataSourceInvoiceItems.WhereParameters.Add("InvoiceId", DbType.Int32, "26367");
_sqlDataSourceInvoiceItems.Where = "InvoiceId == @InvoiceId";
}
}
public static void ExcuteFilter(RadGrid MyGrid)
{
GridFilterMenu menu = MyGrid.FilterMenu;
if (menu.Items.Count > 3)
{
int im = 0;
while (im < menu.Items.Count)
{
if (menu.Items[im].Text == "NoFilter" || menu.Items[im].Text == "Contains" || menu.Items[im].Text == "EqualTo")
{
im++;
}
else
{
menu.Items.RemoveAt(im);
}
}
foreach (RadMenuItem item in menu.Items)
{ //change the text for the "StartsWith" menu item
if (item.Text == "NoFilter")
{
item.Text = "حذف فیلتر";
}
if (item.Text == "Contains")
{
item.Text = "شامل";
}
if (item.Text == "EqualTo")
{
item.Text = "مساوی با";
}
}
}
}
protected void btnExpandAll_Click(object sender, EventArgs e)
{
int strIssuerId = 0;
LinkButton buttonlink = (LinkButton)sender;
GridDataItem gdi;
gdi = (GridDataItem)buttonlink.NamingContainer;
strIssuerId = int.Parse(gvIPOOrderBook.MasterTableView.DataKeyValues[gdi.ItemIndex]["AIM_IssueId"].ToString());
int orderId = int.Parse(gvIPOOrderBook.MasterTableView.DataKeyValues[gdi.ItemIndex]["CO_OrderId"].ToString());
RadGrid gvIPODetails = (RadGrid)gdi.FindControl("gvIPODetails");
Panel PnlChild = (Panel)gdi.FindControl("pnlchild");
if (PnlChild.Visible == false)
{
PnlChild.Visible = true;
buttonlink.Text = "-";
}
else if (PnlChild.Visible == true)
{
PnlChild.Visible = false;
buttonlink.Text = "+";
}
DataTable dtIPOOrderBook = OnlineIPOBackOfficeBo.GetAdviserIPOOrderSubBook(advisorVo.advisorId, strIssuerId, orderId);
gvIPODetails.DataSource = dtIPOOrderBook;
gvIPODetails.DataBind();
}
private void AddGrid()
{
RadGrid1 = new RadGrid();
RadGrid1.ID = InstanceType;
int pageSize = WebContext.Current.ApplicationOption.GridPageSize;
if (GridPageSize.HasValue)
{
pageSize = GridPageSize.Value;
}
RadGridHelper.SetStyle(RadGrid1, pageSize);
RadGrid1.MasterTableView.AllowFilteringByColumn = AllowFilteringByColumn;
if (IsGridInFormEdit)
{
RadGrid1.MasterTableView.EditMode = GridEditMode.EditForms;
RadGrid1.MasterTableView.EditFormSettings.ColumnNumber = WebContext.Current.ApplicationOption.EditFormColumnMax;
}
RadGrid1.NeedDataSource += new GridNeedDataSourceEventHandler(RadGrid1_NeedDataSource);
RadGrid1.UpdateCommand += new GridCommandEventHandler(RadGrid1_UpdateCommand);
RadGrid1.InsertCommand += new GridCommandEventHandler(RadGrid1_InsertCommand);
RadGrid1.ItemDataBound += new GridItemEventHandler(RadGrid1_ItemDataBound);
RadGrid1.DeleteCommand += new GridCommandEventHandler(RadGrid1_DeleteCommand);
RadGrid1.ItemCommand += new GridCommandEventHandler(RadGrid1_ItemCommand);
RadGrid1.PreRender += new EventHandler(RadGrid1_PreRender);
DefineColumns();
PlaceHolder1.Controls.Add(RadGrid1);
}
public void LoadResults(
DataTable dataSource,
Panel panel,
HtmlGenericControl div,
Panel tileResultsPanel,
Panel gridResultsPanel,
RadGrid grid,
string resultType,
string contentTemplate)
{
if (resultType == "Grid")
{
grid.DataSource = dataSource;
grid.DataBind();
tileResultsPanel.Visible = false;
gridResultsPanel.Visible = true;
}
else
{
var resultsControl = new Controls.DynamicTileContainer(4, 113, 525, false);
resultsControl.DataSource = null;
resultsControl.ContentTileTemplate = contentTemplate;
resultsControl.DataSource = dataSource;
resultsControl.DataBind();
tileResultsPanel.Visible = true;
gridResultsPanel.Visible = false;
div.Controls.Clear();
div.Controls.Add(resultsControl);
AddNavigationButtons(panel, div);
}
}
// LOAD DATASOURCE
public void Load_DataSource_RadGrid(RadGrid _radgrid, int _nhanvienID)
{
EmployeeManagementEntities db = new EmployeeManagementEntities();
IEnumerable <Models.QuaTrinhDaoTao> qtdts = db.QuaTrinhDaoTaos.Where(x => x.NVID == _nhanvienID).OrderBy(x => x.QTDTTuNgay);
_radgrid.DataSource = qtdts.ToList();
}
public static void BuildBinaryImageGridColumn(BasePage page, RadGrid Grid, Grid GridObject, BinaryImageGridColumn Column, string ResourceKeyPrefix)
{
GridBinaryImageColumn col = new GridBinaryImageColumn();
string HeaderText = Common.CoalesceStr(col.HeaderText, Column.HeaderText);
string DataAlternateTextFormatString = Common.CoalesceStr(col.DataAlternateTextFormatString, Column.DataAlternateTextFormatString);
col.HeaderText = GetGlobalResourceString(page, Column, ResourceKeyPrefix, "HeaderText", HeaderText);
col.SortExpression = Common.CoalesceStr(col.SortExpression, Column.SortExpression);
col.DataField = Common.CoalesceStr(col.DataField, Column.DataField);
col.UniqueName = Common.CoalesceStr(col.UniqueName, Column.UniqueName);
col.DataAlternateTextField = Common.CoalesceStr(col.DataAlternateTextField, Column.DataAlternateTextField);
col.DataAlternateTextFormatString = GetGlobalResourceString(page, Column, ResourceKeyPrefix, "DataAlternateTextFormatString", DataAlternateTextFormatString);
//string defaultImageUrl = String.IsNullOrEmpty(col.DefaultImageUrlFormat) ? col.DefaultImageUrl;
col.DefaultImageUrl = Common.CoalesceStr(col.DefaultImageUrl, Column.DefaultImageUrl);
if (!String.IsNullOrEmpty(Column.ImageHeight))
{
col.ImageHeight = new Unit(Column.ImageHeight);
}
if (!String.IsNullOrEmpty(Column.ImageWidth))
{
col.ImageWidth = new Unit(Column.ImageWidth);
}
col.ImageAlign = Column.ImageAlign;
col.ResizeMode = (Telerik.Web.UI.BinaryImageResizeMode)Enum.Parse(typeof(Telerik.Web.UI.BinaryImageResizeMode), Column.ResizeMode.ToString());
FormatStyle(col, Column);
Grid.MasterTableView.Columns.Add(col);
}
//protected void Page_PreRenderComplete(object sender, EventArgs e)
//{
// if (!IsPostBack)
// {
// GridNestedViewItem firstLevelNestedViewItem = (GridNestedViewItem)gvHeaderMapping.MasterTableView.GetItems(GridItemType.NestedView)[0];
// GridNestedViewItem secondLevelNestedViewItem = (GridNestedViewItem)firstLevelNestedViewItem.NestedTableViews[0].GetItems(GridItemType.NestedView)[0];
// GridItem itemToExpand = secondLevelNestedViewItem.NestedTableViews[0].GetItems(GridItemType.Item)[0];
// itemToExpand.ExpandHierarchyToTop();
// }
//}
protected void gvHeaderMapping_ItemCommand(object source, GridCommandEventArgs e)
{
DataTable dt = (DataTable)Cache["HeaderMapping" + userVo.UserId.ToString()];
string ecommand = null;
if (e.CommandName == "PerformInsert")
{
ecommand = "IN";
GridEditableItem gridEditableItem = (GridEditableItem)e.Item;
RadGrid gvHeaderMapping = (RadGrid)e.Item.FindControl("gvHeaderMapping");
DropDownList ddlXMLHeaderName = (DropDownList)e.Item.FindControl("ddlXMLHeaderName");
int XMLHeaderId = Convert.ToInt32(ddlXMLHeaderName.SelectedValue);
TextBox txtExHeader = (TextBox)e.Item.FindControl("txtExHeader");
if (dt.Select("WEHXHM_ExternalHeaderName='" + txtExHeader.Text + "'").LongLength > 0)
{
Response.Write(@"<script language='javascript'>alert('External Header " + txtExHeader.Text + " Exist');</script>");
}
else
{
OfflineIPOBackOfficeBo.CreateUpdateExternalHeader(txtExHeader.Text.TrimEnd(), XMLHeaderId, ddlRTA.SelectedValue, ecommand, "", 0);
Response.Write(@"<script language='javascript'>alert('External Header " + txtExHeader.Text + " Added successfully');</script>");
}
}
if (e.CommandName == RadGrid.UpdateCommandName)
{
ecommand = "UP";
GridEditableItem gridEditableItem = (GridEditableItem)e.Item;
//RadGrid gvHeaderMapping = (RadGrid)e.Item.FindControl("gvHeaderMapping");
DropDownList ddlXMLHeaderName = (DropDownList)e.Item.FindControl("ddlXMLHeaderName");
int XMLHeaderId = Convert.ToInt32(ddlXMLHeaderName.SelectedValue);
TextBox txtExHeader = (TextBox)e.Item.FindControl("txtExHeader");
int externalHeaderId = Convert.ToInt32(gvHeaderMapping.MasterTableView.DataKeyValues[e.Item.ItemIndex]["WEHXHM_Id"].ToString());
string externalHeaderName = gvHeaderMapping.MasterTableView.DataKeyValues[e.Item.ItemIndex]["WEHXHM_ExternalHeaderName"].ToString();
if (dt.Select("WEHXHM_ExternalHeaderName='" + txtExHeader.Text + "'").LongLength > 0 && txtExHeader.Text.TrimEnd() != externalHeaderName)
{
Response.Write(@"<script language='javascript'>alert('External Header " + txtExHeader.Text + " Exist');</script>");
}
else
{
OfflineIPOBackOfficeBo.CreateUpdateExternalHeader(txtExHeader.Text.TrimEnd(), XMLHeaderId, ddlRTA.SelectedValue, ecommand, hdnPrevEHName.Value, externalHeaderId);
Response.Write(@"<script language='javascript'>alert('External Header " + txtExHeader.Text + "Updated successfully');</script>");
}
}
if (e.CommandName == RadGrid.DeleteCommandName)
{
ecommand = "DLT";
GridDataItem dataItem = (GridDataItem)e.Item;
TableCell headerId = dataItem["WUXHM_XMLHeaderId"];
TableCell externalHeader = dataItem["WEHXHM_ExternalHeaderName"];
GridEditableItem gridEditableItem = (GridEditableItem)e.Item;
int XMLHeaderId = int.Parse(headerId.Text);
string txtExHeader = externalHeader.Text;
int externalHeaderId = Convert.ToInt32(gvHeaderMapping.MasterTableView.DataKeyValues[e.Item.ItemIndex]["WEHXHM_Id"].ToString());
OfflineIPOBackOfficeBo.CreateUpdateExternalHeader(txtExHeader.ToString().TrimEnd(), XMLHeaderId, ddlRTA.SelectedValue, ecommand, hdnPrevEHName.Value, externalHeaderId);
Response.Write(@"<script language='javascript'>alert('External Header " + txtExHeader + "Deleted successfully');</script>");
}
BindHeaderMapping();
}
// to remember the contacts selection while paging
public void rememberCampaignsSelection(string checkboxid, string lblCampaignID, RadGrid Rgrid, string hdrchkbox)
{
try
{
CampaignsSelected = new ArrayList();
//Maintain contacts already selected in previous page index.
if (ViewState["SelectedContacts"] != null)
{
ArrayList contactsAlreadySelected = (ArrayList)ViewState["SelectedContacts"];
if (contactsAlreadySelected.Count > 0)
{
foreach (string contact in contactsAlreadySelected)
{
if (!CampaignsSelected.Contains(contact))
{
CampaignsSelected.Add(contact);
}
}
}
}
//for header checkbox
int pageind = Rgrid.CurrentPageIndex;
//maintain contacts selected in current page index.
foreach (GridDataItem row in Rgrid.MasterTableView.Items)
{
//if (row.RowType = DataControlRowType.DataRow)
//{
CheckBox objCheckBox = (CheckBox)row.FindControl(checkboxid);
Label ContactID = (Label)row.FindControl(lblCampaignID);
if (objCheckBox.Checked == true)
{
if (!CampaignsSelected.Contains(ContactID.Text))
{
CampaignsSelected.Add(ContactID.Text);
}
}
else
{
ViewState["SelectedContacts"] = null;
if (CampaignsSelected.Contains(ContactID.Text))
{
CampaignsSelected.Remove(ContactID.Text);
}
}
}
if (CampaignsSelected != null && CampaignsSelected.Count > 0)
{
ViewState["SelectedContacts"] = CampaignsSelected;
}
}
catch (Exception ex)
{
}
}
public static void formatarGrid(RadGrid grid)
{
grid.PagerStyle.PagerTextFormat = "Mudar página: {4} Exibindo página {0} de {1}, itens {2} até {3} de {5}.";
grid.PagerStyle.NextPagesToolTip = "Próximas paginas";
grid.PagerStyle.NextPageToolTip = "Próxima pagina";
grid.PagerStyle.PrevPagesToolTip = "Páginas anteriores";
grid.PagerStyle.PrevPageToolTip = "Página anterior";
grid.PagerStyle.NextPageText = "Próxima";
grid.PagerStyle.PrevPageText = "Anterior";
grid.SortingSettings.SortToolTip = "Clique aqui para organizar";
grid.MasterTableView.NoMasterRecordsText = "Nenhum registro encontrado.";
grid.PagerStyle.Mode = GridPagerMode.NextPrevAndNumeric;
}
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);
}
}
/// <summary>
/// Generate xml format data from grid.
/// </summary>
/// <param name="grid">Rad grid control which data to be converted into xml format.</param>
/// <returns>Returns xml format data in string.</returns>
private String GenerateXmlString(RadGrid grid)
{
string xmlRootStart = "<{0}>";
string xmlRootEnd = "</{0}>";
string xmlHeaderRootValue = "Node";
string xmlHeaderNodeStructure = "<Region REGION_ID=\"{0}\" REGION_SHORT_NAME=\"{1}\" REGION_LONG_NAME=\"{2}\" USER_ID=\"{3}\"></Region>";
StringBuilder xmlString = new StringBuilder();
try
{
if (ViewState[PageConstants.vsItemIndexes] != null)
{
htItemIndex = (Hashtable)(ViewState[PageConstants.vsItemIndexes]);
}
if (htItemIndex != null && htItemIndex.Count > 0)
{
int RegionId = 0;
xmlString.AppendFormat(xmlRootStart, xmlHeaderRootValue);
for (int i = 0; i < htItemIndex.Count; i++)
{
Label lblgrdRegionId = (Label)grid.Items[Convert.ToInt32(htItemIndex[i])].FindControl("lblgrdRegionIdEdit");
TextBox txtgrdRegionShortName = (TextBox)grid.Items[Convert.ToInt32(htItemIndex[i])].FindControl("txtgrdRegionShortName");
TextBox txtgrdRegionLongName = (TextBox)grid.Items[Convert.ToInt32(htItemIndex[i])].FindControl("txtgrdRegionLongName");
RegionId = int.Parse(lblgrdRegionId.Text);
xmlString.AppendFormat(xmlHeaderNodeStructure, RegionId, txtgrdRegionShortName.Text, txtgrdRegionLongName.Text, objAuthorizationBDto.UserProfile.UserId);
}
xmlString.AppendFormat(xmlRootEnd, xmlHeaderRootValue);
}
}
catch (Exception ex) { }
return xmlString.ToString();
}
public static bool IsGridDataItemChanged(GridDataItem i,RadGrid grid)
{
bool returnValue = false;
foreach (GridColumn c in grid.Columns)
{
string strNewValue = "";
RadTextBox txtNewValue = i[c.UniqueName].Controls[1] as RadTextBox;
if (txtNewValue == null)
{
CodeList clNewValue = i[c.UniqueName].Controls[1] as CodeList;
if (clNewValue == null) continue;
strNewValue = clNewValue.CODE;
}
else
{
strNewValue = txtNewValue.Text;
}
object objOldValue = i.SavedOldValues[c.UniqueName];
if (objOldValue == null)
{
//và ko có sửa gì
if (string.IsNullOrEmpty(strNewValue))
{
continue;//thì tiếp tục
}
else//có sự thay đổi
{
returnValue = true;
break;
}
}
if (objOldValue.Equals(strNewValue)) continue;
returnValue = true;
break;
}
return returnValue;
}
private void updateSpecialPOPsData(RadGrid VARrdg_SpecPOPs)
{
foreach (GridDataItem item in VARrdg_SpecPOPs.Items)
{
SqlDS_SpecPop.UpdateParameters.Clear();
SqlDS_SpecPop.UpdateParameters.Add("p_key_acct_spec_population_id", item["key_acct_spec_population_id"].Text);
SqlDS_SpecPop.UpdateParameters.Add("p_nbr_students_numerator", ((RadNumericTextBox)item["nbr_students_numerator"].FindControl("nbr_students_numeratorTextBox")).Text);
SqlDS_SpecPop.UpdateParameters.Add("p_nbr_student_denominator", ((RadNumericTextBox)item["nbr_student_denominator"].FindControl("nbr_student_denominatorTextBox")).Text);
SqlDS_SpecPop.UpdateParameters.Add("p_txt_updated_by", HttpContext.Current.User.Identity.Name.ToString());
SqlDS_SpecPop.Update();
}
}
private List<object> GetCheckedItemsFromGrid(RadGrid grid)
{
List<object> lstItems = new List<object>();
switch (currMode)
{
case TabTypes.PricingModuleStatus:
foreach (GridDataItem gdi in grid.Items)
{
if (((CheckBox)gdi["Active"].Controls[0]).Checked)
{
lstItems.Add(gdi["Id"].Text);
}
}
break;
default:
foreach (GridDataItem gdi in grid.Items)
{
if (((CheckBox)gdi["Enabled"].Controls[0]).Checked)
{
lstItems.Add(gdi["IDLabel"].Text);
}
}
break;
}
return lstItems;
}
private void PrintGridToPDF(RadGrid grid)
{
grid.ExportSettings.OpenInNewWindow = true;
foreach (GridDataItem item in grid.MasterTableView.Items)
{
CheckBox chkEnabled;
GridColumn column;
switch (currMode)
{
case TabTypes.PricingModuleStatus:
chkEnabled = (CheckBox)item["Active"].Controls[0];
column = grid.MasterTableView.GetColumn("Active");
break;
default:
chkEnabled = (CheckBox)item["Enabled"].Controls[0];
column = grid.MasterTableView.GetColumn("Enabled");
break;
}
item.Visible = chkEnabled.Checked == true ? true : false;
column.Visible = false;
}
grid.MasterTableView.ExportToPdf();
}
protected void HideUncheckedItems(RadGrid grid)
{
bool checkedAll = false;
bool anyItemIsChecked = false;
CheckBox allCheckbx = new CheckBox();
GridDataItem allItem = new GridDataItem(new GridTableView(grid), 0, 0 );
foreach (GridDataItem item in grid.Items)
{
CheckBox checkbx = (CheckBox)item.FindControl("checked");
if (item["category"].Text == "All" && checkbx.Checked)
{
checkedAll = true;
allCheckbx = checkbx;
allItem = item;
anyItemIsChecked = true;
break;
}
}
foreach (GridDataItem item in grid.Items)
{
CheckBox checkbx = (CheckBox)item.FindControl("checked");
checkbx.Checked = checkedAll ? false : checkbx.Checked;
if (checkbx.Checked) anyItemIsChecked = true;
item.Display = checkbx.Checked; //hide the row
item.Enabled = true;
}
if (checkedAll)
{
allCheckbx.Checked = true;
allItem.Display = true;
}
if(!anyItemIsChecked)
{
grid.DataSource = "";
grid.DataBind();
}
}
protected void EditCheckedItems(RadGrid grid)
{
if (grid.MasterTableView.OwnerGrid.Items.Count < 1)
{
grid.Rebind();
return;
}
ArrayList items = new ArrayList();
foreach (GridDataItem item in grid.Items)
{
CheckBox checkbx = (CheckBox)item.FindControl("checked");
items.Add(checkbx.Checked ? 1 : 0);
}
grid.Rebind();
for (int i = 0; i < grid.Items.Count; i++)
{
CheckBox checkbx = (CheckBox)grid.Items[i].FindControl("checked");
checkbx.Checked = ((int)items[i] == 1);
grid.Items[i].Display = true;
}
}
protected void setEmptyDataSet(RadGrid grid, bool isNotNeedEvent=false)
{
DataClasses1DataContext dbContext = new DataClasses1DataContext();
DataTable t = new DataTable();
string myQuery = "select 'Keine Datensätze vorhanden' as Info";
using (SqlConnection c = new SqlConnection(dbContext.Connection.ConnectionString))
{
c.Open();
using (SqlDataAdapter a = new SqlDataAdapter(myQuery, c))
{
a.Fill(t);
}
}
grid.DataSource = t;
if (isNotNeedEvent)
grid.DataBind();
}
protected void BindDataToGrid(DataTable dt, RadGrid rg)
{
rg.DataSource = dt;
rg.DataBind();
}
public DataTable GetDataTableFromItems(RadGrid grid)
{
DataTable dt = new DataTable();
foreach (GridColumn col in grid.Columns)
{
DataColumn colString = new DataColumn(col.UniqueName);
dt.Columns.Add(colString);
}
foreach (GridDataItem row in grid.Items) // loops through each rows in RadGrid
{
DataRow dr = dt.NewRow();
foreach (GridColumn col in grid.Columns) //loops through each column in RadGrid
{
if (col.ColumnType == "GridTemplateColumn")
{
//GridTemplateColumn
if (row[col.UniqueName].Controls[1].GetType().Name == "RadTextBox")
{
dr[col.UniqueName] = (row[col.UniqueName].Controls[1] as RadTextBox).Text;
}
}
else if (col.ColumnType == "GridBoundColumn")
{
//GridBoundColumn
dr[col.UniqueName] = row[col.UniqueName].Text;
}
}
dt.Rows.Add(dr);
}
return dt;
}
public void rememberContactSelection(string checkboxid, string lblContactId, RadGrid grid, string hdrchkbox)
{
try
{
contactsSelected = new ArrayList();
//Maintain contacts already selected in previous page index.
if (Session["SelectedContacts"] != null)
{
ArrayList contactsAlreadySelected = (ArrayList)Session["SelectedContacts"];
if (contactsAlreadySelected.Count > 0)
{
foreach (string contact in contactsAlreadySelected)
{
if (!contactsSelected.Contains(contact))
{
contactsSelected.Add(contact);
}
}
}
}
//for header checkbox
int pageind = grid.CurrentPageIndex;
//maintain contacts selected in current page index.
foreach (GridDataItem row in grid.MasterTableView.Items)
{
CheckBox objCheckBox = (CheckBox)row.FindControl(checkboxid);
Label ContactID = (Label)row.FindControl(lblContactId);
if (objCheckBox.Checked == true)
{
if (!contactsSelected.Contains(ContactID.Text))
{
contactsSelected.Add(ContactID.Text);
}
}
else
{
Session["SelectedContacts"] = null;
if (contactsSelected.Contains(ContactID.Text))
{
contactsSelected.Remove(ContactID.Text);
}
}
}
if (contactsSelected != null && contactsSelected.Count > 0)
{
Session["SelectedContacts"] = contactsSelected;
}
}
catch (Exception ex)
{
}
}
public void LoadGrid(RadGrid grd, string SQL, string[] WhereCluseValue, bool binddata = true)
{
AppManager am = new AppManager();
grd.DataSource = am.DataAccess.RecordSet(SQL, WhereCluseValue);
if (binddata)
{
grd.DataBind();
}
}
private void ComputeCouponDatesAndFractionsOld(RadDatePicker txtBoxTradeDate, RadComboBox txtBoxLoanName, RadDatePicker txtBoxSettlementDate,
RadDatePicker txtBoxMaturityDate, RadTextBox txtBoxCouponFrequency, RadTextBox txtNonDiscountedAverageLife, RadGrid grdCalculatedDates, int type, RadTextBox txtNotional, RadTextBox txtMargin, RadTextBox txtCurrency)
{
try
{
int countryID = getCountryForLoan(txtBoxLoanName);
PublicHolidayBLL bll = new PublicHolidayBLL();
List<tblHoliday> publicHolidays = bll.GetPublicHolidays(countryID);
List<CalculatedDates> calculatedList = new List<CalculatedDates>();
DateTime cpnDT;
cpnDT = AddBusinessDays(DateTime.Now, 10);
LoanScheduleBL loanScheduleBL = new LoanScheduleBL();
DataTable dtSchedule = loanScheduleBL.GenerateTable(15, 10, cpnDT, txtBoxCouponFrequency.Text, txtNotional.Text, txtBoxMaturityDate.SelectedDate.Value, cpnDT, Convert.ToDecimal(txtMargin.Text), Convert.ToString(txtCurrency.Text), Convert.ToDateTime(txtBoxTradeDate.SelectedDate.Value), txtBoxSettlementDate.SelectedDate.Value);
DateTime currentCouponDate;
DateTime previousCouponDate;
DateTime maturityDate;
DateTime tradeDate;
DateTime tradeDate1 = DateTime.Now.Date;
if (txtBoxTradeDate.SelectedDate != null)
{
tradeDate1 = txtBoxTradeDate.SelectedDate.Value;
}
//DateTime settlementDate = DateTime.Now.Date;
//if (txtBoxSettlementDate.SelectedDate != null)
//{
// settlementDate = AddBusinessDays(txtBoxSettlementDate.SelectedDate.Value, 10);
//}
DateTime boxMaturityDate = DateTime.Now.Date;
DateTime.TryParse(txtBoxSettlementDate.SelectedDate.Value.ToShortDateString(), out currentCouponDate);
DateTime.TryParse(txtBoxSettlementDate.SelectedDate.Value.ToShortDateString(), out previousCouponDate);
if (txtBoxMaturityDate.SelectedDate != null)
{
boxMaturityDate = txtBoxMaturityDate.SelectedDate.Value;
}
DateTime.TryParse(boxMaturityDate.ToShortDateString(), out maturityDate);
DateTime.TryParse(tradeDate1.ToShortDateString(), out tradeDate);
if (DateTime.TryParse(txtBoxSettlementDate.SelectedDate.Value.ToShortDateString(), out currentCouponDate))
{
int cF = 0;
System.Numeric.Frequency f = new System.Numeric.Frequency();
while (CurrentCouponDateLessThanMaturityDate(currentCouponDate, maturityDate))
{
if (txtBoxCouponFrequency.Text == "Annual")
{
cF = 1;
f = System.Numeric.Frequency.Annual;
}
if (txtBoxCouponFrequency.Text == "Semi-Annual")
{
cF = 2;
f = System.Numeric.Frequency.SemiAnnual;
}
if (txtBoxCouponFrequency.Text == "Quarterly")
{
cF = 4;
f = System.Numeric.Frequency.Quarterly;
}
if (txtBoxCouponFrequency.Text == "Monthly")
{
cF = 12;
}
int numberOfDaysPassed = 0;
// if a weekend date or holiday move forward
//while (IsSaturdaySundayDay(currentCouponDate) || IsPublicHoliday(publicHolidays, currentCouponDate))
//{
// currentCouponDate = currentCouponDate.AddDays(1);
// numberOfDaysPassed = numberOfDaysPassed + 1;
//}
// Compute next coupon date using CoupNCD and correct for weekends
CalculatedDates cal = new CalculatedDates();
System.Numeric.DayCountBasis d = System.Numeric.DayCountBasis.Actual365;
previousCouponDate = currentCouponDate;
currentCouponDate = System.Numeric.Financial.CoupNCD(currentCouponDate, maturityDate, f, d);
DateTime previousBusinessDay = PreviousBusinessDay(currentCouponDate);
cal.CalculatedDate = previousBusinessDay;
//numberOfDaysPassed = currentCouponDate.Subtract(tradeDate).Days; // removed 31-03- 2014 asked by avr
numberOfDaysPassed = currentCouponDate.Subtract(txtBoxSettlementDate.SelectedDate.Value).Days;
//cal.Fraction = String.Format("{0:00.000}", numberOfDaysPassed / 365.25);
cal.Fraction = String.Format("{0:00.00}", numberOfDaysPassed / 365.25);
cal.ActualFraction = numberOfDaysPassed / 365.25;
calculatedList.Add(cal);
}
if (calculatedList != null && calculatedList.Count > 0)
{
// When the cashflow is computed take the average of the fractions and set that to the non discounted average life text box.
// txtNonDiscountedAverageLife.Text =Convert.ToDecimal( calculatedList.Last().ActualFraction).ToString("0.00");
}
grdCalculatedDates.Visible = true;
grdCalculatedDates.DataSource = calculatedList;
grdCalculatedDates.DataBind();
switch (type)
{
case 1:
tempCalculatedList1 = calculatedList;
break;
case 2:
tempCalculatedList2 = calculatedList;
break;
case 3:
tempCalculatedList3 = calculatedList;
break;
default:
break;
}
}
// tempLegend = txtBoxLoanName;
}
catch (Exception)
{
}
}
private void ComputeCouponDatesAndFractions(RadDatePicker txtBoxTradeDate, RadComboBox txtBoxLoanName, RadDatePicker txtBoxSettlementDate,
RadDatePicker txtBoxMaturityDate, RadTextBox txtBoxCouponFrequency, RadTextBox txtNonDiscountedAverageLife, RadGrid grdCalculatedDates, int type, RadTextBox txtNotional, RadTextBox txtMargin, RadTextBox txtCurrency)
{
try
{
int countryID = getCountryForLoan(txtBoxLoanName);
//PublicHolidayBLL bll = new PublicHolidayBLL();
//List<tblHoliday> publicHolidays = bll.GetPublicHolidays(countryID);
List<CalculatedDates> calculatedList = new List<CalculatedDates>();
DateTime cpnDT;
cpnDT = AddBusinessDays(DateTime.Now, 10);
LoanScheduleBL loanScheduleBL = new LoanScheduleBL();
DataTable dtSchedule = loanScheduleBL.GenerateTable(15, 10, cpnDT, txtBoxCouponFrequency.Text, txtNotional.Text, txtBoxMaturityDate.SelectedDate.Value, cpnDT, Convert.ToDecimal(txtMargin.Text), Convert.ToString(txtCurrency.Text), Convert.ToDateTime(txtBoxTradeDate.SelectedDate.Value), txtBoxSettlementDate.SelectedDate.Value);
if (dtSchedule.Rows.Count > 0)
{
LoansBLL loanBL = new LoansBLL();
int loanID = loanBL.GetLoanByCode(txtBoxLoanName.Text).ID;
loanScheduleBL.EditSchedule(loanID, dtSchedule);
}
foreach (DataRow dr in dtSchedule.Rows)
{
CalculatedDates cal = new CalculatedDates();
cal.Fraction = dr["CoupFrac"].ToString();
cal.CalculatedDate = Convert.ToDateTime(dr["EndDate"]);
calculatedList.Add(cal);
}
grdCalculatedDates.Visible = true;
grdCalculatedDates.DataSource = calculatedList;
grdCalculatedDates.DataBind();
switch (type)
{
case 1:
tempCalculatedList1 = calculatedList;
break;
case 2:
tempCalculatedList2 = calculatedList;
break;
case 3:
tempCalculatedList3 = calculatedList;
break;
default:
break;
}
}
catch (Exception)
{
}
}
/// <summary>
/// Generate xml format data from grid.
/// </summary>
/// <param name="grid">Rad grid control which data to be converted into xml format.</param>
/// <returns>Returns xml format data in string.</returns>
private String GenerateDeleteXmlString(RadGrid grid)
{
string xmlRootStart = "<{0}>";
string xmlRootEnd = "</{0}>";
string xmlHeaderRootValue = "Node";
string xmlHeaderNodeStructure = "<ContactInfo COMPANY_ID=\"{0}\" SR_NO=\"{1}\"></ContactInfo>";
StringBuilder xmlString = new StringBuilder();
try
{
if (Session[ssnHasTableIndexCnt] != null)
{
htItemIndexCt = (Hashtable)Session[ssnHasTableIndexCnt];
}
if (htItemIndexCt != null && htItemIndexCt.Count > 0)
{
xmlString.AppendFormat(xmlRootStart, xmlHeaderRootValue);
for (int i = 0; i < htItemIndexCt.Count; i++)
{
Label lblCompanyId = (Label)grid.Items[Convert.ToInt32(htItemIndexCt[i])].FindControl("GrdCustCompanyIdEdit");
Label lblSrno = (Label)grid.Items[Convert.ToInt32(htItemIndexCt[i])].FindControl("lblGrdCustIdEdit");
xmlString.AppendFormat(xmlHeaderNodeStructure, lblCompanyId.Text, lblSrno.Text);
}
xmlString.AppendFormat(xmlRootEnd, xmlHeaderRootValue);
}
}
catch (Exception ex) { }
return xmlString.ToString();
}
protected void SetColumns(String level, DataTable dt, RadGrid rg)
{
// Make unused columns invisible.
if (!dt.Columns.Contains("Score"))
rg.Columns.FindByDataField("Score").Visible = false;
if (!dt.Columns.Contains("StudentCount"))
rg.Columns.FindByDataField("StudentCount").Visible = false;
if (!dt.Columns.Contains("%Proficient"))
rg.Columns.FindByDataField("%Proficient").Visible = false;
rg.Columns[0].HeaderText = level;
if (dt.Rows.Count == 1 && String.Compare(dt.Rows[0]["LevelName"].ToString(), level, true) == 0)
rg.Columns[0].HeaderText = "";
}
/// <summary>
/// Generate xml format data from grid.
/// </summary>
/// <param name="grid">Rad grid control which data to be converted into xml format.</param>
/// <returns>Returns xml format data in string.</returns>
private String GenerateXmlString(RadGrid grid)
{
string xmlRootStart = "<{0}>";
string xmlRootEnd = "</{0}>";
string xmlHeaderRootValue = "Node";
string xmlHeaderNodeStructure = "<ContactInfo COMPANY_ID=\"{0}\" SR_NO=\"{1}\" TITLE_ID=\"{2}\" NAME=\"{3}\" EMAIL=\"{4}\" MOBILE=\"{5}\" PHONE=\"{6}\" ></ContactInfo>";
StringBuilder xmlString = new StringBuilder();
try
{
if (Session[ssnHasTableIndexCnt] != null)
{
htItemIndexCt = (Hashtable)Session[ssnHasTableIndexCnt];
}
if (htItemIndexCt != null && htItemIndexCt.Count > 0)
{
xmlString.AppendFormat(xmlRootStart, xmlHeaderRootValue);
for (int i = 0; i < htItemIndexCt.Count; i++)
{
Label lblCompanyId = (Label)grid.Items[Convert.ToInt32(htItemIndexCt[i])].FindControl("GrdCustCompanyIdEdit");
Label lblSrno = (Label)grid.Items[Convert.ToInt32(htItemIndexCt[i])].FindControl("lblGrdCustIdEdit");
RadComboBox radCmbTitleId = (RadComboBox)grid.Items[Convert.ToInt32(htItemIndexCt[i])].FindControl("lblGrdContTitleEdit");
TextBox lblName = (TextBox)grid.Items[Convert.ToInt32(htItemIndexCt[i])].FindControl("lblGrdContNameEdit");
TextBox lblEmail = (TextBox)grid.Items[Convert.ToInt32(htItemIndexCt[i])].FindControl("lblGrdContEmailEdit");
TextBox lblMobile = (TextBox)grid.Items[Convert.ToInt32(htItemIndexCt[i])].FindControl("lblGrdContMobileEdit");
TextBox lblPhone = (TextBox)grid.Items[Convert.ToInt32(htItemIndexCt[i])].FindControl("lblGrdContEmailPhoneEdit");
xmlString.AppendFormat(xmlHeaderNodeStructure, lblCompanyId.Text, lblSrno.Text, radCmbTitleId.SelectedValue, lblName.Text, lblEmail.Text, lblMobile.Text, lblPhone.Text);
}
xmlString.AppendFormat(xmlRootEnd, xmlHeaderRootValue);
}
}
catch (Exception ex) { }
return xmlString.ToString();
}
public void populateInvoiceSelection(string checkboxid, string lblContactId, RadGrid Rgrid, string hdrchkbox)
{
try
{
if (ViewState["SelectedContacts"] != null)
{
ArrayList selectedContacts = (ArrayList)ViewState["SelectedContacts"];
if (selectedContacts.Count > 0)
{
foreach (GridDataItem row in Rgrid.MasterTableView.Items)
{
CheckBox objCheckBox = (CheckBox)row.FindControl(checkboxid);
Label ContactID = (Label)row.FindControl(lblContactId);
if (selectedContacts.Contains(ContactID.Text))
{
objCheckBox.Checked = true;
}
else
{
objCheckBox.Checked = false;
}
}
}
}
}
catch (Exception ex)
{
}
}
protected void ShowAllItems(RadGrid grid)
{
if (grid.DataSource == null)
{
grid.Rebind();
return;
}
foreach (GridDataItem item in grid.Items)
{
CheckBox checkbx = (CheckBox)item.FindControl("checked");
checkbx.Checked = false;
item.Display = true;
item.Enabled = true;
}
}
/// <summary>
/// Generate xml format data from grid.
/// </summary>
/// <param name="grid">Rad grid control which data to be converted into xml format.</param>
/// <returns>Returns xml format data in string.</returns>
private String GenerateXmlStringCity(RadGrid grid)
{
string xmlRootStart = "<{0}>";
string xmlRootEnd = "</{0}>";
string xmlHeaderRootValue = "Node";
string xmlHeaderNodeStructure = "<City CITY_ID=\"{0}\" CITY_NAME=\"{1}\" STATE_ID=\"{2}\" COUNTRY_ID=\"{3}\" USER_ID=\"{4}\"></City>";
StringBuilder xmlString = new StringBuilder();
try
{
if (ViewState[PageConstants.vsItemIndexes] != null)
{
htItemIndex = (Hashtable)(ViewState[PageConstants.vsItemIndexes]);
}
if (htItemIndex != null && htItemIndex.Count > 0)
{
int CityId = 0;
xmlString.AppendFormat(xmlRootStart, xmlHeaderRootValue);
for (int i = 0; i < htItemIndex.Count; i++)
{
Label lblgrdCityId = (Label)grid.Items[Convert.ToInt32(htItemIndex[i])].FindControl("lblGrdCityIdEdit");
TextBox txtgrdCityName = (TextBox)grid.Items[Convert.ToInt32(htItemIndex[i])].FindControl("txtGrdCityName");
RadComboBox cmbGrdStateName = (RadComboBox)grid.Items[Convert.ToInt32(htItemIndex[i])].FindControl("cmbGrdStateName");
RadComboBox cmbGrdCountryName = (RadComboBox)grid.Items[Convert.ToInt32(htItemIndex[i])].FindControl("cmbGrdCountryName");
CityId = int.Parse(lblgrdCityId.Text);
xmlString.AppendFormat(xmlHeaderNodeStructure, CityId, txtgrdCityName.Text, cmbGrdStateName.SelectedValue, cmbGrdCountryName.SelectedValue, objAuthorizationBDto.UserProfile.UserId);
}
xmlString.AppendFormat(xmlRootEnd, xmlHeaderRootValue);
}
}
catch (Exception ex) { }
return xmlString.ToString();
}
/// <summary>
/// Generate xml format data from grid.
/// </summary>
/// <param name="grid">Rad grid control which data to be converted into xml format.</param>
/// <returns>Returns xml format data in string.</returns>
private String GenerateXmlString(RadGrid grid)
{
string xmlRootStart = "<{0}>";
string xmlRootEnd = "</{0}>";
string xmlHeaderRootValue = "Node";
string xmlHeaderNodeStructure = "<Agent AGENT_ID=\"{0}\" AGENT_NAME=\"{1}\" EMAIL=\"{2}\" MOBILE=\"{3}\" PHONE=\"{4}\" FAX=\"{5}\" USER_ID=\"{6}\"></Agent>";
StringBuilder xmlString = new StringBuilder();
try
{
if (ViewState[PageConstants.vsItemIndexes] != null)
{
htItemIndex = (Hashtable)(ViewState[PageConstants.vsItemIndexes]);
}
if (htItemIndex != null && htItemIndex.Count > 0)
{
int AgentId = 0;
xmlString.AppendFormat(xmlRootStart, xmlHeaderRootValue);
for (int i = 0; i < htItemIndex.Count; i++)
{
Label lblgrdAgentId = (Label)grid.Items[Convert.ToInt32(htItemIndex[i])].FindControl("lblgrdAgentIdEdit");
TextBox txtgrdAgentName = (TextBox)grid.Items[Convert.ToInt32(htItemIndex[i])].FindControl("txtgrdAgentName");
TextBox txtgrdEmail = (TextBox)grid.Items[Convert.ToInt32(htItemIndex[i])].FindControl("txtgrdEmail");
TextBox txtgrdMobile = (TextBox)grid.Items[Convert.ToInt32(htItemIndex[i])].FindControl("txtgrdMobile");
TextBox txtgrdPhone = (TextBox)grid.Items[Convert.ToInt32(htItemIndex[i])].FindControl("txtgrdPhone");
TextBox txtgrdFax = (TextBox)grid.Items[Convert.ToInt32(htItemIndex[i])].FindControl("txtgrdFax");
AgentId = int.Parse(lblgrdAgentId.Text);
xmlString.AppendFormat(xmlHeaderNodeStructure, AgentId, txtgrdAgentName.Text, txtgrdEmail.Text, txtgrdMobile.Text, txtgrdPhone.Text, txtgrdFax.Text, objAuthorizationBDto.UserProfile.UserId);
}
xmlString.AppendFormat(xmlRootEnd, xmlHeaderRootValue);
}
}
catch (Exception ex) { }
return xmlString.ToString();
}
public void LoadGridSettings(string sName, RadGrid oGrid, out string sFilterString)
{
sFilterString = string.Empty;
// Load Sorting Expression
var oIAUserSettingsGrid = DataAccess.IAUserSettingsGrids.SingleOrDefault(row => row.MPUserID == MemberProtect.CurrentUser.UserID && row.Name == sName);
if (oIAUserSettingsGrid != null)
{
if (oIAUserSettingsGrid.SortExpression != string.Empty)
{
oGrid.MasterTableView.SortExpressions.AddSortExpression(oIAUserSettingsGrid.SortExpression);
}
// Load filter string
sFilterString = oIAUserSettingsGrid.Filters;
}
// Load Paging Size
oGrid.PageSize = GetGridPageSize();
}
/// <summary>
/// Generate xml format data from grid.
/// </summary>
/// <param name="grid">Rad grid control which data to be converted into xml format.</param>
/// <returns>Returns xml format data in string.</returns>
private String GenerateXmlString(RadGrid grid)
{
string xmlRootStart = "<{0}>";
string xmlRootEnd = "</{0}>";
string xmlHeaderRootValue = "Node";
string xmlHeaderNodeStructure = "<Customers CUST_ID=\"{0}\" CUST_SURNAME=\"{1}\" CUST_NAME =\"{2}\" CUST_PROFILE = \"{3}\" CUST_COMPANY_NAME = \"{4}\" ></Customers>";
StringBuilder xmlString = new StringBuilder();
try
{
if (ViewState[PageConstants.vsItemIndexes] != null)
{
htItemIndex = (Hashtable)(ViewState[PageConstants.vsItemIndexes]);
}
if (htItemIndex != null && htItemIndex.Count > 0)
{
xmlString.AppendFormat(xmlRootStart, xmlHeaderRootValue);
for (int i = 0; i < htItemIndex.Count; i++)
{
Label lblGrdCustId = (Label)grid.Items[Convert.ToInt32(htItemIndex[i])].FindControl("lblGrdCustIdEdit");
xmlString.AppendFormat(xmlHeaderNodeStructure, lblGrdCustId.Text, txtUserName.Text, txtPassword.Text, int.Parse(ddlEmployeeName.SelectedValue), (ddlSecurityQus.SelectedValue));
}
xmlString.AppendFormat(xmlRootEnd, xmlHeaderRootValue);
}
}
catch (Exception ex) { }
return xmlString.ToString();
}
/// <summary>
/// Generate xml format data from grid.
/// </summary>
/// <param name="grid">Rad grid control which data to be converted into xml format.</param>
/// <returns>Returns xml format data in string.</returns>
private String GenerateXmlString(RadGrid grid)
{
string xmlRootStart = "<{0}>";
string xmlRootEnd = "</{0}>";
string xmlHeaderRootValue = "Node";
string xmlHeaderNodeStructure = "<Status STATUS_ID=\"{0}\" STATUS_NAME=\"{1}\" USER_ID=\"{2}\"></Status>";
StringBuilder xmlString = new StringBuilder();
try
{
if (ViewState[PageConstants.vsItemIndexes] != null)
{
htItemIndex = (Hashtable)(ViewState[PageConstants.vsItemIndexes]);
}
if (htItemIndex != null && htItemIndex.Count > 0)
{
int StatusId = 0;
xmlString.AppendFormat(xmlRootStart, xmlHeaderRootValue);
for (int i = 0; i < htItemIndex.Count; i++)
{
Label lblGrdStatusIdItem = (Label)grid.Items[Convert.ToInt32(htItemIndex[i])].FindControl("lblGrdStatusIdEdit");
TextBox txtstatus = (TextBox)grid.Items[Convert.ToInt32(htItemIndex[i])].FindControl("txtGrdStatusName");
StatusId = int.Parse(lblGrdStatusIdItem.Text);
xmlString.AppendFormat(xmlHeaderNodeStructure, StatusId, txtstatus.Text, objAuthorizationBDto.UserProfile.UserId);
}
xmlString.AppendFormat(xmlRootEnd, xmlHeaderRootValue);
}
}
catch (Exception ex) { }
return xmlString.ToString();
}
