public void GetGroomerDailyLogData()
{
Groomer objgroomer = new Groomer();
DataSet ds = new DataSet();
ds = objgroomer.GetGroomerDailyLogData(Convert.ToInt32(Request.QueryString["GID"].ToString()), ddlLastweek.SelectedItem.Value.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
GrdGroomer.DataSource = ds;
GrdGroomer.DataBind();
lblName.Text = ds.Tables[0].Rows[0]["CustomerName"].ToString();
lblBeginningMileage.Text = ds.Tables[0].Rows[0]["BeginningMileage"].ToString();
lblEndingMileage.Text = ds.Tables[0].Rows[0]["EndingMileage"].ToString();
lblDate.Text = ds.Tables[0].Rows[0]["addedon"].ToString();
Session["SheetName"] = ds.Tables[1].Rows[0]["SheetName"].ToString();
dvgroomers.Visible = true;
divError.Visible = false;
}
else
{
divError.Visible = true;
dvgroomers.Visible = false;
ErrorMessage("Sorry, No records found.");
}
}
public void GetGroomerMonthlyLogData()
{
Groomer objgroomer = new Groomer();
DataSet ds = new DataSet();
DataSet ds1 = new DataSet();
ds = objgroomer.GetGroomerMonthlyLogData(Convert.ToInt32(Request.QueryString["GID"].ToString()), txtStartDate.Text, txtEndDate.Text);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[1].Rows.Count > 0)
{
for (int count = 0; count < ds.Tables[1].Columns.Count; count++)
{
ds.Tables[0].Columns.Add(ds.Tables[1].Columns[count].ColumnName, ds.Tables[1].Columns[count].DataType);
ds.Tables[0].Rows[0][ds.Tables[0].Columns.Count - 1] = ds.Tables[1].Rows[0][count];
}
}
dvgroomers.Visible = true;
GrdGroomer.DataSource = ds.Tables[0];
GrdGroomer.DataBind();
dvgroomers.Visible = true;
divError.Visible = false;
}
else
{
dvgroomers.Visible = false;
divError.Visible = true;
dvgroomers.Visible = false;
ErrorMessage("Sorry, No records found.");
}
}
public void GetGroomerAppointmentDetails()
{
Groomer objgroomer = new Groomer();
DataSet ds = new DataSet();
ds = objgroomer.GetGroomerAppointmentDetails(Convert.ToInt32(Request.QueryString["DailyLogID"].ToString()));
if (ds.Tables[0].Rows.Count > 0)
{
GrdGroomer.DataSource = ds;
GrdGroomer.DataBind();
}
}
