<radG:RadGrid ID="grd" runat="server" AllowMultiRowSelection="false" HeaderStyle-Height="0"
AllowPaging="false" Width="100%" AllowSorting="false" AutoGenerateColumns="False"
BorderColor="LightBlue" BorderWidth="0px" AllowMultiRowEdit="false" EnableAJAX="True"
GridLines="None" Skin="SkeltaGrid" RadControlsDir="<%$ ReplaceTemplateExpn:telerik/radcontrols/%>"
OnNeedDataSource="grd_NeedDataSource" OnDetailTableDataBind="grd_DetailTableDataBind" OnItemCreated="grd_ItemCreated">
<mastertableview name="Base" nodetailrecordstext="No records found " nomasterrecordstext="No records found"
autogeneratecolumns="false" datasourceid="" datakeynames=""
hierarchydefaultexpanded="false" showheader="False" >
<Columns>
<radG:GridTemplateColumn UniqueName="Title">
<ItemTemplate>
<asp:Label ID="Label6" runat="server" Text="Between Dates : "></asp:Label>
<asp:Label ID="FromDate" runat="server" Font-Bold="true" Text='<%# fromDateDtp.SelectedDate.Value.ToString("dd/MMM/yyyy") %>'></asp:Label>
<asp:Label ID="Label9" runat="server" Text="-"></asp:Label>
<asp:Label ID="ToDate" runat="server" Font-Bold="true" Text='<%# toDateDtp.SelectedDate.Value.ToString("dd/MMM/yyyy") %>'></asp:Label>
<br />
<asp:Label ID="Label10" runat="server" Text="Generated On : "></asp:Label>
<asp:Label ID="Label11" runat="server" Text='<%# DateTime.Now.ToString("dd/MMM/yyyy hh:mm tt") %>'></asp:Label>
</ItemTemplate>
</radG:GridTemplateColumn>
</Columns>
<DetailTables>
<radG:GridTableView Name="Agents" DataKeyNames="" AllowPaging="false" AllowMultiColumnSorting="True"
Width="100%" DataSourceID="" TabIndex="0" AllowAutomaticUpdates="true" HierarchyLoadMode="ServerOnDemand">
<Columns>
<radG:GridTemplateColumn UniqueName="RequestDate">
<HeaderTemplate>
Request Date
</HeaderTemplate>
<ItemTemplate>
<label>
<%# Eval("Request Date")%>
</label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Center" Width="15%" />
<ItemStyle HorizontalAlign="Center" Width="15%" />
</radG:GridTemplateColumn>
<radG:GridTemplateColumn UniqueName="OpeningBalance">
<HeaderTemplate>
Opening Balance
</HeaderTemplate>
<ItemTemplate>
<label>
<%# Eval("Opening Balance")%>
</label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Center" Width="15%" />
<ItemStyle HorizontalAlign="Center" Width="15%" />
</radG:GridTemplateColumn>
<radG:GridTemplateColumn UniqueName="UploadInflow">
<HeaderTemplate>
Upload Inflow
</HeaderTemplate>
<ItemTemplate>
<label>
<%# Eval("Upload Inflow")%>
</label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Center" Width="15%" />
<ItemStyle HorizontalAlign="Center" Width="15%" />
</radG:GridTemplateColumn>
<radG:GridTemplateColumn UniqueName="InflowError">
<HeaderTemplate>
Inflow - Error Report
</HeaderTemplate>
<ItemTemplate>
<label>
<%# Eval("Inflow Error Report")%>
</label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Center" Width="20%" />
<ItemStyle HorizontalAlign="Center" Width="20%" />
</radG:GridTemplateColumn>
<radG:GridTemplateColumn UniqueName="ClosedCases">
<HeaderTemplate>
Closed Cases
</HeaderTemplate>
<ItemTemplate>
<label>
<%# Eval("Closed Cases")%>
</label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Center" Width="15%" />
<ItemStyle HorizontalAlign="Center" Width="15%" />
</radG:GridTemplateColumn>
<radG:GridTemplateColumn UniqueName="CarryForwardCases">
<HeaderTemplate>
Carry Forward Cases
</HeaderTemplate>
<ItemTemplate>
<label>
<%# Eval("Carry Forward Cases")%>
</label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Center" Width="15%" />
<ItemStyle HorizontalAlign="Center" Width="15%" />
</radG:GridTemplateColumn>
</Columns>
</radG:GridTableView>
</DetailTables>
</mastertableview>
<clientsettings>
<Selecting AllowRowSelect="false" EnableDragToSelectRows="false" />
</clientsettings>
<exportsettings exportonlydata="true" filename="Summary Report" ignorepaging="true"
openinnewwindow="true">
</exportsettings>
</radG:RadGrid>
protected void grd_NeedDataSource(object source, Telerik.WebControls.GridNeedDataSourceEventArgs e) {
this.Impersonate(InsuranceProcessLib.SPSettings);
try {
DataTable dt = InsuranceProcessLib.GetSummaryReport(Convert.ToDateTime(fromDateDtp.SelectedDate.Value), Convert.ToDateTime(toDateDtp.SelectedDate.Value));
//grd.MasterTableView.HierarchyDefaultExpanded = true;
grd.DataSource = dt;
} finally {
this.UndoImpersonation();
}
}
protected void grd_DetailTableDataBind(object source, Telerik.WebControls.GridDetailTableDataBindEventArgs e) {
if (_DataViews.Contains(e.DetailTableView)) return;
_DataViews.Add(e.DetailTableView);
e.DetailTableView.DataSource = InsuranceProcessLib.GetSummaryReport(Convert.ToDateTime(fromDateDtp.SelectedDate.Value), Convert.ToDateTime(toDateDtp.SelectedDate.Value));
e.DetailTableView.DataBind();
_DataViews.Remove(e.DetailTableView);
}
protected void grd_ItemCreated(object source, Telerik.WebControls.GridItemEventArgs e) {
if (e.Item.OwnerTableView.Name.Equals("Base")) {
if (e.Item.ItemType == GridItemType.Item || e.Item.ItemType == GridItemType.AlternatingItem) {
e.Item.BackColor = System.Drawing.Color.LightCyan;
}
}
}
protected void btnGo_Click(object sender, EventArgs e) {
grd.Rebind();
exportToExcelImgBtn.Visible = true;
excelExportLbl.Visible = true;
}

