public Int32 Insert(ProductUnitDetails Details)
{
try
{
string SQL = "INSERT INTO tblProductUnit (ProductUnitCode, ProductUnitName) VALUES (@ProductUnitCode, @ProductUnitName);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmProductUnitCode = new MySqlParameter("@ProductUnitCode",MySqlDbType.String);
prmProductUnitCode.Value = Details.ProductUnitCode;
cmd.Parameters.Add(prmProductUnitCode);
MySqlParameter prmProductUnitName = new MySqlParameter("@ProductUnitName",MySqlDbType.String);
prmProductUnitName.Value = Details.ProductUnitName;
cmd.Parameters.Add(prmProductUnitName);
base.ExecuteNonQuery(cmd);
SQL = "SELECT LAST_INSERT_ID();";
cmd.Parameters.Clear();
cmd.CommandText = SQL;
System.Data.DataTable dt = new System.Data.DataTable("ProdUnit");
base.MySqlDataAdapterFill(cmd, dt);
Int32 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int32.Parse(dr[0].ToString());
}
return iID;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Insert(ProductUnitDetails Details)
{
try
{
string SQL = "INSERT INTO tblProductUnit (ProductUnitCode, ProductUnitName) VALUES (@ProductUnitCode, @ProductUnitName);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmProductUnitCode = new MySqlParameter("@ProductUnitCode", MySqlDbType.String);
prmProductUnitCode.Value = Details.ProductUnitCode;
cmd.Parameters.Add(prmProductUnitCode);
MySqlParameter prmProductUnitName = new MySqlParameter("@ProductUnitName", MySqlDbType.String);
prmProductUnitName.Value = Details.ProductUnitName;
cmd.Parameters.Add(prmProductUnitName);
base.ExecuteNonQuery(cmd);
SQL = "SELECT LAST_INSERT_ID();";
cmd.Parameters.Clear();
cmd.CommandText = SQL;
System.Data.DataTable dt = new System.Data.DataTable("ProdUnit");
base.MySqlDataAdapterFill(cmd, dt);
Int32 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int32.Parse(dr[0].ToString());
}
return(iID);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public ProductUnitDetails Details(Int32 ProductUnitID)
{
try
{
string SQL = "SELECT " +
"ProductUnitID, " +
"ProductUnitCode, " +
"ProductUnitName " +
"FROM tblProductUnit " +
"WHERE ProductUnitID = @ProductUnitID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmProductUnitID = new MySqlParameter("@ProductUnitID", MySqlDbType.Int32);
prmProductUnitID.Value = ProductUnitID;
cmd.Parameters.Add(prmProductUnitID);
ProductUnitDetails Details = new ProductUnitDetails();
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.ProductUnitID = ProductUnitID;
Details.ProductUnitCode = "" + dr["ProductUnitCode"].ToString();
Details.ProductUnitName = "" + dr["ProductUnitName"].ToString();
}
return(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(ProductUnitDetails Details)
{
try
{
string SQL = "UPDATE tblProductUnit SET " +
"ProductUnitCode = @ProductUnitCode, " +
"ProductUnitName = @ProductUnitName " +
"WHERE ProductUnitID = @ProductUnitID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmProductUnitCode = new MySqlParameter("@ProductUnitCode", MySqlDbType.String);
prmProductUnitCode.Value = Details.ProductUnitCode;
cmd.Parameters.Add(prmProductUnitCode);
MySqlParameter prmProductUnitName = new MySqlParameter("@ProductUnitName", MySqlDbType.String);
prmProductUnitName.Value = Details.ProductUnitName;
cmd.Parameters.Add(prmProductUnitName);
MySqlParameter prmProductUnitID = new MySqlParameter("@ProductUnitID", MySqlDbType.Int16);
prmProductUnitID.Value = Details.ProductUnitID;
cmd.Parameters.Add(prmProductUnitID);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public ProductUnitDetails Details(Int32 ProductUnitID)
{
try
{
string SQL= "SELECT " +
"ProductUnitID, " +
"ProductUnitCode, " +
"ProductUnitName " +
"FROM tblProductUnit " +
"WHERE ProductUnitID = @ProductUnitID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmProductUnitID = new MySqlParameter("@ProductUnitID",MySqlDbType.Int32);
prmProductUnitID.Value = ProductUnitID;
cmd.Parameters.Add(prmProductUnitID);
ProductUnitDetails Details = new ProductUnitDetails();
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach(System.Data.DataRow dr in dt.Rows)
{
Details.ProductUnitID = ProductUnitID;
Details.ProductUnitCode = "" + dr["ProductUnitCode"].ToString();
Details.ProductUnitName = "" + dr["ProductUnitName"].ToString();
}
return Details;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(ProductUnitDetails Details)
{
try
{
string SQL= "UPDATE tblProductUnit SET " +
"ProductUnitCode = @ProductUnitCode, " +
"ProductUnitName = @ProductUnitName " +
"WHERE ProductUnitID = @ProductUnitID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmProductUnitCode = new MySqlParameter("@ProductUnitCode",MySqlDbType.String);
prmProductUnitCode.Value = Details.ProductUnitCode;
cmd.Parameters.Add(prmProductUnitCode);
MySqlParameter prmProductUnitName = new MySqlParameter("@ProductUnitName",MySqlDbType.String);
prmProductUnitName.Value = Details.ProductUnitName;
cmd.Parameters.Add(prmProductUnitName);
MySqlParameter prmProductUnitID = new MySqlParameter("@ProductUnitID",MySqlDbType.Int16);
prmProductUnitID.Value = Details.ProductUnitID;
cmd.Parameters.Add(prmProductUnitID);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}