private void Filler() { PayingTypes payingTypes = new PayingTypes(); payingTypes.ID = 0; payingTypes.PayingTypeName = "Yeni"; this.cbValues.Items.Clear(); this.cbValues.Items.Add((object)payingTypes); this.cbValues.Items.AddRange((object[])PayingTypes.PayingTypes_GetAll().ToArray()); }
public static List<PayingTypes> PayingTypes_GetAll() { string query = "PayingTypes_GetAll"; DataTable dt = Connection.runQuery(query, new SqlParameter[0]); List<PayingTypes> res = new List<PayingTypes>(); for (int i = 0; i < dt.Rows.Count; i++) { PayingTypes tmp = new PayingTypes(); tmp.ID = Convert.ToInt32(dt.Rows[i]["ID"].ToString()); tmp.PayingTypeName = dt.Rows[i]["PayingTypeName"].ToString(); tmp.PreFix = dt.Rows[i]["PreFix"].ToString(); res.Add(tmp); } return res; }
public static PayingTypes PayingTypes_GetByID(int id) { string query = "PayingTypes_GetByID"; List<SqlParameter> prms = new List<SqlParameter>(); prms.Add(new SqlParameter("@ID", id)); DataTable dt = Connection.runQuery(query, prms.ToArray()); PayingTypes res = new PayingTypes(); for (int i = 0; i < dt.Rows.Count; i++) { PayingTypes tmp = new PayingTypes(); tmp.ID = Convert.ToInt32(dt.Rows[i]["ID"].ToString()); tmp.PayingTypeName = dt.Rows[i]["PayingTypeName"].ToString(); tmp.PreFix = dt.Rows[i]["PreFix"].ToString(); res=tmp; } return res; }