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