public SmsinfomsgModel FindOne(int ID)
{
SmsinfomsgRepository _repo = new SmsinfomsgRepository();
SmsinfomsgModel theMsg = _repo.FindAll("ID=" + ID.ToString())[0];
this.ID = theMsg.ID;
this.Name = theMsg.Name;
this.Text = theMsg.Text;
this.SmsinfosprID = theMsg.SmsinfosprID;
return(this);
}
public void Create(SmsinfomsgModel theMsg)
{
DBConnection conn = new DBConnection();
try
{
conn.Open();
OracleDataAdapter DataAdapter = new OracleDataAdapter();
OracleCommand cmd = new OracleCommand("PKG_WEB.PR_SMSINFOMSG_CREATE", conn.Connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
OracleParameter p_name = new OracleParameter("p_name", OracleType.VarChar);
p_name.Direction = ParameterDirection.Input;
p_name.Value = theMsg.Name;
cmd.Parameters.Add(p_name);
OracleParameter p_text = new OracleParameter("p_text", OracleType.VarChar);
p_text.Direction = ParameterDirection.Input;
p_text.Value = theMsg.Text;
cmd.Parameters.Add(p_text);
OracleParameter p_spr_id = new OracleParameter("p_spr_id", OracleType.Int32);
p_spr_id.Direction = ParameterDirection.Input;
p_spr_id.Value = theMsg.SmsinfosprID;
cmd.Parameters.Add(p_spr_id);
if (theMsg.NewSprName == null || theMsg.NewSprName == "")
{
cmd.Parameters.AddWithValue("p_new_spr", OracleString.Null);
}
else
{
OracleParameter p_new_spr = new OracleParameter("p_new_spr", OracleType.VarChar);
p_new_spr.Direction = ParameterDirection.Input;
p_new_spr.Value = theMsg.NewSprName;
cmd.Parameters.Add(p_new_spr);
}
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
conn.Close();
}
}
public List <SmsinfomsgModel> FindAll(string condition = "", string order = "")
{
List <SmsinfomsgModel> MsgList = new List <SmsinfomsgModel>();
DBConnection conn = null;
try
{
conn = new DBConnection();
conn.Open();
string strSQL = "SELECT * FROM Smsinfomsg";
if (condition.Length > 0)
{
strSQL = strSQL + " where " + condition;
}
if (order.Length > 0)
{
strSQL = strSQL + " order by " + order;
}
DataTable Table = new DataTable();
conn.ExecQuerySelect(strSQL, ref Table);
for (int i = 0; i < Table.Rows.Count; i++)
{
SmsinfomsgModel theSmsinfomsgModel = new SmsinfomsgModel();
theSmsinfomsgModel.ID = Convert.ToInt32(Table.Rows[i]["ID"].ToString());
theSmsinfomsgModel.Name = Table.Rows[i]["Name"].ToString();
theSmsinfomsgModel.Text = Table.Rows[i]["Text"].ToString();
theSmsinfomsgModel.SmsinfosprID = Convert.ToInt32(Table.Rows[i]["SMSINFOSPR_ID"].ToString());
MsgList.Insert(i, theSmsinfomsgModel);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
finally
{
conn.Connection.Dispose();
conn.Connection.Close();
}
return(MsgList);
}
public void Delete(SmsinfomsgModel theMsg)
{
DBConnection Connection = new DBConnection();
try
{
Connection.Open();
string strSQL = string.Format("DELETE FROM Smsinfomsg WHERE ID = {0}", theMsg.ID);
Connection.ExecQueryInsert(strSQL);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
Connection.Close();
}
}
public void Update(SmsinfomsgModel theMsg)
{
DBConnection Connection = new DBConnection();
try
{
Connection.Open();
string strSQL = string.Format("UPDATE Smsinfomsg SET NAME='{0}', TEXT='{1}', SMSINFOSPR_ID='{2}' WHERE ID = {3}",
theMsg.Name,
theMsg.Text,
theMsg.SmsinfosprID,
theMsg.ID);
Connection.ExecQueryInsert(strSQL);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
Connection.Close();
}
}