protected void AddRow(object sender, EventArgs e)
{
UpdatepagedData();
DataTable DtPagedData = ((DataTable)ViewState["PagedData"]);
DataRow Dr = DtPagedData.NewRow();
Dr["TId"] = 0;
Dr["TEDATE"] = DateTime.Now.Date;
Dr["TResourceId"] = resourceid;
Dr["TECreatedon"] = DateTime.Now.Date;
Dr["TEfforts"] = 0;
Dr["TicketNumber"] = " ";
Dr["TikcetCreatedOn"] = DateTime.Now.Date;
Dr["TicketDescription"] = " ";
Dr["TicketTypeId"] = 0;
Dr["ApplicationId"] = 0;
Dr["ApplicationTypeId"] = 0;
Dr["VendorId"] = 0;
Dr["ClassificationId"] = 0;
Dr["TicketStatusId"] = 0;
Dr["Mode"] = "I";
//Dr["Mode"] = "U";
DtPagedData.Rows.Add(Dr);
RptAddefforts.DataSource = DtPagedData;
RptAddefforts.DataBind();
}
private void BindCurrentdayData()
{
if (Request.QueryString["date"] != null)
{
DateTime DtDate = DateTime.ParseExact(Request.QueryString["date"], "dd/MM/yyyy", null);
DataTable DtSelectmonthsefforts = new DataTable();
DtSelectmonthsefforts.TableName = "TblEfforts";
IDataReader Dr;
SqlConnection con = new SqlConnection();
try
{
con.ConnectionString = ConfigurationManager.ConnectionStrings["TMS"].ConnectionString;
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.CommandText = "prc_getcurrentdayefforts";
cmd.Parameters.AddWithValue("@currentdate", DtDate);
cmd.Parameters.AddWithValue("@resourceid", resourceid);
Dr = cmd.ExecuteReader();
DtSelectmonthsefforts.Load(Dr);
con.Close();
ViewState["PagedData"] = DtSelectmonthsefforts;
if (DtSelectmonthsefforts != null && DtSelectmonthsefforts.Rows.Count > 0)
{
LblPagemode.Text = "U";
}
else
{
LblPagemode.Text = "I";
}
RptAddefforts.DataSource = DtSelectmonthsefforts;
RptAddefforts.DataBind();
}
catch (Exception M)
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
}
