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"); }
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); } }
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); }