public async Task <ReturnedSaveFuncInfo> SaveAsync(PeoplesBankAccountBussines item, SqlTransaction tr) { var res = new ReturnedSaveFuncInfo(); try { var cmd = new SqlCommand("sp_People_BankAccount_Save", tr.Connection, tr) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@guid", item.Guid); cmd.Parameters.AddWithValue("@parentGuid", item.ParentGuid); cmd.Parameters.AddWithValue("@bankname", item.BankName ?? ""); cmd.Parameters.AddWithValue("@accountNumber", item.AccountNumber ?? ""); cmd.Parameters.AddWithValue("@shobe", item.Shobe ?? ""); await cmd.ExecuteNonQueryAsync(); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); res.AddReturnedValue(ex); } return(res); }
private PeoplesBussines LoadData(SqlDataReader dr) { var item = new PeoplesBussines(); try { item.Guid = (Guid)dr["Guid"]; item.Modified = (DateTime)dr["Modified"]; item.Status = (bool)dr["Status"]; item.Name = dr["Name"].ToString(); item.Code = dr["Code"].ToString(); item.Account = (decimal)dr["Account"]; item.AccountFirst = (decimal)dr["AccountFirst"]; item.NationalCode = dr["NationalCode"].ToString(); item.IdCode = dr["IdCode"].ToString(); item.FatherName = dr["FatherName"].ToString(); item.PlaceBirth = dr["PlaceBirth"].ToString(); item.DateBirth = dr["DateBirth"].ToString(); item.Address = dr["Address"].ToString(); item.IssuedFrom = dr["IssuedFrom"].ToString(); item.PostalCode = dr["PostalCode"].ToString(); item.GroupGuid = (Guid)dr["GroupGuid"]; item.ServerDeliveryDate = (DateTime)dr["ServerDeliveryDate"]; item.ServerStatus = (ServerStatus)dr["ServerStatus"]; item.IsModified = true; item.BankList = AsyncContext.Run(() => PeoplesBankAccountBussines.GetAllAsync(item.Guid)); item.TellList = PhoneBookBussines.GetAll(item.Guid, true); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } return(item); }
private async Task LoadDataAsync(Guid parentGuid, string search = "") { try { var list = await PeoplesBankAccountBussines.GetAllAsync(parentGuid, search); peoplesAccountBindingSourcr.DataSource = list.ToSortableBindingList(); } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } }
private PeoplesBankAccountBussines LoadData(SqlDataReader dr) { var res = new PeoplesBankAccountBussines(); try { res.Guid = (Guid)dr["Guid"]; res.BankName = dr["BankName"].ToString(); res.AccountNumber = dr["AccountNumber"].ToString(); res.Shobe = dr["Shobe"].ToString(); res.ParentGuid = (Guid)dr["ParentGuid"]; } catch (Exception ex) { WebErrorLog.ErrorInstence.StartErrorLog(ex); } return(res); }