public bool InsertDataPhonebook(PhoneBookData data)
{
bool isOk = false;
int numberID = 1;
DataTable DataList = new DataTable();
cmd.CommandText = "SELECT TOP 1 No FROM PhoneBookSMS ORDER BY No DESC";
adapter = new SqlDataAdapter(cmd);
adapter.Fill(DataList);
foreach (DataRow item in DataList.Rows)
{
numberID = Convert.ToInt32(item["No"]);
}
numberID++;
cmd.CommandText = "INSERT INTO PhoneBookSMS VALUES" +
"('" + numberID + "', '" + data.Name + "'" +
", '" + data.MobileNo + "'" +
", '" + data.Alert + "'" +
", '" + data.Alert1 + "'" +
", '" + data.Alert2 + "'" +
", '" + data.WorkSuspension + "'" +
", '" + data.Fail + "', '" + data.Email + "')";
con.Open();
read = cmd.ExecuteReader();
isOk = read.HasRows ? true : isOk;
read.Close();
con.Close();
return(isOk);
}
//phone book data
public List <PhoneBookData> GetPhoneBookData()
{
List <PhoneBookData> list = new List <PhoneBookData>();
DataTable DataList = new DataTable();
cmd.CommandText = "SELECT * FROM PhoneBookSMS";
adapter = new SqlDataAdapter(cmd);
adapter.Fill(DataList);
foreach (DataRow item in DataList.Rows)
{
PhoneBookData data = new PhoneBookData();
data.No = Convert.ToInt32(item["No"]);
data.Name = item["Name"].ToString();
data.MobileNo = item["MobileNo"].ToString();
data.Alert = (item["Alert Selected"]).ToString();
data.Alert1 = (item["Alarm1 Selected"]).ToString();
data.Alert2 = (item["Alarm2 Selected"]).ToString();
data.WorkSuspension = (item["Work Suspension Selected"]).ToString();
data.Fail = (item["Fail Selected"]).ToString();
data.Email = (item["Email"]).ToString();
list.Add(data);
}
return(list);
}
public static bool UpdateData(string No, string Name, string PhoneNo, string Alert, string Alarm1, string Alarm2, string Work, string Fail, string Email)
{
bool isOk = false;
if (HttpContext.Current.Session["user"] == null)
{
return(isOk);
}
PostDataADO post = new PostDataADO();
PhoneBookData data = new PhoneBookData(Convert.ToInt32(No), Name, PhoneNo, Alert, Alarm1, Alarm2, Work, Fail, Email);
post.UpdateDataPhonebook(data);
isOk = true;
return(isOk);
}
public bool UpdateDataPhonebook(PhoneBookData data)
{
bool isOk = false;
cmd.CommandText = "UPDATE PhoneBookSMS SET " +
"Name = '" + data.Name + "'" +
",MobileNo= '" + data.MobileNo + "'" +
",[Alert Selected] = '" + data.Alert + "'" +
",[Alarm1 Selected] = '" + data.Alert1 + "'" +
",[Alarm2 Selected] = '" + data.Alert2 + "'" +
",[Work Suspension Selected] = '" + data.WorkSuspension + "'" +
",[Fail Selected] = '" + data.Fail + "',Email = '" + data.Email + "' WHERE No = '" + data.No + "'";
con.Open();
read = cmd.ExecuteReader();
isOk = read.HasRows ? true : isOk;
read.Close();
con.Close();
return(isOk);
}
