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