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;
}
