public void UpdateCardVerifuStatus(StatusInfo statusInfo) { using (DataContext _db = new DataContext()) { _db.Database.ExecuteSqlCommand("UPDATE [book].[Cards] SET [juridical_verification] ='" + statusInfo.statusArray[0] + "' where id=" + statusInfo.id); _db.SaveChanges(); } }
public void DeleteStatus(StatusInfo statusInfo) { using (DataContext _db = new DataContext()) { _db.Database.ExecuteSqlCommand("DELETE FROM [dbo].[JuridicalStatus] where card_id=" + statusInfo.id + ""); _db.Database.ExecuteSqlCommand("UPDATE [book].[Cards] SET [juridical_verify_status] ='" + String.Join(",", statusInfo.statusArray.Select(s => s.ToString()).ToArray()) + "' where id=" + statusInfo.id + ""); _db.SaveChanges(); } }
public ReturnJson SaveLogging(StatusInfo statusInfo, int user_id, CardNumID card) { using (DataContext _db = new DataContext()) { using (DbContextTransaction tran = _db.Database.BeginTransaction(System.Data.IsolationLevel.Snapshot)) { try { _db.Loggings.Add(new Logging() { Tdate = DateTime.Now, UserId = user_id, Type = LogType.Card, Mode = LogMode.JuridVerify, TypeValue = card.card_num, TypeId = card.id }); _db.SaveChanges(); tran.Commit(); return(new ReturnJson { Status = _db.Database.SqlQuery <int>($"SELECT s.status FROM dbo.JuridicalStatus s where card_id={statusInfo.id}").ToList(), ID = 1 }); } catch { return(new ReturnJson { Status = null, ID = 0 }); } } } }
public ReturnJson SaveStatusLogic(StatusInfo statusInfo, int user_id) { JuridicalData juridicalStatus = new JuridicalData(); var card = juridicalStatus.CardInfoData(statusInfo.id); if (card != null) { juridicalStatus.DeleteStatus(statusInfo); } if (statusInfo.statusArray.Length == 1) { juridicalStatus.UpdateCardVerifuStatus(statusInfo); } using (DataContext _Db = new DataContext()) { statusInfo.statusArray.Select(st => new SaveStatusInfos(statusInfo.id, user_id, st, _Db). Result()).Select(sl => new SaveLoggings(statusInfo.id, user_id, 1, _Db). Result() ).ToList(); } return(juridicalStatus.SaveLogging(statusInfo, user_id, card)); }
public ReturnJson EndSaveStatus(StatusInfo statusInfo, int user_id) { JuridicalLogic juridicalLogic = new JuridicalLogic(); return(juridicalLogic.SaveStatusLogic(statusInfo, user_id)); }