public void Insert2(balObject obj)
{
//Change to SP if required
string InsertSQL = "INSERT INTO bal (cpty,quantity) VALUES (@cpty, @quantity)";
using (SqlConnection conn = new SqlConnection(CmdStr))
{
SqlCommand cmd = new SqlCommand(InsertSQL, conn);
//cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@cpty", (object)obj.cpty ?? DBNull.Value);
cmd.Parameters.AddWithValue("@quantity", (object)obj.quantity ?? DBNull.Value);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (SqlException Ex)
{ throw; }
}
}
public void Update(balObject obj)
{
//Change to SP if required
string UpdateSQL = "UPDATE bal SET cpty=@cpty, quantity=@quantity where cpty=@cpty";
using (SqlConnection conn = new SqlConnection(CmdStr))
{
SqlCommand cmd = new SqlCommand(UpdateSQL, conn);
//cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@cpty", obj.cpty);
cmd.Parameters.AddWithValue("@quantity", obj.quantity);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (SqlException Ex)
{ /**/ }
}
}
#endregion Methods
}
public class balObject
{
#region Constructors
public balObject(SqlDataReader rdr)
{
this.cpty = rdr["cpty"] == DBNull.Value ? this.cpty : (string)rdr["cpty"];
this.quantity = rdr["quantity"] == DBNull.Value ? this.quantity : (int)rdr["quantity"];
}
public balObject(string c, int q)
{
this.cpty = c;
this.quantity = q;
}
#endregion Constructors
#region Properties
public string cpty
{
get; set;
}
public int? quantity
{
get; set;
}
#endregion Properties
}
public class WordsDA
{
#region Methods
public void LoadAll(ICollection<WordsObject> WO)
{
string cstr = "Server=localhost;Database=gre;Uid=root;Pwd=nsxr;";
string sql = "SELECT * FROM words";
using (MySqlConnection conn = new MySqlConnection(cstr))
{
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader rdr = null;
try
{
conn.Open();
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
WO.Add(new WordsObject(rdr));
}
}
catch (MySqlException e) { throw; }
finally
{
if (rdr != null)
{
rdr.Close();
}
}
}
}
#endregion Methods
}
//MySql
public class WordsObject
{
#region Constructors
public WordsObject(MySqlDataReader row)
{
this.Word = row["word"] == DBNull.Value ? this.Word : (string)row["word"];
this.Definition = row["definition"] == DBNull.Value ? this.Word : (string)row["definition"];
}
#endregion Constructors
#region Properties
public string Definition
{
get; protected set;
}
public string Word
{
get; protected set;
}
#endregion Properties
}
class Program
{
#region Methods
static void Main(string[] args)
{
/*
List<balObject> bo = new List<balObject>();
balDA bd = new balDA();
//bd.LoadAll(bo);
bd.Insert2(new balObject("",700));
//bd.Update(new balObject("1014", 500));
*/
List<WordsObject> WO = new List<WordsObject>();
WordsDA da = new WordsDA();
da.LoadAll(WO);
foreach (WordsObject w in WO)
Console.WriteLine(w.Word);
//Console.ReadLine();
}
#endregion Methods
}
}
public void LoadSingle(balObject bo)
{
//Change to SP if required
string SQL = "SELECT * FROM bal";
int Result = 0;
using (SqlConnection conn = new SqlConnection(CmdStr))
{
SqlCommand cmd = new SqlCommand(SQL, conn);
//cmd.CommandType=CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("","");
try
{
conn.Open();
Result = (int)cmd.ExecuteScalar();
}
catch (SqlException Ex)
{
throw;
}
}
}
