protected void ShowValues()
{
BindOwner();
int taskid = Convert.ToInt32(Request.QueryString[0]);
objChangetask = objChangetask.Get_By_id(taskid);
if (objChangetask.Taskid != 0)
{
btnUpdate.Visible = true;
btnAdd.Visible = false;
txttitle.Text = objChangetask.Title.ToString();
txtdescription.Text = objChangetask.Description.ToString();
if (objChangetask.Scheduledendtime == null)
{
txtschdlendtime.Text = "";
}
else
{
txtschdlendtime.Text = objChangetask.Scheduledendtime.ToString();
}
if (objChangetask.Scheduledstarttime == null)
{
txtschedlstarttime.Text = "";
}
else
{
txtschedlstarttime.Text = objChangetask.Scheduledstarttime.ToString();
}
if (objChangetask.Actualendtime == null)
{
txtatendtime.Text = "";
}
else
{
txtatendtime.Text = objChangetask.Actualendtime.ToString();
}
if (objChangetask.Actualstarttime == null)
{
txtatsttime.Text = "";
}
else
{
txtatsttime.Text = objChangetask.Actualstarttime.ToString();
}
drpTechnician1.SelectedValue = objChangetask.Ownerid.ToString();
drptaskstatus.SelectedValue = objChangetask.Taskstatusid.ToString();
}
}
protected void ShowValues()
{
BindOwner();
int taskid = Convert.ToInt16(Request.QueryString[0]);
objChangetask = objChangetask.Get_By_id(taskid);
if (objChangetask.Taskid != 0)
{
btnUpdate.Visible = true;
btnAdd.Visible = false;
txttitle.Text = objChangetask.Title.ToString();
txtdescription.Text = objChangetask.Description.ToString();
if (objChangetask.Scheduledendtime == null)
{
txtschdlendtime.Text = "";
}
else
{
txtschdlendtime.Text = objChangetask.Scheduledendtime.ToString();
}
if (objChangetask.Scheduledstarttime == null)
{
txtschedlstarttime.Text = "";
}
else
{
txtschedlstarttime.Text = objChangetask.Scheduledstarttime.ToString();
}
if (objChangetask.Actualendtime == null)
{
txtatendtime.Text = "";
}
else
{
txtatendtime.Text = objChangetask.Actualendtime.ToString();
}
if (objChangetask.Actualstarttime == null)
{
txtatsttime.Text = "";
}
else
{
txtatsttime.Text = objChangetask.Actualstarttime.ToString();
}
drpTechnician1.SelectedValue = objChangetask.Ownerid.ToString();
drptaskstatus.SelectedValue = objChangetask.Taskstatusid.ToString();
}
}
public int Insert_ChangeTask_mst(ChangeTask_mst ObjChangeTask)
{
return (int)ExecuteNonQuery(Sp_ChangeTask_Insert, new object[] { ObjChangeTask.Changeid, ObjChangeTask.Title, ObjChangeTask.Description, ObjChangeTask.Scheduledstarttime, ObjChangeTask.Scheduledendtime, ObjChangeTask.Actualstarttime, ObjChangeTask.Actualendtime, ObjChangeTask.Comment, ObjChangeTask.Ownerid, ObjChangeTask.Taskstatusid });
}
public int Update_ChangeTask_By_id(ChangeTask_mst ObjChangeTask)
{
return (int)ExecuteNonQuery(Sp_ChangeTask_Update, new object[] { ObjChangeTask.Taskid, ObjChangeTask.Title, ObjChangeTask.Description, ObjChangeTask.Scheduledstarttime, ObjChangeTask.Scheduledendtime, ObjChangeTask.Actualstarttime, ObjChangeTask.Actualendtime, ObjChangeTask.Ownerid, ObjChangeTask.Taskstatusid });
}
public object GenerateChangeTask_mstObject(ref IDataReader returnData)
{
ChangeTask_mst obj = new ChangeTask_mst();
while (returnData.Read())
{
obj.Taskid = (int)returnData["Taskid"];
obj.Changeid = (int)returnData["Changeid"];
obj.Taskstatusid = (int)returnData["Taskstatusid"];
obj.Ownerid = (int)returnData["Ownerid"];
obj.Title = (string)returnData["Title"];
if (returnData["Description"] != DBNull.Value)
{
obj.Description = (string)returnData["Description"];
}
if (returnData["Comment"] != DBNull.Value)
{
obj.Comment = (string)returnData["Comment"];
}
if (returnData["Scheduledstarttime"] != DBNull.Value)
{
DateTime Mydatetime = new DateTime();
Mydatetime = (DateTime)returnData["Scheduledstarttime"];
obj.Scheduledstarttime = Mydatetime.ToString();
}
if (returnData["Scheduledendtime"] != DBNull.Value)
{
DateTime Mydatetime1 = new DateTime();
Mydatetime1 = (DateTime)returnData["Scheduledendtime"];
obj.Scheduledendtime = Mydatetime1.ToString();
}
if (returnData["Actualstarttime"] != DBNull.Value)
{
DateTime Mydatetime3 = new DateTime();
Mydatetime3 = (DateTime)returnData["Actualstarttime"];
obj.Actualstarttime = Mydatetime3.ToString();
}
if (returnData["Actualendtime"] != DBNull.Value)
{
DateTime Mydatetime4 = new DateTime();
Mydatetime4 = (DateTime)returnData["Actualendtime"];
obj.Actualendtime = Mydatetime4.ToString();
}
}
returnData.Close();
returnData.Dispose();
return obj;
}
