public AssessmentnCareChild GetAssessmentnCareChildFromReader(IDataReader reader)
{
try
{
AssessmentnCareChild assessmentnCareChild = new AssessmentnCareChild
(
(int)reader["AssessmentnCareChildID"],
(int)reader["AssessmentnCareParentID"],
reader["AssessmentnCareChildName"].ToString()
);
try
{
assessmentnCareChild.AssessmentnCareParentName = reader["AssessmentnCareParentName"].ToString();
}
catch (Exception ex)
{
}
return(assessmentnCareChild);
}
catch (Exception ex)
{
return(null);
}
}
public static AssessmentnCareChild GetAssessmentnCareChildByID(int id)
{
AssessmentnCareChild assessmentnCareChild = new AssessmentnCareChild();
SqlAssessmentnCareChildProvider sqlAssessmentnCareChildProvider = new SqlAssessmentnCareChildProvider();
assessmentnCareChild = sqlAssessmentnCareChildProvider.GetAssessmentnCareChildByID(id);
return assessmentnCareChild;
}
public static AssessmentnCareChild GetAssessmentnCareChildByID(int id)
{
AssessmentnCareChild assessmentnCareChild = new AssessmentnCareChild();
SqlAssessmentnCareChildProvider sqlAssessmentnCareChildProvider = new SqlAssessmentnCareChildProvider();
assessmentnCareChild = sqlAssessmentnCareChildProvider.GetAssessmentnCareChildByID(id);
return(assessmentnCareChild);
}
private void showAssessmentnCareChildData()
{
AssessmentnCareChild assessmentnCareChild = new AssessmentnCareChild();
assessmentnCareChild = AssessmentnCareChildManager.GetAssessmentnCareChildByID(Int32.Parse(Request.QueryString["assessmentnCareChildID"]));
ddlAssessmentnCareParent.SelectedValue = assessmentnCareChild.AssessmentnCareParentID.ToString();
txtAssessmentnCareChildName.Text = assessmentnCareChild.AssessmentnCareChildName;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
AssessmentnCareChild assessmentnCareChild = new AssessmentnCareChild();
assessmentnCareChild.AssessmentnCareParentID = Int32.Parse(ddlAssessmentnCareParent.SelectedValue);
assessmentnCareChild.AssessmentnCareChildName = txtAssessmentnCareChildName.Text;
int resutl = AssessmentnCareChildManager.InsertAssessmentnCareChild(assessmentnCareChild);
txtAssessmentnCareChildName.Text = "";
//Response.Redirect("AdminAssessmentnCareChildDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
AssessmentnCareChild assessmentnCareChild = new AssessmentnCareChild();
assessmentnCareChild = AssessmentnCareChildManager.GetAssessmentnCareChildByID(Int32.Parse(Request.QueryString["assessmentnCareChildID"]));
AssessmentnCareChild tempAssessmentnCareChild = new AssessmentnCareChild();
tempAssessmentnCareChild.AssessmentnCareChildID = assessmentnCareChild.AssessmentnCareChildID;
tempAssessmentnCareChild.AssessmentnCareParentID = Int32.Parse(ddlAssessmentnCareParent.SelectedValue);
tempAssessmentnCareChild.AssessmentnCareChildName = txtAssessmentnCareChildName.Text;
bool result = AssessmentnCareChildManager.UpdateAssessmentnCareChild(tempAssessmentnCareChild);
Response.Redirect("AssessmentnCare.aspx");
}
public bool UpdateAssessmentnCareChild(AssessmentnCareChild assessmentnCareChild)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_UpdateAssessmentnCareChild", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AssessmentnCareChildID", SqlDbType.Int).Value = assessmentnCareChild.AssessmentnCareChildID;
cmd.Parameters.Add("@AssessmentnCareParentID", SqlDbType.Int).Value = assessmentnCareChild.AssessmentnCareParentID;
cmd.Parameters.Add("@AssessmentnCareChildName", SqlDbType.NVarChar).Value = assessmentnCareChild.AssessmentnCareChildName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public static bool UpdateAssessmentnCareChild(AssessmentnCareChild assessmentnCareChild)
{
SqlAssessmentnCareChildProvider sqlAssessmentnCareChildProvider = new SqlAssessmentnCareChildProvider();
return sqlAssessmentnCareChildProvider.UpdateAssessmentnCareChild(assessmentnCareChild);
}
public static int InsertAssessmentnCareChild(AssessmentnCareChild assessmentnCareChild)
{
SqlAssessmentnCareChildProvider sqlAssessmentnCareChildProvider = new SqlAssessmentnCareChildProvider();
return sqlAssessmentnCareChildProvider.InsertAssessmentnCareChild(assessmentnCareChild);
}
public AssessmentnCareChild GetAssessmentnCareChildFromReader(IDataReader reader)
{
try
{
AssessmentnCareChild assessmentnCareChild = new AssessmentnCareChild
(
(int)reader["AssessmentnCareChildID"],
(int)reader["AssessmentnCareParentID"],
reader["AssessmentnCareChildName"].ToString()
);
try
{
assessmentnCareChild.AssessmentnCareParentName = reader["AssessmentnCareParentName"].ToString();
}
catch (Exception ex)
{
}
return assessmentnCareChild;
}
catch(Exception ex)
{
return null;
}
}
public bool UpdateAssessmentnCareChild(AssessmentnCareChild assessmentnCareChild)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_UpdateAssessmentnCareChild", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AssessmentnCareChildID", SqlDbType.Int).Value = assessmentnCareChild.AssessmentnCareChildID;
cmd.Parameters.Add("@AssessmentnCareParentID", SqlDbType.Int).Value = assessmentnCareChild.AssessmentnCareParentID;
cmd.Parameters.Add("@AssessmentnCareChildName", SqlDbType.NVarChar).Value = assessmentnCareChild.AssessmentnCareChildName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertAssessmentnCareChild(AssessmentnCareChild assessmentnCareChild)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_InsertAssessmentnCareChild", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AssessmentnCareChildID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@AssessmentnCareParentID", SqlDbType.Int).Value = assessmentnCareChild.AssessmentnCareParentID;
cmd.Parameters.Add("@AssessmentnCareChildName", SqlDbType.NVarChar).Value = assessmentnCareChild.AssessmentnCareChildName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@AssessmentnCareChildID"].Value;
}
}
public static bool UpdateAssessmentnCareChild(AssessmentnCareChild assessmentnCareChild)
{
SqlAssessmentnCareChildProvider sqlAssessmentnCareChildProvider = new SqlAssessmentnCareChildProvider();
return(sqlAssessmentnCareChildProvider.UpdateAssessmentnCareChild(assessmentnCareChild));
}
public static int InsertAssessmentnCareChild(AssessmentnCareChild assessmentnCareChild)
{
SqlAssessmentnCareChildProvider sqlAssessmentnCareChildProvider = new SqlAssessmentnCareChildProvider();
return(sqlAssessmentnCareChildProvider.InsertAssessmentnCareChild(assessmentnCareChild));
}
