public static List<Telephones> Telephones_GetAll()
{
string query = "Telephones_GetAll";
DataTable dt = Connection.runQuery(query, new SqlParameter[0]);
List<Telephones> res = new List<Telephones>();
for (int i = 0; i < dt.Rows.Count; i++)
{
Telephones tmp = new Telephones();
tmp.ID = Convert.ToInt32(dt.Rows[i]["ID"].ToString());
tmp.CustomerID = Convert.ToInt32(dt.Rows[i]["CustomerID"].ToString());
tmp.TelType = Convert.ToInt32(dt.Rows[i]["TelType"].ToString());
tmp.TelNo = dt.Rows[i]["TelNo"].ToString();
tmp.Status = (Status)Convert.ToInt32(dt.Rows[i]["Status"].ToString());
res.Add(tmp);
}
return res;
}
public static List<Telephones> Telephones_GetByCustomerID(long customerID)
{
string query = "Telephones_GetByCustomerID";
List<SqlParameter> prms = new List<SqlParameter>();
SqlParameter prms1 = new SqlParameter("@CustomerID", customerID);
prms.Add(prms1);
DataTable dt = Connection.runQuery(query, prms.ToArray());
List<Telephones> res = new List<Telephones>();
for (int i = 0; i < dt.Rows.Count; i++)
{
Telephones tmp = new Telephones();
tmp.ID = Convert.ToInt32(dt.Rows[i]["ID"].ToString());
tmp.CustomerID = Convert.ToInt32(dt.Rows[i]["CustomerID"].ToString());
tmp.TelType = Convert.ToInt32(dt.Rows[i]["TelType"].ToString());
tmp.TelNo = dt.Rows[i]["TelNo"].ToString();
tmp.Status = (Status)Convert.ToInt32(dt.Rows[i]["Status"].ToString());
res.Add(tmp);
}
return res;
}
private void btnTelSave_Click(object sender, EventArgs e)
{
if (this.customerID == 0L)
{
Telephones telephones = new Telephones();
telephones.CustomerID = 0L;
telephones.Status = Status.Active;
telephones.TelNo = this.txtTel.Text;
if (this.lbTelephoneTypes.SelectedItems.Count == 0)
{
int num = (int)MessageBox.Show("Telefon Tipi Seçiniz");
}
else
{
telephones.TelType = ((TelTypes)this.lbTelephoneTypes.SelectedItem).ID;
for (int index = 0; index < this.tels.Count; ++index)
{
if (telephones.TelType == this.tels[index].TelType)
this.tels.RemoveAt(index);
}
this.tels.Add(telephones);
}
}
else
Telephones.Telephones_Insert(this.customerID, ((TelTypes)this.lbTelephoneTypes.SelectedItem).ID, this.txtTel.Text, 2);
}