public string GetHistoryByPostID(int PostID) { string temp = string.Empty; try { Coe25DBDataContext db = new Coe25DBDataContext(); List<tbl_History> history = (from m in db.tbl_Histories where m.PostID == PostID && m.IsFixed == false select m).ToList(); db.Dispose(); history.ForEach(delegate(tbl_History indexHistory) { temp += "Post Id: " + indexHistory.PostID.ToString() + Environment.NewLine; temp += "Date of triggered event: " + indexHistory.CreateDate + Environment.NewLine + Environment.NewLine; }); } catch (Exception ex) { throw ex; } return temp; }
public List<string> getAllPostInHistory() { Coe25DBDataContext db = new Coe25DBDataContext(); List<string> posts = null; List<int> postId = new List<int>(); try { postId = (from m in db.tbl_Histories where m.IsFixed == false select (int)m.PostID).ToList(); if (postId.Count > 0) { this.button1.Enabled = true; posts = new List<string>(); string temp = string.Empty; postId.ForEach(delegate(int index) { temp = "Post Id: " + index.ToString(); if (!IsHistoryIDinList(temp, posts)) posts.Add(temp); }); } else { this.button1.Enabled = false; MessageBox.Show("All Post is Fixed."); this.Close(); } } catch (Exception) { throw; } return posts; }
public List<string> getAllCluster() { Coe25DBDataContext db = new Coe25DBDataContext(); List<string> clusters = new List<string>(); try { clusters = (from m in db.tbl_Clusters select m.UniqueCode).ToList(); } catch (Exception ex) { throw ex; } return clusters; }
public string getUniqueID() { Random rand = new Random(); string temp = string.Empty; string UniqueID = string.Empty; bool running = true; try { Coe25DBDataContext db = new Coe25DBDataContext(); while (running) { temp = rand.Next(0, 9).ToString(); if (!string.IsNullOrEmpty(temp)) { UniqueID = UniqueID + temp; } if (UniqueID.Length == 5) { var dbChecker = (from m in db.tbl_Clusters where m.UniqueCode == UniqueID select m).FirstOrDefault(); if (dbChecker != null) { UniqueID = string.Empty; } else { running = false; break; } } } db.Dispose(); } catch (Exception) { throw; } return UniqueID; }
private void button1_Click(object sender, EventArgs e) { //Fix Button if (PostIdentity != 0) { Coe25DBDataContext db = new Coe25DBDataContext(); List<tbl_History> history = (from m in db.tbl_Histories where m.PostID == PostIdentity && m.IsFixed == false select m).ToList(); if (history.Count > 0) { history.ForEach(delegate(tbl_History hist) { hist.IsFixed = true; }); db.SubmitChanges(); MessageBox.Show("POST is Fix."); SetListBox(); } } }
public void ShowMapByPost() { if (PostIdentity > 0) { Coe25DBDataContext db = new Coe25DBDataContext(); tbl_Map map = (from m in db.tbl_Maps where m.PostID == PostIdentity select m).FirstOrDefault(); if (map != null) { string Url = string.Format("http://localhost:3270/?lat={0}&long={1}&PostDetail={2}",map.Latitude, map.Longitude, PostIdentity); this.webBrowser1.Navigate(Url); } } }
public tbl_Cluster getClusterByText(string Value) { Coe25DBDataContext db = new Coe25DBDataContext(); return db.tbl_Clusters.FirstOrDefault(c => c.UniqueCode == Value); }
private void button3_Click(object sender, EventArgs e) { try { tbl_Cluster cluster = new tbl_Cluster(); cluster.UniqueCode = this.textBox2.Text; cluster.ClusterPhoneNumber = this.textBox1.Text; cluster.CreateDate = DateTime.UtcNow; Coe25DBDataContext db = new Coe25DBDataContext(); db.tbl_Clusters.InsertOnSubmit(cluster); db.SubmitChanges(); db.Dispose(); CreateNewCluster = cluster.UniqueCode; this.Close(); } catch { } }