public ResultDTO Delete(DeleteAccountDTO obj) { ResultDTO accInfo = new ResultDTO(); try { accInfo = _repository.DeleteAccount(obj); } catch (Exception ex) { Utilities.AppLog.WriteLog("DeleteAccount", ActionType.Delete, ex.Message.ToString(), obj.SessionKey); accInfo.StatusCode = Utilities.Common.ConvertErrorCodeToInt(RetCode.ECS9999); accInfo.SetContentMsg(); } return(accInfo); }
public static ResultDTO DeleteAccount(this IEntityBaseRepository <Account> repository, DeleteAccountDTO obj) { var result = new ResultDTO(); var dbContext = new ApplicationContext(); var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int) { Direction = System.Data.ParameterDirection.Output }; if (string.IsNullOrEmpty(obj.UserName) || string.IsNullOrEmpty(obj.SessionKey)) { result.StatusCode = int.Parse(errorCode.Value.ToString(), 0); } else { dbContext.Database.ExecuteSqlCommand("EXEC [dbo].[sp_DeleteAccount] @UserName, @SessionKey, @errorCode out", new SqlParameter("UserName", DB.SafeSQL(obj.UserName)), new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)), errorCode); result.StatusCode = int.Parse(errorCode.Value.ToString(), 0); result.SetContentMsg(); } return(result); }