protected
void
ibPreviewMessage_Click(
object
sender, EventArgs e)
{
ImageButton previewMessage = (ImageButton)sender;
ClientScriptManager clientScript = Page.ClientScript;
//string clientScriptName="previewMessage";
Type clientScriptType=
this
.GetType();
int
index = previewMessage.ID.IndexOf(
"_"
), ID;
int
.TryParse(previewMessage.ID.Substring(index + 1),
out
ID);
foreach
(GridDataItem gdi
in
grdMessages.Items)
{
RadTextBox rtb = (RadTextBox)gdi[
"DefaultDescriptionNameColumn"
].FindControl(
"Description_"
+ ID.ToString());
if
(rtb !=
null
)
{
radWindowManager1.OnClientPageLoad =
"OnClientPageLoad('"
+ HttpUtility.HtmlEncode(rtb.Text) +
"')"
;
RadWindow newwindow =
new
RadWindow();
newwindow.ID =
"previewmessages"
;
newwindow.NavigateUrl =
"about:blank"
;
newwindow.VisibleOnPageLoad =
true
;
newwindow.Behaviors = WindowBehaviors.Close;
radWindowManager1.Windows.Add(newwindow);
//if (!clientScript.IsClientScriptBlockRegistered(clientScriptType, clientScriptName))
//{
// StringBuilder sb = new StringBuilder();
// sb.Append("<script type='text/javascript'>");
// sb.Append("radopen('about:blank')");
// sb.Append("document.write(" + HttpUtility.HtmlEncode(rtb.Text) + ")");
// sb.Append("</script>");
// clientScript.RegisterClientScriptBlock(clientScriptType, clientScriptName, sb.ToString());
//}
//RadAjaxManager ajm = RadAjaxManager.GetCurrent(Page);
//if (ajm != null)
//{
// ajm.Alert(HttpUtility.HtmlEncode(rtb.Text)); // make this a radopen or a window.open
//}
}
}
}
<
script
type
=
"text/javascript"
>
function informationWindowLocation(id) {
var oManager = GetRadWindowManager();
var fileName = "Images/" + id;
var examplePath = new Image();
examplePath.src = fileName;
var width = examplePath.width;
var height = examplePath.height;
var oWnd = oManager.GetWindowByName("messages");
if (width > 0 && height > 0) {
oWnd.Show();
oWnd.setSize(width + 100, height + 100);
oWnd.SetUrl(fileName, "messages");
}
else {
radalert("Example doesn't exist for this level and Promotion Type", 425, 150, "Promotion Type Example");
}
return false;
}
function OnClientPageLoad(textDescription) {
var oManager = GetRadWindowManager();
var oWnd = oManager.GetWindowByName("messages");
oWnd.GetContentFrame().contentWindow.document.write('<
html
><
title
>Preview Description</
title
><
body
>' + textDescription + '</
body
></
html
>');
oWnd.Show();
}
</
script
>
<
telerik:RadGrid
ID
=
"grdMessages"
runat
=
"server"
Skin
=
"Vista"
OnItemCreated
=
"grdMessages_ItemCreated"
style
=
"padding-top:20px;"
>
<
ItemStyle
Height
=
"150px"
/>
<
MasterTableView
AutoGenerateColumns
=
"false"
ShowHeader
=
"false"
DataKeyNames
=
"Level"
ClientDataKeyNames
=
"Level"
EnableNoRecordsTemplate
=
"true"
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"Level"
UniqueName
=
"LevelColumn"
Visible
=
"false"
/>
<
telerik:GridTemplateColumn
UniqueName
=
"ShowImage"
DataField
=
"Level_Message_Example"
>
<
ItemTemplate
>
<
asp:ImageButton
ID
=
"ibPreviewLocation"
runat
=
"server"
ImageUrl
=
"~/Images/picture.png"
ImageAlign
=
"Middle"
OnClientClick='<%# String.Format("return informationWindowLocation(\"{0}\");", Eval("Level_Message_Example")) %>' />
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
UniqueName
=
"PreviewMessage"
DataField
=
"Level"
>
<
ItemTemplate
>
<
asp:ImageButton
ID
=
"ibPreviewMessage"
runat
=
"server"
ImageUrl
=
"~/Images/image_magnify.png"
ImageAlign
=
"Middle"
OnClick
=
"ibPreviewMessage_Click"
/>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"Description"
UniqueName
=
"DescriptionColumn"
/>
<
telerik:GridTemplateColumn
DataField
=
"Default_Description"
UniqueName
=
"DefaultDescriptionNameColumn"
>
<
ItemStyle
Width
=
"70%"
Wrap
=
"false"
Height
=
"150px"
/>
<
ItemTemplate
>
<
telerik:RadTextBox
ID
=
"rtbDescription"
Height
=
"150px"
runat
=
"server"
Width
=
"100%"
TextMode
=
"MultiLine"
Text='<%# Eval("Default_Description") %>' />
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
</
Columns
>
<
NoRecordsTemplate
><
asp:Label
ID
=
"lblPromotionEmptyMessage"
runat
=
"server"
Text
=
"No Messages Available for Editing"
/></
NoRecordsTemplate
>
</
MasterTableView
>
</
telerik:RadGrid
>
<
telerik:RadWindowManager
ID
=
"radWindowManager1"
runat
=
"server"
></
telerik:RadWindowManager
>
<
telerik:RadWindowManager
ID
=
"RadWindowManager1"
ShowContentDuringLoad
=
"false"
VisibleStatusbar
=
"false"
ReloadOnShow
=
"true"
runat
=
"server"
Skin
=
"Windows7"
EnableShadow
=
"true"
Behaviors
=
"Close"
>
<
Windows
>
<
telerik:RadWindow
ID
=
"save"
runat
=
"server"
Skin
=
"Windows7"
Height
=
"345px"
Width
=
"475px"
ReloadOnShow
=
"true"
ShowContentDuringLoad
=
"false"
Modal
=
"true"
VisibleTitlebar
=
"false"
/>
<
telerik:RadWindow
ID
=
"products"
Width
=
"320"
Height
=
"275"
runat
=
"server"
Behaviors
=
"Close"
/>
<
telerik:RadWindow
ID
=
"messages"
runat
=
"server"
KeepInScreenBounds
=
"true"
Behaviors
=
"Close"
Width
=
"300"
Height
=
"300"
/>
</
Windows
>
</
telerik:RadWindowManager
>
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Line 347: articleToBeEdited.Body = editorSweBody.Content;
Line 348: articleToBeEdited.Title = tbTitle.Text;
Line 349: articleToBeEdited.TitleFinnish = tbTitleFinnish.Text;
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="UpdateMembers.aspx.cs" Inherits="Commissions.UpdateMembers" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<
html
xmlns
=
"http://www.w3.org/1999/xhtml"
>
<
head
runat
=
"server"
>
<
title
></
title
>
<
link
href
=
"Stylesheet.css"
rel
=
"stylesheet"
type
=
"text/css"
/>
</
head
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
telerik:RadStyleSheetManager
ID
=
"RadStyleSheetManager1"
runat
=
"server"
>
</
telerik:RadStyleSheetManager
>
<
telerik:RadScriptManager
ID
=
"RadScriptManager1"
runat
=
"server"
>
</
telerik:RadScriptManager
>
<
div
>
<
br
/>
Please select an Excel file to import:<
br
/>
<
telerik:RadUpload
ID
=
"RadUpload1"
Runat
=
"server"
AllowedFileExtensions
=
"xls"
ControlObjectsVisibility
=
"None"
>
</
telerik:RadUpload
>
<
br
/>
<
asp:Button
ID
=
"ButtonUploadFile"
runat
=
"server"
Text
=
"Upload File"
onclick
=
"ButtonUploadFile_Click"
CausesValidation
=
"False"
UseSubmitBehavior
=
"False"
/>
<
br
/>
<
asp:Label
ID
=
"LabelUpload"
runat
=
"server"
Text
=
""
></
asp:Label
>
</
div
>
<
asp:SqlDataSource
ID
=
"SqlDataSource1"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:CommissionsEngineConnectionString %>"
SelectCommand="SELECT MemberID, AgencyName, Company, AgencyID, AgentLastName, AgentFirstName, AgentID, ApplicationNo, EligibleForCommission, CommissionableReason, MemberLastName, MemberFirstName, MemberMidInitial, MedicareID, County, CountyCode, State, PlanID, SignedDate, EnrollDate, TransDate, CMSDate, Effdate, ExpireDate, OrigEffDate, MemberStatus, MemberInfo, CommissionType, PaidTo, TotalCommissionAmount, FMOAgencyTotalCommission, AgentTotalCommission, FMOTotalOverrideCommission, TotalPreviouslyPaid, FMOAgencyPreviousPaid, AgentPreviouslyPaid, FMO_OverridePreviousPaid, CurrentPaymentOrCharge, FMOAgencyCurrentPaymentOrCharge, AgentCurrentPaymentOrCharge, FMO_OverrideCurrentPaymentOrCharge, YTD2009ProRata, Current2009ProRata, YTDRetention, CurrentRetention, RAM_Override, FD_Override, ND_Director_Override, Corp_L1_Override, Corp_L2_Override, Corp_L2a_Override, Corp_L2b_Override, Corp_L2c_Override, Corp_L3_Override, AgentDatePaidOrCharged, AgentPaymentRef, AgentVoidDate, AgencyDatePaidOrCharged, AgencyPaymentRef, AgencyVoidDate, FMO_OverrideDatePaidOrCharged, FMO_OverridePaymentRef, FMO_OverrideVoidDate, FMO_OverrideID, CycleYearEnrollDate, PriorPlanType, AutoRollover, IntegrityCheck, YearRun, ManualOverride, Notes, DateEntered, EnteredBy, DateUpdated, UpdatedBy FROM MembersTemp">
</
asp:SqlDataSource
>
<
br
/>
<
asp:Button
ID
=
"Button1"
runat
=
"server"
onclick
=
"Button1_Click"
Text
=
"View Data"
/>
<
br
/>
<
telerik:RadGrid
ID
=
"RadGrid1"
runat
=
"server"
AllowFilteringByColumn
=
"True"
AllowPaging
=
"True"
DataSourceID
=
"SqlDataSource1"
GridLines
=
"None"
Visible
=
"False"
>
<
HeaderContextMenu
EnableImageSprites
=
"True"
CssClass
=
"GridContextMenu GridContextMenu_Default"
></
HeaderContextMenu
>
<
MasterTableView
AutoGenerateColumns
=
"False"
DataKeyNames
=
"MemberID"
DataSourceID
=
"SqlDataSource1"
>
<
CommandItemSettings
ExportToPdfText
=
"Export to Pdf"
></
CommandItemSettings
>
<
RowIndicatorColumn
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
RowIndicatorColumn
>
<
ExpandCollapseColumn
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
ExpandCollapseColumn
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"MemberID"
HeaderText
=
"MemberID"
ReadOnly
=
"True"
SortExpression
=
"MemberID"
UniqueName
=
"MemberID"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"AgencyName"
HeaderText
=
"AgencyName"
SortExpression
=
"AgencyName"
UniqueName
=
"AgencyName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Company"
HeaderText
=
"Company"
SortExpression
=
"Company"
UniqueName
=
"Company"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"AgencyID"
HeaderText
=
"AgencyID"
SortExpression
=
"AgencyID"
UniqueName
=
"AgencyID"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"AgentLastName"
HeaderText
=
"AgentLastName"
SortExpression
=
"AgentLastName"
UniqueName
=
"AgentLastName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"AgentFirstName"
HeaderText
=
"AgentFirstName"
SortExpression
=
"AgentFirstName"
UniqueName
=
"AgentFirstName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"AgentID"
HeaderText
=
"AgentID"
SortExpression
=
"AgentID"
UniqueName
=
"AgentID"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"ApplicationNo"
HeaderText
=
"ApplicationNo"
SortExpression
=
"ApplicationNo"
UniqueName
=
"ApplicationNo"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"EligibleForCommission"
HeaderText
=
"EligibleForCommission"
SortExpression
=
"EligibleForCommission"
UniqueName
=
"EligibleForCommission"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"CommissionableReason"
HeaderText
=
"CommissionableReason"
SortExpression
=
"CommissionableReason"
UniqueName
=
"CommissionableReason"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"MemberLastName"
HeaderText
=
"MemberLastName"
SortExpression
=
"MemberLastName"
UniqueName
=
"MemberLastName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"MemberFirstName"
HeaderText
=
"MemberFirstName"
SortExpression
=
"MemberFirstName"
UniqueName
=
"MemberFirstName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"MemberMidInitial"
HeaderText
=
"MemberMidInitial"
SortExpression
=
"MemberMidInitial"
UniqueName
=
"MemberMidInitial"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"MedicareID"
HeaderText
=
"MedicareID"
SortExpression
=
"MedicareID"
UniqueName
=
"MedicareID"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"County"
HeaderText
=
"County"
SortExpression
=
"County"
UniqueName
=
"County"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"CountyCode"
HeaderText
=
"CountyCode"
SortExpression
=
"CountyCode"
UniqueName
=
"CountyCode"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"State"
HeaderText
=
"State"
SortExpression
=
"State"
UniqueName
=
"State"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"PlanID"
HeaderText
=
"PlanID"
SortExpression
=
"PlanID"
UniqueName
=
"PlanID"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"SignedDate"
DataType
=
"System.DateTime"
HeaderText
=
"SignedDate"
SortExpression
=
"SignedDate"
UniqueName
=
"SignedDate"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"EnrollDate"
DataType
=
"System.DateTime"
HeaderText
=
"EnrollDate"
SortExpression
=
"EnrollDate"
UniqueName
=
"EnrollDate"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"TransDate"
DataType
=
"System.DateTime"
HeaderText
=
"TransDate"
SortExpression
=
"TransDate"
UniqueName
=
"TransDate"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"CMSDate"
DataType
=
"System.DateTime"
HeaderText
=
"CMSDate"
SortExpression
=
"CMSDate"
UniqueName
=
"CMSDate"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Effdate"
DataType
=
"System.DateTime"
HeaderText
=
"Effdate"
SortExpression
=
"Effdate"
UniqueName
=
"Effdate"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"ExpireDate"
DataType
=
"System.DateTime"
HeaderText
=
"ExpireDate"
SortExpression
=
"ExpireDate"
UniqueName
=
"ExpireDate"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"OrigEffDate"
DataType
=
"System.DateTime"
HeaderText
=
"OrigEffDate"
SortExpression
=
"OrigEffDate"
UniqueName
=
"OrigEffDate"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"MemberStatus"
HeaderText
=
"MemberStatus"
SortExpression
=
"MemberStatus"
UniqueName
=
"MemberStatus"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"MemberInfo"
HeaderText
=
"MemberInfo"
SortExpression
=
"MemberInfo"
UniqueName
=
"MemberInfo"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"CommissionType"
HeaderText
=
"CommissionType"
SortExpression
=
"CommissionType"
UniqueName
=
"CommissionType"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"PaidTo"
HeaderText
=
"PaidTo"
SortExpression
=
"PaidTo"
UniqueName
=
"PaidTo"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"TotalCommissionAmount"
DataType
=
"System.Decimal"
HeaderText
=
"TotalCommissionAmount"
SortExpression
=
"TotalCommissionAmount"
UniqueName
=
"TotalCommissionAmount"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"FMOAgencyTotalCommission"
DataType
=
"System.Decimal"
HeaderText
=
"FMOAgencyTotalCommission"
SortExpression
=
"FMOAgencyTotalCommission"
UniqueName
=
"FMOAgencyTotalCommission"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"AgentTotalCommission"
DataType
=
"System.Decimal"
HeaderText
=
"AgentTotalCommission"
SortExpression
=
"AgentTotalCommission"
UniqueName
=
"AgentTotalCommission"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"FMOTotalOverrideCommission"
DataType
=
"System.Decimal"
HeaderText
=
"FMOTotalOverrideCommission"
SortExpression
=
"FMOTotalOverrideCommission"
UniqueName
=
"FMOTotalOverrideCommission"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"TotalPreviouslyPaid"
DataType
=
"System.Decimal"
HeaderText
=
"TotalPreviouslyPaid"
SortExpression
=
"TotalPreviouslyPaid"
UniqueName
=
"TotalPreviouslyPaid"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"FMOAgencyPreviousPaid"
DataType
=
"System.Decimal"
HeaderText
=
"FMOAgencyPreviousPaid"
SortExpression
=
"FMOAgencyPreviousPaid"
UniqueName
=
"FMOAgencyPreviousPaid"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"AgentPreviouslyPaid"
DataType
=
"System.Decimal"
HeaderText
=
"AgentPreviouslyPaid"
SortExpression
=
"AgentPreviouslyPaid"
UniqueName
=
"AgentPreviouslyPaid"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"FMO_OverridePreviousPaid"
DataType
=
"System.Decimal"
HeaderText
=
"FMO_OverridePreviousPaid"
SortExpression
=
"FMO_OverridePreviousPaid"
UniqueName
=
"FMO_OverridePreviousPaid"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"CurrentPaymentOrCharge"
DataType
=
"System.Decimal"
HeaderText
=
"CurrentPaymentOrCharge"
SortExpression
=
"CurrentPaymentOrCharge"
UniqueName
=
"CurrentPaymentOrCharge"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"FMOAgencyCurrentPaymentOrCharge"
DataType
=
"System.Decimal"
HeaderText
=
"FMOAgencyCurrentPaymentOrCharge"
SortExpression
=
"FMOAgencyCurrentPaymentOrCharge"
UniqueName
=
"FMOAgencyCurrentPaymentOrCharge"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"AgentCurrentPaymentOrCharge"
DataType
=
"System.Decimal"
HeaderText
=
"AgentCurrentPaymentOrCharge"
SortExpression
=
"AgentCurrentPaymentOrCharge"
UniqueName
=
"AgentCurrentPaymentOrCharge"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"FMO_OverrideCurrentPaymentOrCharge"
DataType
=
"System.Decimal"
HeaderText
=
"FMO_OverrideCurrentPaymentOrCharge"
SortExpression
=
"FMO_OverrideCurrentPaymentOrCharge"
UniqueName
=
"FMO_OverrideCurrentPaymentOrCharge"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"YTD2009ProRata"
DataType
=
"System.Decimal"
HeaderText
=
"YTD2009ProRata"
SortExpression
=
"YTD2009ProRata"
UniqueName
=
"YTD2009ProRata"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Current2009ProRata"
DataType
=
"System.Decimal"
HeaderText
=
"Current2009ProRata"
SortExpression
=
"Current2009ProRata"
UniqueName
=
"Current2009ProRata"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"YTDRetention"
DataType
=
"System.Decimal"
HeaderText
=
"YTDRetention"
SortExpression
=
"YTDRetention"
UniqueName
=
"YTDRetention"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"CurrentRetention"
DataType
=
"System.Decimal"
HeaderText
=
"CurrentRetention"
SortExpression
=
"CurrentRetention"
UniqueName
=
"CurrentRetention"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"RAM_Override"
DataType
=
"System.Decimal"
HeaderText
=
"RAM_Override"
SortExpression
=
"RAM_Override"
UniqueName
=
"RAM_Override"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"FD_Override"
DataType
=
"System.Decimal"
HeaderText
=
"FD_Override"
SortExpression
=
"FD_Override"
UniqueName
=
"FD_Override"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"ND_Director_Override"
DataType
=
"System.Decimal"
HeaderText
=
"ND_Director_Override"
SortExpression
=
"ND_Director_Override"
UniqueName
=
"ND_Director_Override"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Corp_L1_Override"
DataType
=
"System.Decimal"
HeaderText
=
"Corp_L1_Override"
SortExpression
=
"Corp_L1_Override"
UniqueName
=
"Corp_L1_Override"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Corp_L2_Override"
DataType
=
"System.Decimal"
HeaderText
=
"Corp_L2_Override"
SortExpression
=
"Corp_L2_Override"
UniqueName
=
"Corp_L2_Override"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Corp_L2a_Override"
DataType
=
"System.Decimal"
HeaderText
=
"Corp_L2a_Override"
SortExpression
=
"Corp_L2a_Override"
UniqueName
=
"Corp_L2a_Override"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Corp_L2b_Override"
DataType
=
"System.Decimal"
HeaderText
=
"Corp_L2b_Override"
SortExpression
=
"Corp_L2b_Override"
UniqueName
=
"Corp_L2b_Override"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Corp_L2c_Override"
DataType
=
"System.Decimal"
HeaderText
=
"Corp_L2c_Override"
SortExpression
=
"Corp_L2c_Override"
UniqueName
=
"Corp_L2c_Override"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Corp_L3_Override"
DataType
=
"System.Decimal"
HeaderText
=
"Corp_L3_Override"
SortExpression
=
"Corp_L3_Override"
UniqueName
=
"Corp_L3_Override"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"AgentDatePaidOrCharged"
DataType
=
"System.DateTime"
HeaderText
=
"AgentDatePaidOrCharged"
SortExpression
=
"AgentDatePaidOrCharged"
UniqueName
=
"AgentDatePaidOrCharged"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"AgentPaymentRef"
HeaderText
=
"AgentPaymentRef"
SortExpression
=
"AgentPaymentRef"
UniqueName
=
"AgentPaymentRef"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"AgentVoidDate"
DataType
=
"System.DateTime"
HeaderText
=
"AgentVoidDate"
SortExpression
=
"AgentVoidDate"
UniqueName
=
"AgentVoidDate"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"AgencyDatePaidOrCharged"
DataType
=
"System.DateTime"
HeaderText
=
"AgencyDatePaidOrCharged"
SortExpression
=
"AgencyDatePaidOrCharged"
UniqueName
=
"AgencyDatePaidOrCharged"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"AgencyPaymentRef"
HeaderText
=
"AgencyPaymentRef"
SortExpression
=
"AgencyPaymentRef"
UniqueName
=
"AgencyPaymentRef"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"AgencyVoidDate"
DataType
=
"System.DateTime"
HeaderText
=
"AgencyVoidDate"
SortExpression
=
"AgencyVoidDate"
UniqueName
=
"AgencyVoidDate"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"FMO_OverrideDatePaidOrCharged"
DataType
=
"System.DateTime"
HeaderText
=
"FMO_OverrideDatePaidOrCharged"
SortExpression
=
"FMO_OverrideDatePaidOrCharged"
UniqueName
=
"FMO_OverrideDatePaidOrCharged"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"FMO_OverridePaymentRef"
HeaderText
=
"FMO_OverridePaymentRef"
SortExpression
=
"FMO_OverridePaymentRef"
UniqueName
=
"FMO_OverridePaymentRef"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"FMO_OverrideVoidDate"
DataType
=
"System.DateTime"
HeaderText
=
"FMO_OverrideVoidDate"
SortExpression
=
"FMO_OverrideVoidDate"
UniqueName
=
"FMO_OverrideVoidDate"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"FMO_OverrideID"
HeaderText
=
"FMO_OverrideID"
SortExpression
=
"FMO_OverrideID"
UniqueName
=
"FMO_OverrideID"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"CycleYearEnrollDate"
HeaderText
=
"CycleYearEnrollDate"
SortExpression
=
"CycleYearEnrollDate"
UniqueName
=
"CycleYearEnrollDate"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"PriorPlanType"
HeaderText
=
"PriorPlanType"
SortExpression
=
"PriorPlanType"
UniqueName
=
"PriorPlanType"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"AutoRollover"
HeaderText
=
"AutoRollover"
SortExpression
=
"AutoRollover"
UniqueName
=
"AutoRollover"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"IntegrityCheck"
HeaderText
=
"IntegrityCheck"
SortExpression
=
"IntegrityCheck"
UniqueName
=
"IntegrityCheck"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"YearRun"
HeaderText
=
"YearRun"
SortExpression
=
"YearRun"
UniqueName
=
"YearRun"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"ManualOverride"
HeaderText
=
"ManualOverride"
SortExpression
=
"ManualOverride"
UniqueName
=
"ManualOverride"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Notes"
HeaderText
=
"Notes"
SortExpression
=
"Notes"
UniqueName
=
"Notes"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"DateEntered"
DataType
=
"System.DateTime"
HeaderText
=
"DateEntered"
SortExpression
=
"DateEntered"
UniqueName
=
"DateEntered"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"EnteredBy"
HeaderText
=
"EnteredBy"
SortExpression
=
"EnteredBy"
UniqueName
=
"EnteredBy"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"DateUpdated"
DataType
=
"System.DateTime"
HeaderText
=
"DateUpdated"
SortExpression
=
"DateUpdated"
UniqueName
=
"DateUpdated"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"UpdatedBy"
HeaderText
=
"UpdatedBy"
SortExpression
=
"UpdatedBy"
UniqueName
=
"UpdatedBy"
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
<
telerik:RadAjaxManager
runat
=
"server"
>
</
telerik:RadAjaxManager
>
</
form
>
</
body
>
</
html
>
using
System;
using
System.Collections.Generic;
using
System.Configuration;
using
System.Linq;
using
System.Web;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using
System.Data;
using
System.Data.Sql;
using
System.Data.SqlClient;
using
System.Data.OleDb;
namespace
Commissions
{
public
partial
class
UpdateMembers : System.Web.UI.Page
{
protected
void
ImportData()
{
string
sSourceConstr = @
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source="
+ Server.MapPath(
"~/ExcelImport.xls"
) +
"; Extended Properties='Excel 8.0;HDR=YES;'"
;
string
sDestConstr = ConfigurationSettings.AppSettings[
"connString"
];
OleDbConnection conn =
new
OleDbConnection(sSourceConstr);
using
(conn)
{
string
sql =
"Select * FROM Worksheet1"
;
OleDbCommand command =
new
OleDbCommand(sql, conn);
conn.Open();
using
(OleDbDataReader dr = command.ExecuteReader())
{
using
(SqlBulkCopy bulkCopy =
new
SqlBulkCopy(sDestConstr))
{
bulkCopy.DestinationTableName =
"MembersTemp"
;
//You can mannualy set the column mapping by the following way.
//bulkCopy.ColumnMappings.Add("MSISDN", "MSISDN");
bulkCopy.WriteToServer(dr);
}
}
}
}
protected
void
Page_Load(
object
sender, EventArgs e)
{
}
protected
void
ButtonUploadFile_Click(
object
sender, EventArgs e)
{
}
protected
void
Button1_Click(
object
sender, EventArgs e)
{
RadGrid1.Rebind();
RadGrid1.Visible =
true
;
}
protected
void
Button2_Click(
object
sender, EventArgs e)
{
}
}
}
private RadDock CreateRadDock(String columnName)
{
RadDock dock = new RadDock();
dock.DockMode =
DockMode.Docked;
dock.EnableViewState =
true;
dock.EnableAnimation =
true;
dock.UniqueName =
Guid.NewGuid().ToString().Replace("-", "a");
dock.ID =
string.Format("RadDock{0}", dock.UniqueName);
dock.Title = columnName;
dock.Text = columnName;
dock.Width = System.Web.UI.WebControls.
Unit.Percentage(100);
dock.EnableRoundedCorners =
true;
dock.ExpandText =
"Settings";
dock.Commands.Add(
new DockCloseCommand());
System.Web.UI.WebControls.
Image mg = new System.Web.UI.WebControls.Image();
mg.Style.Add(
"float", "left");
mg.ImageUrl =
"~/Image/information.png";
mg.ID =
"mg" + dock.ID;
dock.TitlebarTemplate = new TitleBarTemplate(dock.Text);
dock.TitlebarContainer.Controls[0].FindControl(
"PanelForTitle").Controls.Add(mg);
dock.ContentTemplate =
new ContentTemplate(dock.Text);
return
dock;
}
public
class ContentTemplate : ITemplate
{
Panel pContainer = new Panel();
Panel pControls = new Panel();
CheckBox chkIsHidden = new CheckBox();
String columnName = String.Empty;
public ContentTemplate(String columnName)
{
this.columnName = columnName;
}
public void InstantiateIn(Control container)
{
Table tbl = new Table();
TableRow row = null;
TableCell cell = null;
// NEW ROW FOR HEADER TEXT
// ROW 1 (HEADER TEXT)
//LABEL
row =
new TableRow();
cell =
new TableCell();
Label lblText = new Label();
lblText.ID =
"lblTitle";
lblText.CssClass =
"rdcontent";
lblText.Text =
"Kolon Bal : ";
cell.Controls.Add(lblText);
row.Controls.Add(cell);
// TEXTBOX
cell =
new TableCell();
TextBox tb = new TextBox();
tb.Text =
this.columnName;
tb.ID =
"txtHeader";
tb.AutoPostBack =
true;
tb.MaxLength = 100;
tb.Width =
new System.Web.UI.WebControls.Unit(200);
cell.Controls.Add(tb);
row.Controls.Add(cell);
tbl.Controls.Add(row);
// ROW 2 (HIDDEN STATUS)
row =
new TableRow();
//LABEL
cell =
new TableCell();
lblText =
new Label();
lblText.ID =
"lblHidden";
lblText.CssClass =
"rdcontent";
lblText.Text =
"Gizli Kolon ";
cell.Controls.Add(lblText);
row.Controls.Add(cell);
//CHECKBOX
cell =
new TableCell();
CheckBox chkIsHidden = new CheckBox();
chkIsHidden.ID =
"cbIsHidden";
chkIsHidden.Checked =
false;
cell.Controls.Add(chkIsHidden);
row.Controls.Add(cell);
tbl.Controls.Add(row);
// ROW 3 (FILTER)
row =
new TableRow();
//LABEL
cell =
new TableCell();
lblText =
new Label();
lblText.ID =
"lblFilter";
lblText.CssClass =
"rdcontent";
lblText.Text =
"Filtreye Dahil Et ";
cell.Controls.Add(lblText);
row.Controls.Add(cell);
//CHECKBOX
cell =
new TableCell();
CheckBox chkIsFilter = new CheckBox();
chkIsFilter.ID =
"cbIsFilter";
chkIsFilter.Checked =
false;
cell.Controls.Add(chkIsFilter);
row.Controls.Add(cell);
tbl.Controls.Add(row);
pControls.ID =
"PanelForContent";
pControls.Controls.Add(tbl);
container.Controls.Add(pControls);
}
}
public class TitleBarTemplate : ITemplate
{
Label lblText = new Label();
Panel pContainer = new Panel();
Panel pControls = new Panel();
String columnName = String.Empty;
public TitleBarTemplate(String columnName)
{
this.columnName = columnName;
}
public void InstantiateIn(Control container)
{
Literal l;
lblText.ID =
"lblTitleText";
lblText.Text =
this.columnName;
pControls.ID =
"PanelForTitle";
l =
new Literal();
l.Text =
"<table style='float: left;'><tr><td class='rdcontent'>";
pContainer.Controls.Add(l);
pContainer.Controls.Add(lblText);
l =
new Literal();
l.Text =
"</td><td>";
pContainer.Controls.Add(l);
pContainer.Controls.Add(pControls);
l =
new Literal();
l.Text =
"</td></tr></table>";
pContainer.Controls.Add(l);
container.Controls.Add(pContainer);
}
}
protected void Page_Init(object sender, EventArgs e)
{
//// check source is changing
////Recreate the docks in order to ensure their proper operation
for (int i = 0; i < CurrentDockStates.Count; i++)
{
RadDock dock = CreateRadDockFromState(CurrentDockStates[i]);
//We will just add the RadDock control to the RadDockLayout.
// You could use any other control for that purpose, just ensure
// that it is inside the RadDockLayout control.
// The RadDockLayout control will automatically move the RadDock
// controls to their corresponding zone in the LoadDockLayout
// event (see below).
RadDockLayout1.Controls.Add(dock);
//We want to save the dock state every time a dock is moved.
CreateSaveStateTrigger(dock);
}
}
private void CreateSaveStateTrigger(RadDock dock)
{
//Ensure that the RadDock control will initiate postback
// when its position changes on the client or any of the commands is clicked.
//Using the trigger we will "ajaxify" that postback. by mr@h
//dock.AutoPostBack = true;
//dock.CommandsAutoPostBack = true;
AsyncPostBackTrigger saveStateTrigger = new AsyncPostBackTrigger();
saveStateTrigger.ControlID = dock.ID;
saveStateTrigger.EventName =
"DockPositionChanged";
UpdatePanel1.Triggers.Add(saveStateTrigger);
saveStateTrigger =
new AsyncPostBackTrigger();
saveStateTrigger.ControlID = dock.ID;
saveStateTrigger.EventName =
"Command";
UpdatePanel1.Triggers.Add(saveStateTrigger);
}
private RadDock CreateRadDockFromState(DockState state)
{
RadDock dock = new RadDock();
dock.DockMode =
DockMode.Docked;
dock.ID =
string.Format("RadDock{0}", state.UniqueName);
dock.ApplyState(state);
System.Web.UI.WebControls.
Image mg = new System.Web.UI.WebControls.Image();
mg.Style.Add(
"float", "left");
mg.ImageUrl =
"~/Image/information.png";
mg.ID =
"mg" + dock.ID;
//dock.Commands.Add(new DockExpandCollapseCommand());
return dock;
}
private List<DockState> CurrentDockStates
{
get
{
//Store the info about the added docks in the session. For real life
// applications we recommend using database or other storage medium
// for persisting this information.
List<DockState> _currentDockStates = (List<DockState>)Session["CurrentDockStatesDynamicDocks"];
if (Object.Equals(_currentDockStates, null))
{
_currentDockStates =
new List<DockState>();
Session[
"CurrentDockStatesDynamicDocks"] = _currentDockStates;
}
return _currentDockStates;
}
set
{
Session[
"CurrentDockStatesDynamicDocks"] = value;
}
}
Hi,
I need to retrive ComboBox id which was in RadGrid EditItemTemplate.
Here is my code:
protected
void
RadGrid1_ItemDataBound(
object
sender, GridItemEventArgs e)
{
if
(e.Item
is
GridEditFormItem && e.Item.IsInEditMode)
// if EditMode is EditForm or PopUp
{
GridEditFormItem editItem = (GridEditFormItem)e.Item;
RadComboBox ddlCity = editItem.FindControl(
"gvddlPOWCity"
)
as
RadComboBox;
string
city = ddlCity.SelectedValue;
. . . . . . . .
}
}
<MasterTableView DataKeyNames="POWId" EditMode="EditForms">
Eventhough I am getting e.Item.IsInEditMode is always false.
Is there any more modifications need to perform.Please tell me...
Thanks...
Hi All,
I'm using Telerik's RadScheduler Control with WebService Binding.
Originally I used RadScheduler with Server Side Binding which has an event called "OnTimeSlotCreated" which fires every time when a particular time slot is created so that i can access the time slot and get the control (HtmlTableCell Control) to modify it according to the requirement.
But now i'm binding it from client side through WebService which has no such "onClientTimeSlotCreated" event, also these time slots are not having any identity at client side to access.
Is there any one who has encountered such kind of issue and solved or can someone give some suggestions?
Thanks in advance...