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 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 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 { } }