private DataSet GetGridData()
{
DataSet oDs;
DateTime DateStart = this.cc2DateSelector.StartDate();
DateTime DateEnd = this.cc2DateSelector.EndDate();
try
{
ClassReport oRep = new ClassReport();
oDs = oRep.GetTimeSheet(Int32.Parse(this.DdlUsers.SelectedValue.ToString()), DateStart, DateEnd);
}
catch (Exception ex)
{
Log.LogMsg(ex.Message);
oDs = null;
}
return oDs;
}
public DataSet GetTimeSheet(string UsrNam, string UsrPwd, DateTime StartDate, DateTime EndDate)
{
DataSet oDs = null;
try
{
Int32 UserId = GetUserId(UsrNam, UsrPwd);
if (UserId > 0)
{
ClassReport oRep = new ClassReport();
oDs = oRep.GetTimeSheet(UserId, StartDate, EndDate);
}
}
catch (Exception ex)
{
Log.LogMsg(ex.Message);
}
return oDs;
}
private void ShowGrid(Int32 PageNo)
{
DateTime DateStart = this.cc2DateSelector.StartDate();
DateTime DateEnd = this.cc2DateSelector.EndDate();
this.LblFrom.Text = DateStart.ToString("dd MMM yyyy");
this.LblTo.Text = DateEnd.ToString("dd MMM yyyy");
ClassReport oRep = new ClassReport();
DataSet oDs = oRep.GetTimeSheet(Int32.Parse(ViewState["UserId"].ToString()), DateStart, DateEnd);
double dTotal = 0;
foreach (DataRow oDr in oDs.Tables[0].Rows)
dTotal += double.Parse(oDr["Hours"].ToString());
ViewState["TotalHours"] = dTotal.ToString();
this.GridTime.DataSource = oDs;
this.GridTime.PageIndex = (PageNo >= 0) ? PageNo : 0;
this.GridTime.DataBind();
if (Int32.Parse(ViewState["TimeId"].ToString()) == 0)
{
this.BtnSubmit.Text = "Submit";
this.LblTimeId.Text = "New";
}
else
{
this.BtnSubmit.Text = "Update";
this.LblTimeId.Text = string.Format("Update ({0})", Int32.Parse(ViewState["TimeId"].ToString()));
}
// Time events which are locked cannot be edited or deleted.
ClassTime oTim = new ClassTime();
foreach (GridViewRow oRow in GridTime.Rows)
{
ImageButton oDel = (ImageButton)oRow.FindControl("ImgTrash");
if (oDel != null)
{
oTim.Load(Int32.Parse(oDel.CommandArgument));
if (oTim.Locked)
{
oDel.ToolTip = "";
oDel.Enabled = false;
oDel.ImageUrl = "~/Images/BlankIcon.gif";
}
}
}
ShowTimeError("");
}