protected
void RSchedulerTemplate_OnAppointmentCreated(object sender, AppointmentCreatedEventArgs e)
{
ViewScheduler(
string ViewType);
}
privatevoid ViewScheduler(string ViewType)
{
for (int i = 0; i < DRMSession.DTScheduler.Rows.Count; i++)
ShiftDetails sDetails = GetShiftData(DRMSession.DTScheduler.Rows[i]["schedulerid"].ToString());
// assign startOffSet hours and minutes
TimeSpan startTime = TimeSpan.FromTicks(sDetails.startOffset);
TimeSpan endTime = TimeSpan.FromTicks(sDetails.Duration);
TimeSpan startOffSet = new TimeSpan(startTime.Hours, startTime.Minutes, 0);
DateTime startOffSetDate = new DateTime(startOffSet.Ticks);
// assign duration hours and minutes
TimeSpan duration = new TimeSpan(endTime.Hours, endTime.Minutes, 0);
DateTime durationDate = new DateTime(duration.Ticks);
// startOffSet and duration formatting result
string startOffSetResult = startOffSetDate.ToString("hh:mm tt");
string durationResult = durationDate.ToString("hh:mm tt");
string jobGroupName = string.Empty;
foreach (JobGroup jGroup in JobGroups)
if (jGroup.Id == sDetails.jobGroupId) {
jobGroupName = jGroup.Name;
break; }
}
switch (ViewType) {
case "Shift":
{
DRMSession.DTScheduler.Rows[i]["name"] = jobGroupName + " # " + startOffSetResult + " - " + durationResult;
}
break;
case "Task":
{
if (sDetails.LstTaskIds.Count > 0)
{
string tasksList = string.Empty;
foreach (Task tsk in Tasks)
{
foreach (int taskId in sDetails.LstTaskIds)
{
if (tsk.Id == taskId)
{
tasksList +=
Environment.NewLine + tsk.Title;
}
}
}
DRMSession.DTScheduler.Rows[i]["name"] = jobGroupName + Environment.NewLine + " # " + startOffSetResult + " - " + durationResult + Environment.NewLine + tasksList;
}
}
break;
case "Break":
{
if (sDetails.LstBreakIds.Count > 0)
{
string breakTypes = string.Empty;
foreach (BreakType bType in BreakType)
{
for (int Cnt = 0; Cnt < sDetails.LstBreakIds.Count; Cnt++)
{
if (sDetails.LstBreakIds[Cnt] == bType.Id)
{
breakTypes +=
Environment.NewLine + bType.Type + "-" + DateTime.Parse(sDetails.LstBreakTime[Cnt].ToString()).TimeOfDay;
}
}
}
DRMSession.DTScheduler.Rows[i]["name"] = jobGroupName + Environment.NewLine + " # " + startOffSetResult + " - " + durationResult + Environment.NewLine + breakTypes;
}
}
break;
}
}
RSchedulerTemplate.DataSource =
DRMSession.DTScheduler;
RSchedulerTemplate.Rebind();
}
protected void btnShiftView_Click(object sender, EventArgs e)
{
ViewType =
"Shift";
ViewScheduler(ViewType);
}
protected void btnTaskView_Click(object sender, EventArgs e)
{
ViewType =
"Task";
ViewScheduler(ViewType);
}
protected void btnBreakView_Click(object sender, EventArgs e)
{
ViewType =
"Break";
ViewScheduler(ViewType);
}
This is a crucial requirement. Appreciate any help in this regard.
| <authorization > |
| <deny users="?" /> |
| <allow users="?" /> |
| </authorization> |
| </system.web> |
| <location path="Bin"> |
| <system.web> |
| <authorization> |
| <allow users ="*" /> |
| </authorization> |
| </system.web> |
| </location> |
| <location path="login.aspx"> |
| <system.web> |
| <authorization> |
| <allow users ="*" /> |
| </authorization> |
| </system.web> |
| </location> |
| <location path="CSS"> |
| <system.web> |
| <authorization> |
| <allow users ="*" /> |
| </authorization> |
| </system.web> |
| </location> |
| <location path="Images"> |
| <system.web> |
| <authorization> |
| <allow users ="*" /> |
| </authorization> |
| </system.web> |
| </location> |
foreach (MemberDetail memberDetail in newShopper.MemberDetails)
{
linkMemberName =
new LinkButton();
tdMember =
new HtmlTableCell();
tdEditMember =
new HtmlTableCell();
trowMember =
new HtmlTableRow();
linkMemberName.ID =
"id1";
linkMemberName.Text = memberDetail.FirstName;
linkMemberName.CommandArgument = memberDetail.ID.ToString();
linkMemberName.Click +=
new EventHandler(linkMemberName_Click);
tdMember.Controls.Add(linkMemberName);
tblMemberDetails.Controls.Add(trowMember);
}
void linkMemberName_Click(object sender, EventArgs e)
{
throw new NotImplementedException();
}