public void Create(BrancheModel theBranche) { DBConnection Connection = new DBConnection(); try { Connection.Open(); OracleCommand cmd = new OracleCommand("PKG_WEB.PR_BRANCHE_CREATE", Connection.Connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; OracleParameter name_branche = new OracleParameter("name_branche_", OracleType.VarChar); OracleParameter s_name_branche = new OracleParameter("s_name_branche_", OracleType.VarChar); name_branche.Direction = ParameterDirection.Input; s_name_branche.Direction = ParameterDirection.Input; name_branche.Value = theBranche.name_full; s_name_branche.Value = theBranche.name_short; cmd.Parameters.Add(name_branche); cmd.Parameters.Add(s_name_branche); cmd.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { Connection.Close(); } }
public BrancheModel FindOne(int ID) { BrancheRepository _repo = new BrancheRepository(); BrancheModel theBranche = _repo.FindAll(ID)[0]; this.ID = theBranche.ID; this.name_full = theBranche.name_full; this.name_short = theBranche.name_short; return(this); }
public List <BrancheModel> FindAll(Nullable <int> id_brnch = null, string nm_brnch = null, string s_nm_brnch = null, string ord_by = null) { List <BrancheModel> Branche = new List <BrancheModel>(); DBConnection conn = new DBConnection(); try { conn.Open(); OracleDataAdapter DataAdapter = new OracleDataAdapter(); OracleCommand cmd = new OracleCommand("PKG_WEB.PR_BRANCHE_GET", conn.Connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; if (id_brnch == null) { cmd.Parameters.AddWithValue("id_branche_", OracleString.Null); } else { OracleParameter id_branche = new OracleParameter("id_branche_", OracleType.Int32); id_branche.Direction = ParameterDirection.Input; id_branche.Value = id_brnch; cmd.Parameters.Add(id_branche); } if (nm_brnch == null) { cmd.Parameters.AddWithValue("name_branche_", OracleString.Null); } else { OracleParameter name_branche = new OracleParameter("name_branche_", OracleType.VarChar); name_branche.Direction = ParameterDirection.Input; name_branche.Value = nm_brnch; cmd.Parameters.Add(name_branche); } if (s_nm_brnch == null) { cmd.Parameters.AddWithValue("s_name_branche_", OracleString.Null); } else { OracleParameter s_name_branche = new OracleParameter("s_name_branche_", OracleType.VarChar); s_name_branche.Direction = ParameterDirection.Input; s_name_branche.Value = nm_brnch; cmd.Parameters.Add(s_name_branche); } Nullable <int> brnchs_user_id = UserModel.CurrentUserId; if (AccessActions.IsAccess("SuperUser")) { brnchs_user_id = null; } if (brnchs_user_id == null) { cmd.Parameters.AddWithValue("branches_user_id_", OracleString.Null); } else { OracleParameter branches_user_id = new OracleParameter("branches_user_id_", OracleType.Int32); branches_user_id.Direction = ParameterDirection.Input; branches_user_id.Value = brnchs_user_id; cmd.Parameters.Add(branches_user_id); } if (ord_by == null) { cmd.Parameters.AddWithValue("order_by_", OracleString.Null); } else { OracleParameter order_by = new OracleParameter("order_by_", OracleType.VarChar); order_by.Direction = ParameterDirection.Input; order_by.Value = ord_by; cmd.Parameters.Add(order_by); } cmd.Parameters.Add("t_list", OracleType.Cursor).Direction = System.Data.ParameterDirection.Output; DataAdapter.SelectCommand = cmd; try { DataTable Table = new DataTable(); DataAdapter.Fill(Table); for (int i = 0; i < Table.Rows.Count; i++) { BrancheModel theBranche = new BrancheModel(); theBranche.ID = Convert.ToInt32(Table.Rows[i]["ID"].ToString()); theBranche.name_full = Table.Rows[i]["NAME"].ToString(); theBranche.name_short = Table.Rows[i]["S_NAME"].ToString(); Branche.Insert(i, theBranche); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } finally { conn.Connection.Dispose(); conn.Connection.Close(); } return(Branche); }
public List <BrancheModel> BranchesUser(Nullable <int> id_usr_ = null, Nullable <int> id_ = null, string name_ = null, string s_name_ = null, string ordr_by_ = null) { List <BrancheModel> Branche = new List <BrancheModel>(); DBConnection conn = new DBConnection(); try { conn.Open(); OracleDataAdapter DataAdapter = new OracleDataAdapter(); OracleCommand cmd = new OracleCommand("PKG_WEB.PR_USER_BRANCHES_GET", conn.Connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; if (id_usr_ == null) { cmd.Parameters.AddWithValue("id_user_", OracleString.Null); } else { OracleParameter id_user = new OracleParameter("id_user_", OracleType.Int32); id_user.Direction = ParameterDirection.Input; id_user.Value = id_usr_; cmd.Parameters.Add(id_user); } if (id_ == null) { cmd.Parameters.AddWithValue("id_branche_", OracleString.Null); } else { OracleParameter id_branche = new OracleParameter("id_branche_", OracleType.Int32); id_branche.Direction = ParameterDirection.Input; id_branche.Value = id_; cmd.Parameters.Add(id_branche); } if (name_ == null) { cmd.Parameters.AddWithValue("name_brahcne_", OracleString.Null); } else { OracleParameter name_brahcne = new OracleParameter("name_brahcne_", OracleType.VarChar); name_brahcne.Direction = ParameterDirection.Input; name_brahcne.Value = name_; cmd.Parameters.Add(name_brahcne); } if (s_name_ == null) { cmd.Parameters.AddWithValue("s_name_brahcne_", OracleString.Null); } else { OracleParameter s_name_brahcne = new OracleParameter("s_name_brahcne_", OracleType.VarChar); s_name_brahcne.Direction = ParameterDirection.Input; s_name_brahcne.Value = s_name_; cmd.Parameters.Add(s_name_brahcne); } if (ordr_by_ == null) { cmd.Parameters.AddWithValue("order_by_", OracleString.Null); } else { OracleParameter order_by_ = new OracleParameter("order_by_", OracleType.VarChar); order_by_.Direction = ParameterDirection.Input; order_by_.Value = ordr_by_; cmd.Parameters.Add(order_by_); } cmd.Parameters.Add("t_list", OracleType.Cursor).Direction = System.Data.ParameterDirection.Output; DataAdapter.SelectCommand = cmd; try { DataTable Table = new DataTable(); DataAdapter.Fill(Table); for (int i = 0; i < Table.Rows.Count; i++) { BrancheModel theBranche = new BrancheModel(); theBranche.ID = Convert.ToInt32(Table.Rows[i]["ID"].ToString()); theBranche.name_full = Table.Rows[i]["NAME"].ToString(); theBranche.name_short = Table.Rows[i]["S_NAME"].ToString(); Branche.Insert(i, theBranche); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } finally { conn.Connection.Dispose(); conn.Connection.Close(); } return(Branche); }