//public void OnTimerCallBack(object state) //{ // //LogMessage("Timer Tick - "); // MSYNC(); //} public void MSYNC() { List <BatchUploadModel> batchids = new List <BatchUploadModel>(); try { using (dc = new shortenURLEntities()) { batchids = (from b in dc.BatchUploadDatas .AsEnumerable() where b.Status == "Insertion Completed" select new BatchUploadModel() { Batchid = b.PK_Batchid, CreatedDate = b.CreatedDate.Value.Date, fk_rid = b.FK_RID, fk_cid = b.FK_ClientID, status = b.Status }).ToList(); //if batchdata available if (batchids.Count != 0) { List <BatchData> batchdata = (from u in dc.UIDDATAs .AsNoTracking() .AsEnumerable() join b in batchids on u.FK_Batchid equals b.Batchid where DateTime.Compare(u.CreatedDate.GetValueOrDefault().Date, b.CreatedDate.GetValueOrDefault().Date) == 0 && u.FK_RID == b.fk_rid && u.FK_ClientID == b.fk_cid && u.UniqueNumber == null && u.FK_Batchid != null select new BatchData() { pk_uid = u.PK_Uid }).ToList(); if (batchdata.Count != 0) { List <BatchData> hashids = (from lb in batchdata select new BatchData() { pk_uid = lb.pk_uid, hashid = GetHashID(lb.pk_uid) }).ToList(); foreach (BatchData i in hashids) { new DataInsertionBO().UpdateHashid(i.pk_uid, i.hashid); } foreach (BatchUploadModel b in batchids) { new DataInsertionBO().UpdateBatchStatus(b.Batchid, "Completed"); } } } } } catch (Exception ex) { ErrorLogs.LogErrorData(ex.StackTrace, ex.InnerException.ToString()); foreach (BatchUploadModel b in batchids) { new DataInsertionBO().UpdateBatchStatus(b.Batchid, "Error Occured"); } } }
public void UpdateBatchStatus(int?batchid, string status) { using (var dc = new shortenURLEntities()) { var res = dc.BatchUploadDatas.SingleOrDefault(x => x.PK_Batchid == batchid); if (res != null) { res.Status = status; dc.SaveChanges(); } } }
public void UpdateHashid(int pk_uid, string hashid) { using (var dc = new shortenURLEntities()) { var res = dc.UIDDATAs.SingleOrDefault(x => x.PK_Uid == pk_uid); if (res != null) { res.UniqueNumber = hashid; dc.SaveChanges(); } } }
public static void LogErrorData(string stackTraceInfo, string message) { try { shortenURLEntities dc = new shortenURLEntities(); ErrorLog objErrorLog = new ErrorLog(); objErrorLog.StackTrace = stackTraceInfo; objErrorLog.ErrorMessage = message; objErrorLog.DateCreated = System.DateTime.Now; dc.ErrorLogs.Add(objErrorLog); dc.SaveChanges(); string err = ""; err = "Error Occured on:" + DateTime.Now.ToString() + "<br>"; err += "Message: " + message; err += "Stack Trace:<br>" + stackTraceInfo; //EmailUtil.SendMail("*****@*****.**", ConfigurationManager.AppSettings["Error Mail"].ToString(), "", "", "Error ShortenURL", " <br>Message : " + err); } catch (Exception ex) { } }