public static int GetMasterClassDefaultFlag()
{
try
{
using (var conn = new MySqlConnection(Globals.CONN_STR))
{
conn.Open();
var sb = new StringBuilder();
sb.Append("select class_id from master_class");
sb.Append(" where default_flag = 1 order by class_id limit 1 ");
var cmd = new MySqlCommand(sb.ToString(), conn);
var da = new MySqlDataAdapter(cmd);
var ds = new DataSet();
da.Fill(ds);
var masterClass = new MasterClass();
if (ds.Tables[0].Rows.Count > 0)
{
return(Convert.ToInt32(ds.Tables[0].Rows[0]["class_id"]));
}
else
{
return(1);
}
}
}
catch (Exception)
{
throw;
}
}
public static bool Insert(MasterClass masterClass)
{
try
{
using (var conn = new MySqlConnection(Globals.CONN_STR))
{
conn.Open();
var sql = @"INSERT INTO master_class
(class_id,
class_name,
default_flag,
active,
create_by)
VALUES(@class_id,
@class_name,
@default_flag,
@active,
@create_by)";
var cmd = new MySqlCommand(sql, conn);
cmd.Parameters.AddWithValue("class_id", masterClass.ClassId);
cmd.Parameters.AddWithValue("class_name", masterClass.ClassName);
cmd.Parameters.AddWithValue("default_flag", masterClass.DefaultFlag);
cmd.Parameters.AddWithValue("active", masterClass.Active);
cmd.Parameters.AddWithValue("create_by", masterClass.CreateBy);
var affRow = cmd.ExecuteNonQuery();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public static bool Update(MasterClass masterClass)
{
try
{
using (var conn = new MySqlConnection(Globals.CONN_STR))
{
conn.Open();
var sql = @"UPDATE master_class
SET class_name=@class_name,
active=@active,
modified_at=CURRENT_TIMESTAMP,
modified_by=@modified_by
WHERE class_id=@class_id";
var cmd = new MySqlCommand(sql, conn);
cmd.Parameters.AddWithValue("class_id", masterClass.ClassId);
cmd.Parameters.AddWithValue("class_name", masterClass.ClassName);
cmd.Parameters.AddWithValue("active", masterClass.Active);
cmd.Parameters.AddWithValue("modified_by", masterClass.ModifiedBy);
var affRow = cmd.ExecuteNonQuery();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public static MasterClass GetMasterClass(int class_id)
{
try
{
using (var conn = new MySqlConnection(Globals.CONN_STR))
{
conn.Open();
var sb = new StringBuilder();
sb.Append("select * from master_class");
sb.Append(" where class_id = @class_id");
var cmd = new MySqlCommand(sb.ToString(), conn);
cmd.Parameters.AddWithValue("class_id", class_id);
var da = new MySqlDataAdapter(cmd);
var ds = new DataSet();
da.Fill(ds);
var masterClass = new MasterClass();
if (ds.Tables[0].Rows.Count > 0)
{
return(new MasterClass
{
ClassId = (int)ds.Tables[0].Rows[0]["class_id"],
ClassName = ds.Tables[0].Rows[0]["class_name"].ToString(),
DefaultFlag = (bool)ds.Tables[0].Rows[0]["default_flag"],
Active = (bool)ds.Tables[0].Rows[0]["active"],
CreateAt = (DateTime)ds.Tables[0].Rows[0]["create_at"],
});
}
else
{
return(null);
}
}
}
catch (Exception)
{
throw;
}
}