public ClsDestinationData getSingleDestinationData(int destId) { ClsDestinationData destination = new ClsDestinationData(); DataTable dt = new DataTable(); try { string querry = "SELECT * FROM tbl_destinations WHERE destinationId = '" + destId + "';"; dt = CONN.getDataTable(querry); if (dt.Rows.Count > 0) { destination._destId = Convert.ToInt32(dt.Rows[0]["destinationId"]); destination._destName = dt.Rows[0]["destinationName"].ToString(); destination._ownerName = dt.Rows[0]["ownerName"].ToString(); destination._address = dt.Rows[0]["address"].ToString(); destination._phoneNo = dt.Rows[0]["phoneNo"].ToString(); destination._mobile = dt.Rows[0]["mobile"].ToString(); } } catch (Exception ex) { throw ex; } return(destination); }
public bool insertData_destination(ClsDestinationData destination) { bool isOK = false; string querry = string.Empty; try { querry += @"INSERT INTO tbl_destinations (destinationId, destinationName, ownerName, address, phoneNo, mobile) VALUES ("; querry += "'" + destination._destId + "',"; querry += "'" + destination._destName + "',"; querry += "'" + destination._ownerName + "',"; querry += "'" + destination._address + "',"; querry += "'" + destination._phoneNo + "',"; querry += "'" + destination._mobile + "'"; querry += ");"; isOK = CONN.update(querry); } catch (Exception ex) { throw ex; } return(isOK); }
public bool updateData_destination(ClsDestinationData destination) { bool isOK = false; string querry = string.Empty; try { querry += "UPDATE tbl_destinations SET "; querry += "destinationName = '" + destination._destName + "', "; querry += "ownerName = '" + destination._ownerName + "', "; querry += "address = '" + destination._address + "',"; querry += "phoneNo ='" + destination._phoneNo + "', "; querry += "mobile ='" + destination._mobile + "' "; querry += "WHERE destinationId = '" + destination._destId + "'"; isOK = CONN.update(querry); } catch (Exception ex) { throw ex; } return(isOK); }