public void Create(SmsinfosprModel theSpr)
{
DBConnection Connection = new DBConnection();
try
{
Connection.Open();
UserModel theUser = new UserModel();
theUser.FindByID(UserModel.CurrentUserId);
string strSQL = string.Format("INSERT INTO SMSINFOSPR(ID, NAME, PARENT_ID, BRANCHE_ID) VALUES(s_smsinfospr.nextval, '{0}', '{1}','{2}')",
theSpr.Name,
theSpr.ParentID,
theUser.BrancheID);
Connection.ExecQueryInsert(strSQL);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
Connection.Close();
}
}
public SmsinfosprModel FindOne(int ID)
{
SmsinfosprRepository _repo = new SmsinfosprRepository();
SmsinfosprModel theSpr = _repo.FindAll("ID=" + ID.ToString())[0];
this.ID = theSpr.ID;
this.Name = theSpr.Name;
this.ParentID = theSpr.ParentID;
return(this);
}
public List <SmsinfosprModel> FindAll(string condition = "", string order = "")
{
List <SmsinfosprModel> SprList = new List <SmsinfosprModel>();
DBConnection conn = null;
try
{
conn = new DBConnection();
conn.Open();
UserModel theUser = new UserModel();
theUser.FindByID(UserModel.CurrentUserId);
string strSQL = "SELECT * FROM SMSINFOSPR where BRANCHE_ID = " + theUser.BrancheID;
if (condition.Length > 0)
{
strSQL = strSQL + " and " + 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++)
{
SmsinfosprModel theSmsinfosprModel = new SmsinfosprModel();
theSmsinfosprModel.ID = Convert.ToInt32(Table.Rows[i]["ID"].ToString());
theSmsinfosprModel.Name = Table.Rows[i]["Name"].ToString();
theSmsinfosprModel.ParentID = Convert.ToInt32(Table.Rows[i]["PARENT_ID"].ToString());
SprList.Insert(i, theSmsinfosprModel);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
finally
{
conn.Connection.Dispose();
conn.Connection.Close();
}
return(SprList);
}
public void Delete()
{
SmsinfosprRepository _repo = new SmsinfosprRepository();
List <SmsinfosprModel> listResult = new List <SmsinfosprModel>();
listResult = FindAll("PARENT_ID=" + this.ID);
if (listResult.Count > 0)
{
for (int i = 0; i < listResult.Count; i++)
{
SmsinfosprModel item = listResult[i];
item.Delete();
}
}
_repo.Delete(this);
}
public void Delete(SmsinfosprModel theSpr)
{
DBConnection Connection = new DBConnection();
try
{
Connection.Open();
string strSQL = string.Format("DELETE FROM SMSINFOSPR WHERE ID = {0}",
theSpr.ID);
Connection.ExecQueryInsert(strSQL);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
Connection.Close();
}
}
public void Update(SmsinfosprModel theSpr)
{
DBConnection Connection = new DBConnection();
try
{
Connection.Open();
string strSQL = string.Format("UPDATE SMSINFOSPR SET NAME='{0}', PARENT_ID='{1}' WHERE ID = {2}",
theSpr.Name,
theSpr.ParentID,
theSpr.ID);
Connection.ExecQueryInsert(strSQL);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
Connection.Close();
}
}