public static TRANSFERACCOUNT GetTRANSFERACCOUNTByID(int id)
{
TRANSFERACCOUNT tRANSFERACCOUNT = new TRANSFERACCOUNT();
SqlTRANSFERACCOUNTProvider sqlTRANSFERACCOUNTProvider = new SqlTRANSFERACCOUNTProvider();
tRANSFERACCOUNT = sqlTRANSFERACCOUNTProvider.GetTRANSFERACCOUNTByID(id);
return(tRANSFERACCOUNT);
}
public int InsertTRANSFERACCOUNT(TRANSFERACCOUNT tRANSFERACCOUNT)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_InsertTRANSFERACCOUNT", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@TRANSFERACCOUNTID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@ACCTYPE", SqlDbType.Char).Value = tRANSFERACCOUNT.ACCTYPE;
cmd.Parameters.Add("@ACCNAME", SqlDbType.VarChar).Value = tRANSFERACCOUNT.ACCNAME;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@TRANSFERACCOUNTID"].Value);
}
}
public bool UpdateTRANSFERACCOUNT(TRANSFERACCOUNT tRANSFERACCOUNT)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateTRANSFERACCOUNT", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@TRANSFERACCOUNTID", SqlDbType.Int).Value = tRANSFERACCOUNT.TRANSFERACCOUNTID;
cmd.Parameters.Add("@ACCTYPE", SqlDbType.Char).Value = tRANSFERACCOUNT.ACCTYPE;
cmd.Parameters.Add("@ACCNAME", SqlDbType.VarChar).Value = tRANSFERACCOUNT.ACCNAME;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public TRANSFERACCOUNT GetTRANSFERACCOUNTFromReader(IDataReader reader)
{
try
{
TRANSFERACCOUNT tRANSFERACCOUNT = new TRANSFERACCOUNT
(
(int)reader["TRANSFERACCOUNTID"],
(char)reader["ACCTYPE"],
reader["ACCNAME"].ToString()
);
return(tRANSFERACCOUNT);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateTRANSFERACCOUNT(TRANSFERACCOUNT tRANSFERACCOUNT)
{
SqlTRANSFERACCOUNTProvider sqlTRANSFERACCOUNTProvider = new SqlTRANSFERACCOUNTProvider();
return(sqlTRANSFERACCOUNTProvider.UpdateTRANSFERACCOUNT(tRANSFERACCOUNT));
}
public static int InsertTRANSFERACCOUNT(TRANSFERACCOUNT tRANSFERACCOUNT)
{
SqlTRANSFERACCOUNTProvider sqlTRANSFERACCOUNTProvider = new SqlTRANSFERACCOUNTProvider();
return(sqlTRANSFERACCOUNTProvider.InsertTRANSFERACCOUNT(tRANSFERACCOUNT));
}
