public static AssessmentnCareParent GetAssessmentnCareParentByID(int id)
{
AssessmentnCareParent assessmentnCareParent = new AssessmentnCareParent();
SqlAssessmentnCareParentProvider sqlAssessmentnCareParentProvider = new SqlAssessmentnCareParentProvider();
assessmentnCareParent = sqlAssessmentnCareParentProvider.GetAssessmentnCareParentByID(id);
return assessmentnCareParent;
}
public static AssessmentnCareParent GetAssessmentnCareParentByID(int id)
{
AssessmentnCareParent assessmentnCareParent = new AssessmentnCareParent();
SqlAssessmentnCareParentProvider sqlAssessmentnCareParentProvider = new SqlAssessmentnCareParentProvider();
assessmentnCareParent = sqlAssessmentnCareParentProvider.GetAssessmentnCareParentByID(id);
return(assessmentnCareParent);
}
private void showAssessmentnCareParentData()
{
AssessmentnCareParent assessmentnCareParent = new AssessmentnCareParent();
assessmentnCareParent = AssessmentnCareParentManager.GetAssessmentnCareParentByID(Int32.Parse(Request.QueryString["assessmentnCareParentID"]));
txtAssessmentnCareParentName.Text = assessmentnCareParent.AssessmentnCareParentName;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
AssessmentnCareParent assessmentnCareParent = new AssessmentnCareParent();
assessmentnCareParent.AssessmentnCareParentName = txtAssessmentnCareParentName.Text;
int resutl = AssessmentnCareParentManager.InsertAssessmentnCareParent(assessmentnCareParent);
Response.Redirect("AssessmentnCare.aspx");
}
public bool UpdateAssessmentnCareParent(AssessmentnCareParent assessmentnCareParent)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_UpdateAssessmentnCareParent", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AssessmentnCareParentID", SqlDbType.Int).Value = assessmentnCareParent.AssessmentnCareParentID;
cmd.Parameters.Add("@AssessmentnCareParentName", SqlDbType.NVarChar).Value = assessmentnCareParent.AssessmentnCareParentName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public int InsertAssessmentnCareParent(AssessmentnCareParent assessmentnCareParent)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_InsertAssessmentnCareParent", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AssessmentnCareParentID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@AssessmentnCareParentName", SqlDbType.NVarChar).Value = assessmentnCareParent.AssessmentnCareParentName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@AssessmentnCareParentID"].Value);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
AssessmentnCareParent assessmentnCareParent = new AssessmentnCareParent();
assessmentnCareParent = AssessmentnCareParentManager.GetAssessmentnCareParentByID(Int32.Parse(Request.QueryString["assessmentnCareParentID"]));
AssessmentnCareParent tempAssessmentnCareParent = new AssessmentnCareParent();
tempAssessmentnCareParent.AssessmentnCareParentID = assessmentnCareParent.AssessmentnCareParentID;
tempAssessmentnCareParent.AssessmentnCareParentName = txtAssessmentnCareParentName.Text;
bool result = AssessmentnCareParentManager.UpdateAssessmentnCareParent(tempAssessmentnCareParent);
Response.Redirect("AssessmentnCare.aspx");
}
public AssessmentnCareParent GetAssessmentnCareParentFromReader(IDataReader reader)
{
try
{
AssessmentnCareParent assessmentnCareParent = new AssessmentnCareParent
(
(int)reader["AssessmentnCareParentID"],
reader["AssessmentnCareParentName"].ToString()
);
return(assessmentnCareParent);
}
catch (Exception ex)
{
return(null);
}
}
public AssessmentnCareParent GetAssessmentnCareParentFromReader(IDataReader reader)
{
try
{
AssessmentnCareParent assessmentnCareParent = new AssessmentnCareParent
(
(int)reader["AssessmentnCareParentID"],
reader["AssessmentnCareParentName"].ToString()
);
return assessmentnCareParent;
}
catch(Exception ex)
{
return null;
}
}
public bool UpdateAssessmentnCareParent(AssessmentnCareParent assessmentnCareParent)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_UpdateAssessmentnCareParent", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AssessmentnCareParentID", SqlDbType.Int).Value = assessmentnCareParent.AssessmentnCareParentID;
cmd.Parameters.Add("@AssessmentnCareParentName", SqlDbType.NVarChar).Value = assessmentnCareParent.AssessmentnCareParentName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertAssessmentnCareParent(AssessmentnCareParent assessmentnCareParent)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_InsertAssessmentnCareParent", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AssessmentnCareParentID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@AssessmentnCareParentName", SqlDbType.NVarChar).Value = assessmentnCareParent.AssessmentnCareParentName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@AssessmentnCareParentID"].Value;
}
}
public static bool UpdateAssessmentnCareParent(AssessmentnCareParent assessmentnCareParent)
{
SqlAssessmentnCareParentProvider sqlAssessmentnCareParentProvider = new SqlAssessmentnCareParentProvider();
return(sqlAssessmentnCareParentProvider.UpdateAssessmentnCareParent(assessmentnCareParent));
}
public static int InsertAssessmentnCareParent(AssessmentnCareParent assessmentnCareParent)
{
SqlAssessmentnCareParentProvider sqlAssessmentnCareParentProvider = new SqlAssessmentnCareParentProvider();
return(sqlAssessmentnCareParentProvider.InsertAssessmentnCareParent(assessmentnCareParent));
}
public static bool UpdateAssessmentnCareParent(AssessmentnCareParent assessmentnCareParent)
{
SqlAssessmentnCareParentProvider sqlAssessmentnCareParentProvider = new SqlAssessmentnCareParentProvider();
return sqlAssessmentnCareParentProvider.UpdateAssessmentnCareParent(assessmentnCareParent);
}
public static int InsertAssessmentnCareParent(AssessmentnCareParent assessmentnCareParent)
{
SqlAssessmentnCareParentProvider sqlAssessmentnCareParentProvider = new SqlAssessmentnCareParentProvider();
return sqlAssessmentnCareParentProvider.InsertAssessmentnCareParent(assessmentnCareParent);
}
