public static ACC_HeadType GetACC_HeadTypeByID(int id)
{
ACC_HeadType aCC_HeadType = new ACC_HeadType();
SqlACC_HeadTypeProvider sqlACC_HeadTypeProvider = new SqlACC_HeadTypeProvider();
aCC_HeadType = sqlACC_HeadTypeProvider.GetACC_HeadTypeByID(id);
return aCC_HeadType;
}
public static ACC_HeadType GetACC_HeadTypeByID(int id)
{
ACC_HeadType aCC_HeadType = new ACC_HeadType();
SqlACC_HeadTypeProvider sqlACC_HeadTypeProvider = new SqlACC_HeadTypeProvider();
aCC_HeadType = sqlACC_HeadTypeProvider.GetACC_HeadTypeByID(id);
return(aCC_HeadType);
}
private void showACC_HeadTypeData()
{
ACC_HeadType aCC_HeadType = new ACC_HeadType();
aCC_HeadType = ACC_HeadTypeManager.GetACC_HeadTypeByID(Int32.Parse(Request.QueryString["aCC_HeadTypeID"]));
txtHeadTypeName.Text = aCC_HeadType.HeadTypeName;
txtExtraField1.Text = aCC_HeadType.ExtraField1;
txtExtraField2.Text = aCC_HeadType.ExtraField2;
txtExtraField3.Text = aCC_HeadType.ExtraField3;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
ACC_HeadType aCC_HeadType = new ACC_HeadType();
aCC_HeadType.HeadTypeName = txtHeadTypeName.Text;
aCC_HeadType.ExtraField1 = txtExtraField1.Text;
aCC_HeadType.ExtraField2 = txtExtraField2.Text;
aCC_HeadType.ExtraField3 = txtExtraField3.Text;
int resutl = ACC_HeadTypeManager.InsertACC_HeadType(aCC_HeadType);
Response.Redirect("AdminACC_HeadTypeDisplay.aspx");
}
private void showACC_HeadTypeData()
{
ACC_HeadType aCC_HeadType = new ACC_HeadType();
aCC_HeadType = ACC_HeadTypeManager.GetACC_HeadTypeByID(Int32.Parse(Request.QueryString["aCC_HeadTypeID"]));
txtHeadTypeName.Text = aCC_HeadType.HeadTypeName;
txtExtraField1.Text = aCC_HeadType.ExtraField1;
txtExtraField2.Text = aCC_HeadType.ExtraField2;
txtExtraField3.Text = aCC_HeadType.ExtraField3;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
ACC_HeadType aCC_HeadType = new ACC_HeadType();
aCC_HeadType.HeadTypeName = txtHeadTypeName.Text;
aCC_HeadType.ExtraField1 = txtExtraField1.Text;
aCC_HeadType.ExtraField2 = txtExtraField2.Text;
aCC_HeadType.ExtraField3 = txtExtraField3.Text;
int resutl = ACC_HeadTypeManager.InsertACC_HeadType(aCC_HeadType);
Response.Redirect("AdminACC_HeadTypeDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
ACC_HeadType aCC_HeadType = new ACC_HeadType();
aCC_HeadType = ACC_HeadTypeManager.GetACC_HeadTypeByID(Int32.Parse(Request.QueryString["aCC_HeadTypeID"]));
ACC_HeadType tempACC_HeadType = new ACC_HeadType();
tempACC_HeadType.ACC_HeadTypeID = aCC_HeadType.ACC_HeadTypeID;
tempACC_HeadType.HeadTypeName = txtHeadTypeName.Text;
tempACC_HeadType.ExtraField1 = txtExtraField1.Text;
tempACC_HeadType.ExtraField2 = txtExtraField2.Text;
tempACC_HeadType.ExtraField3 = txtExtraField3.Text;
bool result = ACC_HeadTypeManager.UpdateACC_HeadType(tempACC_HeadType);
Response.Redirect("AdminACC_HeadTypeDisplay.aspx");
}
public int InsertACC_HeadType(ACC_HeadType aCC_HeadType)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_InsertACC_HeadType", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ACC_HeadTypeID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@HeadTypeName", SqlDbType.NVarChar).Value = aCC_HeadType.HeadTypeName;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = aCC_HeadType.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = aCC_HeadType.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = aCC_HeadType.ExtraField3;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@ACC_HeadTypeID"].Value);
}
}
public bool UpdateACC_HeadType(ACC_HeadType aCC_HeadType)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateACC_HeadType", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ACC_HeadTypeID", SqlDbType.Int).Value = aCC_HeadType.ACC_HeadTypeID;
cmd.Parameters.Add("@HeadTypeName", SqlDbType.NVarChar).Value = aCC_HeadType.HeadTypeName;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = aCC_HeadType.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = aCC_HeadType.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = aCC_HeadType.ExtraField3;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
ACC_HeadType aCC_HeadType = new ACC_HeadType();
aCC_HeadType = ACC_HeadTypeManager.GetACC_HeadTypeByID(Int32.Parse(Request.QueryString["aCC_HeadTypeID"]));
ACC_HeadType tempACC_HeadType = new ACC_HeadType();
tempACC_HeadType.ACC_HeadTypeID = aCC_HeadType.ACC_HeadTypeID;
tempACC_HeadType.HeadTypeName = txtHeadTypeName.Text;
tempACC_HeadType.ExtraField1 = txtExtraField1.Text;
tempACC_HeadType.ExtraField2 = txtExtraField2.Text;
tempACC_HeadType.ExtraField3 = txtExtraField3.Text;
bool result = ACC_HeadTypeManager.UpdateACC_HeadType(tempACC_HeadType);
Response.Redirect("AdminACC_HeadTypeDisplay.aspx");
}
public ACC_HeadType GetACC_HeadTypeFromReader(IDataReader reader)
{
try
{
ACC_HeadType aCC_HeadType = new ACC_HeadType
(
(int)reader["ACC_HeadTypeID"],
reader["HeadTypeName"].ToString(),
reader["ExtraField1"].ToString(),
reader["ExtraField2"].ToString(),
reader["ExtraField3"].ToString()
);
return aCC_HeadType;
}
catch(Exception ex)
{
return null;
}
}
public ACC_HeadType GetACC_HeadTypeFromReader(IDataReader reader)
{
try
{
ACC_HeadType aCC_HeadType = new ACC_HeadType
(
(int)reader["ACC_HeadTypeID"],
reader["HeadTypeName"].ToString(),
reader["ExtraField1"].ToString(),
reader["ExtraField2"].ToString(),
reader["ExtraField3"].ToString()
);
return(aCC_HeadType);
}
catch (Exception ex)
{
return(null);
}
}
public bool UpdateACC_HeadType(ACC_HeadType aCC_HeadType)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateACC_HeadType", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ACC_HeadTypeID", SqlDbType.Int).Value = aCC_HeadType.ACC_HeadTypeID;
cmd.Parameters.Add("@HeadTypeName", SqlDbType.NVarChar).Value = aCC_HeadType.HeadTypeName;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = aCC_HeadType.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = aCC_HeadType.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = aCC_HeadType.ExtraField3;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertACC_HeadType(ACC_HeadType aCC_HeadType)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_InsertACC_HeadType", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ACC_HeadTypeID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@HeadTypeName", SqlDbType.NVarChar).Value = aCC_HeadType.HeadTypeName;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = aCC_HeadType.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = aCC_HeadType.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = aCC_HeadType.ExtraField3;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@ACC_HeadTypeID"].Value;
}
}
public static bool UpdateACC_HeadType(ACC_HeadType aCC_HeadType)
{
SqlACC_HeadTypeProvider sqlACC_HeadTypeProvider = new SqlACC_HeadTypeProvider();
return(sqlACC_HeadTypeProvider.UpdateACC_HeadType(aCC_HeadType));
}
public static int InsertACC_HeadType(ACC_HeadType aCC_HeadType)
{
SqlACC_HeadTypeProvider sqlACC_HeadTypeProvider = new SqlACC_HeadTypeProvider();
return(sqlACC_HeadTypeProvider.InsertACC_HeadType(aCC_HeadType));
}
public static int InsertACC_HeadType(ACC_HeadType aCC_HeadType)
{
SqlACC_HeadTypeProvider sqlACC_HeadTypeProvider = new SqlACC_HeadTypeProvider();
return sqlACC_HeadTypeProvider.InsertACC_HeadType(aCC_HeadType);
}
public static bool UpdateACC_HeadType(ACC_HeadType aCC_HeadType)
{
SqlACC_HeadTypeProvider sqlACC_HeadTypeProvider = new SqlACC_HeadTypeProvider();
return sqlACC_HeadTypeProvider.UpdateACC_HeadType(aCC_HeadType);
}
