I try to send data in table when time exceed over 5 mint data is inserted successfully but data insert multiple times i want to submit data only one time
i.e. only one row insert for 1 number
this is what i try
- if (timediff.TotalMinutes > 5)
- {
- DataClasses1DataContext db = new DataClasses1DataContext();
- var u = db.tbl_urgent_contacts;
- foreach (var a in u)
- {
- tbl_OutBox tb = new tbl_OutBox();
- tb.FromSIM_No = a.SimNo;
- tb.ToSIM_No = a.SimNo;
- tb.ToText = "Check abc";
- tb.Reply = "NA";
- tb.Response = "NA";
- tb.RegNo = "NA";
- tb.Datetd = DateTime.Now;
- tb.FFID = "NA";
- tb.UserId = "You";
- tb.FromText = "Check abc";
- db.tbl_OutBoxes.InsertOnSubmit(tb);
- db.SubmitChanges();
- }
- }